Installation and Configuration Guide

Back Next

Step 3. Configure the B2B Data Exchange Repository

On the

Metadata Repository

page, select one of the following options:

Create a B2B Data Exchange repository

. Creates a repository in the database.

Use an existing B2B Data Exchange repository

. Uses the tables and data in an existing

B2B Data Exchange

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
B2B Data Exchange
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 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
. 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
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 database user account for the Oracle database or Microsoft SQL Server database where you do not use Windows authentication.

Database user password: Password for the database account for the Oracle database or Microsoft SQL Server database where you do not use Windows authentication.
B2B Data Exchange
stores the password as an encrypted string.

Click

If you selected the

B2B Data Exchange 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 User Authentication.