Installation and Configuration Guide

Back Next

Step 3. Configure Data Integration Hub Repositories

On the

Metadata Repository

page, select one of the following options:

Create a Data Integration Hub repository

. Creates a repository in the database.

Use an existing Data Integration Hub repository

. Uses the tables and data in an existing

Data Integration Hub

repository and upgrades the repository.

Click

The

Metadata Repository Connection

page appears.

Enter values in the following fields:

Database type: Type of database to use for the
Data Integration Hub
metadata repository. You can choose one of the following options:
Oracle
Microsoft SQL Server

Database URL: Location of the database.
If you select this option, enter the values in the following fields:

Database host name
. Host name of the machine where the database server is installed.

Database port
. Port number for the database. The default port number for Oracle is 1521. The default port number for Microsoft SQL Server
or Microsoft Azure SQL Database
is 1433.

Database SID
. System identifier for the database if the database is Oracle. Enter either a fully qualified ServiceName or a fully qualified SID.
It is recommended that you enter a ServiceName in this field.

Microsoft SQL Server database

or
Microsoft Azure SQL Database
. Database name.

Custom Connection String: Connection string to the database.
If you select this option, enter values in one of the following fields:

JDBC string
. JDBC connection string to the metadata repository.

ODBC string
. ODBC connection string to the metadata repository. Available if you install the PowerCenter Client plug-in. The installer cannot verify the validity of the ODBC string.

If you use a named Microsoft SQL Server database instance, you cannot connect to the database instance using the
Database URL
option. Use the
Custom Connection String
option.
For example:

jdbc:informatica:sqlserver://MYSQLSERVERCOMPUTERHOSTNAME\MYDBINSTANCENAME;DatabaseName=MYDATABASENAME;

Use Windows Authentication: Instructs
Data Integration Hub
to authenticate user names against the Microsoft Windows authentication mechanism. Available when you select a Microsoft SQL Server database.

Database username: Name of the database user account for the database where you do not use Windows authentication.

Database user password: Password for the database account for the database where you do not use Windows authentication.
Data Integration Hub
stores the password as an encrypted string.

Click

The

Publication Repository Connection

page appears.

Enter values in the following fields:

Database type: Type of database to use for the publication repository. The database type must match the
Data Integration Hub
metadata repository database type and appears in read-only mode.

Database URL: Location of the database.
If you select this option, enter values in the following fields:

Database host name
. Host name of the machine where the database server is installed.

Database port
. Port number for the database. The default port number for Oracle is 1521. The default port for Microsoft SQL Server
or Microsoft Azure SQL Database
1433.

Database SID
. System identifier for the database if the database is Oracle. Enter either a fully qualified ServiceName or a fully qualified SID.
It is recommended that you enter a ServiceName in this field.

Microsoft SQL Server database

or
Microsoft Azure SQL Database
. Name of the database instance.

Custom Connection String: JDBC connection string to the database.
If you use a named Microsoft SQL Server database instance, you cannot connect to the database instance using the
Database URL
option. Use the
Custom Connection String
option.

Use Windows Authentication: Instructs
Data Integration Hub
to authenticate user names against the Microsoft Windows authentication mechanism. Available when you select a Microsoft SQL Server database.

Database username: Name of the database user account for the database where you do not use Windows authentication.

Database user password: Password of the database account for the database where you do not use Windows authentication.
Data Integration Hub
stores the password as an encrypted string.

Click

If you selected the

Data Integration Hub Dashboard and Reports

component, the

Operational Data Store

page appears. If you did not select the Dashboard and Reports component, go to Step 5. Configure Document Store and Web Server.

Watch

Comments