Configuring Repository Connections on PowerCenter Version 10.4.x and 10.5.x
Configuring Repository Connections on PowerCenter Version 10.4.x and 10.5.x
If you use the Dashboard and Reports component, your
B2B Data Exchange
and operational data store repositories are installed on Microsoft SQL Servers, and you use PowerCenter version 10, configure the repository connections in PowerCenter Workflow Manager.
In the Workflow Manager, access the DX_REPO database connection and open the
Connection Object Definition
dialog box.
Perform the following actions and then click
OK
:
Select
Use DNS
.
For Windows: In the
Connect String
text box enter the connection name. The name is defined in the ODBC Data Source Administrator interface, in ODBC SQL Server Wire Protocol Setup, in the
Data Source Name
field.
For Linux: Enter the database connection details in the odbc.ini file located in the PowerCenter installation directory. Then, use the same connection name in the