Installation and Configuration Guide

Back Next

Step 3. Configure B2B Data Exchange Repository

In the

Metadata Repository

section, enter the number for the metadata repository database configuration option or accept the default option:

1- Create a B2B Data Exchange repository: Creates a repository in the database.

2- Use an existing B2B Data Exchange repository: Uses the tables and data in an existing repository.

Press

Enter

The

Metadata Repository Connection

section appears.

Enter

to use an Oracle database as the

B2B Data Exchange

metadata repository database.

Enter the number for the metadata repository database connection type 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.
Database SID. System identifier for the database.

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 metadata repository.
ODBC string. ODBC connection string to the metadata repository. Applicable 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;

Enter values in the following fields:

Database username: Name of the database user account for the Oracle database or the Microsoft SQL Server database.

Database user password: The password for the database account for the Oracle database or the Microsoft SQL Server database.
B2B Data Exchange
stores the password as an encrypted string.

Press

Enter

If you selected to install the

B2B Data Exchange

Dashboard and Reports component, the

Operational Data Store

section appears. If you did not select to install the Dashboard and Reports component, go to Step 5. Configure the Web Server and Port Numbers.