Connect to Oracle Using Oracle Connection Manager from Informatica Developer

Back Next

Step 1. Create the tnsnames.ora File

To connect to Oracle using Oracle Connection Manager, you must create a

tnsnames.ora

file with the Oracle Connection Manager details on the Informatica Server and Client machines.

Define the net service name entry for the Oracle Connection Manager service. The definition must contain the keyword-value pair SOURCE_ROUTE=YES.

See the following sample

tnsnames.ora

file with the Oracle Connection Manager service entry:

ORCL19C_CMAN =
(description=
   (address_list=
     (source_route=yes)
     (address=(protocol=tcp)(host=inrh74ocm.mycompany.com)(port=1521))
     (address=(protocol=tcp)(host=inrh74oradb.mycompany.com)(port=1521))
   )
 (connect_data=
    (service_name=ORCL19C.mycompany.com)
   )
)

Add the

tnsnames.ora

file in the Informatica Client and Informatica Server machines in the following directories:

Informatica Client:

<Informatica Client Installation Directory>\clients\DeveloperClient

Informatica Server:

<Informatica Server Installation Directory>\tomcat\bin

In the Informatica Server machine, set the TNS_ADMIN environment variable to the directory where the

tnsnames.ora

is available.

Connect to Oracle Using Oracle Connection Manager from Informatica Developer

Download Guide