Installation and Configuration Guide

Back Next

Step 4. Set Up the Operational Data Store

On the

Operational Data Store

page, select one of the following options:

Create an operational data store repository

. Creates an operational data store repository in the database.

Use an existing operational data store repository

. Uses the tables and data in an existing operational data store repository.

Click

The

Operational Data Store Database Connection

page appears.

Enter values in the following fields:

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 number
. Port number for the database. The default port number for an Oracle database is 1521. The default port number for a Microsoft SQL server
or a Microsoft Azure SQL database
is 1433.

Database SID
. System identifier for the database if you select Oracle as the database. 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 Operational Data Store.

ODBC string
. ODBC connection string to the Operational Data Store. 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 operational data store user account for the database where you do not use Windows authentication.

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

Click

The

User Authentication

page appears.

Watch

Comments