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 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
. 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
B2B Data Exchange
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.
B2B Data Exchange
stores the password as an encrypted string.

Click

If you create a repository in the database, the

User Authentication

page appears.

If you select an existing repository, the installer selects the existing authentication method. Go to Step 6. Configure Document Store, Web Server, and Port Numbers.