Configuring Relational and Application Connections in Informatica Workflow Manager
Installing and Setting Up Oracle BI Applications
4-67
c.
Click OK to save the details.
Notes:
If the target database is Oracle or DB2, use the following settings:
Click New, select the appropriate database type, and then click OK.
Name: DataWarehouse, for connection to the Oracle Business Analytics
Warehouse.
You must specify 'DataWarehouse' exactly as it appears in the Physical
Data Sources tab in the DAC Setup View. For the connection to the OLTP,
specify the name exactly as it appears in the Physical Data Sources tab in
the DAC Setup view. For example, if your source system is Siebel release
7.8.x, then you name this connection as SEBL_78. For more information,
see
Section 4.11.3, "Setting Physical Data Sources"
.
User Name: Database user name with the appropriate read and write
database permissions to access the database.
Password: Password for the user name.
Connect string: Connect string used to communicate with the database
(refer to the Informatica Help for information about specifying this value).
Code Page: Code page compatible with the code page of the database
client. If NLS_LANG (for Oracle database) or DB2CODPAGE (for DB2
database) has been set, then the Code Page value should be a code page
compatible with the language set by these variables. For more
information, see
Section 4.3.3, "Code Page and Data Movement
Requirements"
.
If the target database is SQL Server, use the following settings:
Click New and select the type as ODBC, then click OK.