Configuring Relational Connections in Informatica Workflow Manager

Configuring Relational Connections in Informatica Workflow Manager

The Informatica Integration Service requires database connection information for the source and target databases. You use Informatica Workflow Manager to configure the database connections. The connections you configure in Informatica map to physical data source definitions in DAC, as specified in the Physical Data Sources tab of the Setup view. DAC also specifies the name of the Informatica database connection in the parameter file that is generated for the workflow when an ETL process is executed.

Note: The name for the connection specified in Informatica must match the name of the physical data source in DAC to which it maps.

To configure relational connections in Informatica Workflow Manager

1. In Informatica PowerCenter Workflow Manager, connect to the repository.
2. Select Connections, and then select Relational.
   The Relational Connection Browser is displayed.
3. Create a connection for each transactional (OLTP) database, and a connection for the Oracle Business Analytics Warehouse (OLAP) database. For each database connection, do the following:
   
   1. Click New to display the Select Subtype dialog.
   2. Select the appropriate database type, and click OK.
      The Connection Object Definition dialog displays options appropriate to the specified database type.
   3. Define the relational connection.
      Name: Enter a name for the database connection exactly as it appears in the Physical Data Sources tab in the DAC Setup View.
      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 online 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.
   4. Click OK to save the details.