Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Process of Configuring and Managing the Informatica Repository >

Process of Configuring the Informatica Repository in Workflow Manager

Follow this procedure to configure the Informatica repository in Informatica Workflow Manager.

To configure the server properties for the Informatica repository in Workflow Manager

1. Launch Informatica Workflow Manager.
2. In the Repositories list, select the Informatica repository.
3. Choose Repository > Connect.

   The Connect to Repository window opens.

4. Log in using the username and password you entered in Setting Up the Informatica Server and Informatica Repository Server (for example, with the user name Administrator).
5. Click Connect.
6. Once connected, double-click the icon of the server name (ORACLE_BI_DW_SERVER is the recommended server name) under the repository icon.

   The Server dialog box opens.

7. In the Host Name field, enter the computer name (as shown in the Network control panel) of the machine running the Informatica Server.
8. Click Resolve Server to confirm the computer name and update the IP address.
9. (Optional) Configure the Code Page setting.

   NOTE:  If the Informatica Server uses ENU Windows, leave the setting unchanged. For localized environments, choose the appropriate setting.

10. Click Advanced to expose the Server Variables list.
11. Make sure that the $PMRootDir variable points to the directory where the Informatica Server is installed.
12. Make sure that the $PMSourceFileDir points to the location mentioned in DAC > Setup > DAC System Properties > InformaticaParameterFileLocation. Also make sure that this location has no spaces in its path (the default path the \SrcFiles\ folder in the Informatica installation folder).

    NOTE:  If you install the Informatica Server on a machine different from the recommended configuration, make sure to update the $PMRootDir variable with the new location.

13. Close the Server window.

To configure the database connections

1. In Informatica Workflow Manager, choose to Connections > Relational to display the Relational Connection Browser.
2. Create a connection for the target data warehouse, as follows:
   1. Click New, select the appropriate sub-type, then click OK to display the Relational Connection Editor.
      
   2. If the target database is Oracle, DB2, or Teradata, use the settings as follows:
      • Click New and select the type as Oracle, DB2, or Teradata, then click OK.
      • Name: DataWarehouse (exactly as specified under DAC >setup>Physical Data sources for Data Warehouse).
      • User Name: Table Owner.
      • Password: TBO password.
      • Connect string: Connect string for the connecting to the database.
      • Code Page: UTF-8 encoding of Unicode if the database is unicode.
   3. If the target database is SQL Server, use the settings as follows:
      • Click New and select the type as ODBC, then click OK.
      • Name: DataWarehouse (type in the name exactly as specified under DAC > Setup > Physical Data sources for your OLTP (for example, if your source system is Siebel ver 7.8.x then you name this connection as SEBL_78).
      • User Name: Table Owner.
      • Password: TBO password.
      • Connect string: Connect string for the connecting to the database.
      • Code Page: UTF-8 encoding of Unicode if the database is unicode.
3. Create connections for the source warehouse, as follows:
   1. Click New, select the appropriate sub-type, then click OK to display the Relational Connection Editor.
      
   2. If the target database is Oracle, DB2, use the settings as follows:
      • Click New and select the type as Oracle or DB2, then click OK.
      • Name: Type in the name exactly as specified under DAC > Setup > Physical Data sources for your OLTP (for example, if your source system is Siebel ver 7.8.x then you name this connection as SEBL_78).
      • User Name: Table Owner.
      • Password: TBO password.
      • Connect string: Connect string for the connecting to the database.
      • Code Page: UTF-8 encoding of Unicode if the database is unicode.
   3. If the target database is SQL Server, use the settings as follows:
      • Click New and select the type as ODBC, then click OK.
      • Name: Type in the name exactly as specified under DAC > Setup > Physical Data sources for your OLTP (for example, if your source system is Siebel ver 7.8.x then you name this connection as SEBL_78).
      • User Name: Table Owner.
      • Password: TBO password.
      • Connect string: Connect string for the connecting to the database.
      • Code Page: UTF-8 encoding of Unicode if the database is unicode.
4. Click Close to close the Relational Connection Browser.

To configure the Informatica repository in the Workflow Manager for Teradata external loader connections

1. In Informatica Workflow Manager, choose Connections > Loader to open the Loader Connection Browser.
2. In the Objects window, select Teradata_Tpump_Upsert, and then click Edit.
3. Edit the User Name, Password, TDPID, Database Name, and other attributes as necessary.
4. Repeat these steps for the following objects:
   • Teradata_Tpump_Update
   • Teradata_Tpump_Insert
   • Teradata_Tpump_Delete
   • Teradata_FastLoad
5. For Unicode environments, append -c UTF8 to the value for the External Loader Executable attribute for each external loader.

   For example:

   • fastload -c UTF8
   • tpump -c UTF8
6. Click Close to close the Loader Connection Browser.