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.
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 database where you do not use Windows authentication.
Database user password
Password for the database account for the database where you do not use Windows authentication.