Installation and Configuration Guide

Back Next

Step 4. Set Up the Operational Data Store

In the

Operational Data Store

section, enter the number for the database configuration option for the operational data store or accept the default option:

1- Create an operational data store repository: Creates an operational data store repository in the database.

2- Use an existing operational data store repository: Uses the tables and data in an existing operational data store repository.

Enter the number for the database connection type for the operational data store or accept the default connection type:

1- 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 number
. Port number for the database. The default port number for Oracle is 1521. The default port for Microsoft SQL Server is 1433.
Oracle database
. Database SID. System identifier for the database.

Microsoft SQL Server database
. Database name. Name of the database instance.

2- 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. 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;