Registering Informatica Services in DAC

Registering Informatica Services in DAC

This section explains how to register the Informatica Integration Service and the Informatica Repository Service in DAC.

When you register Informatica Services in DAC, note the following:

• You can register multiple Integration Service services, but you must register at least one service.
• You must register one Repository Service. You should only register one Repository Service.

Tip:

To locate Informatica services properties that you may need to complete this procedure, log into the Informatica Administrator and select the appropriate service.

To register Informatica Services in DAC

1. In the DAC Setup view, click the Informatica Servers tab.
2. For the Informatica Integration Service that you want to register, do the following:
   
   1. Modify the record with Name = INFORMATICA_DW_SERVER by entering the following information in the Edit subtab:
      

      Field	Description
      Name	Enter a logical name for the Integration Service.
      Type	Select Informatica.
      Service	Enter the name of the Integration Service as specified in the Informatica domain (as seen in Informatica Administrator).
      Domain	Enter the Informatica domain name (as seen in Informatica Administrator).
      Login	Informatica repository user name who has Administrator privileges for the Informatica repository. Note: DAC must log in to Informatica as an Informatica repository Administrator user that is configured in the native security domain.
      Password	Password for the user specified in the Login field.
      Num Parallel Workflows per EP	Maximum number of workflows that can be executed in parallel on the Informatica Integration Service. If the number of sessions is zero or is not specified, the DAC Server assigns the default value of 10.
      Repository Name	Name of the Informatica Repository Service that manages the Informatica repository for Oracle BI Applications.
      Inactive	Indicates whether the Integration Service will participate in the ETL process.

   2. Click Test Connection to make sure that the connection works.
      Note: The Integration Service must be running.
   3. Click Save to save the details.
3. For the Informatica Repository Service you want to register, do the following:
   
   1. Modify the record with Name = INFORMATICA_REP_SERVER by entering the following information in the Edit subtab:
      

      Field	Description
      Name	Enter a logical name for the Repository Service.
      Type	Select Repository.
      Hostname	Enter the name of the Informatica Gateway Host machine.
      Server Port	Enter the Gateway port (as specified during the installation of Informatica PowerCenter Services).
      Login	Informatica repository user name who has Administrator privileges for the Informatica repository.
      Password	Password for the user specified in the Login field.
      Num Parallel Workflows per EP	Maximum number of workflows that can be executed in parallel on the Informatica Integration Service. If the number of sessions is zero or is not specified, the DAC Server assigns the default value of 10.
      Repository Name	Name of the Informatica Repository Service that manages the Informatica repository for Oracle BI Applications.
      Inactive	Indicates whether the Repository Service will participate in the ETL process.

   2. Click Test Connection to make sure that the connection works.
      Note: The Repository Service must be running.
   3. Click Save to save the details.