This was one of the most challenging parts.
Problem – You need to make an Oracle connection at
Informatica level so that you may use the same for read/write.
Solution
1.
For Linux and Windows , you need to Install
Oracle client (admin version) freely downloadable from the OTN.
a.
Be careful about the bit compatibility, the
oracle client and Informatica server bit should be same i.e. 64 bit or 32 bit
2.
Once you have installed the oracle client in the
Windows/Linux box along with the Informatica server, you need to make the following
environment variable entries:
- PATH=$PATH/home/oracle/app/oracle/product/11.2.0/client_1/bin
- ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_1
- ORACLE_BASE=/home/oracle/app/oracle
- LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.2.0/client_1/lib
- TNS_ADMIN=$ORACLE_HOME/network/admin
Preferably you may make these entries at Informatica
Administrator>Repository Services>Process tab>Env variables level.
3.
Now to connect to oracle database from
Informatica, we can either use ODBC connection or Oracle connection.
a.
Connecting using Oracle drivers
i.
Make the TNS entry in the tnsnames.ora
file,assuming the connection string name=Conn_string
ii.
At the workflow manager level you need to
Connections>Relational Connections>Make new Connection
1.
You will have option of Oracle or ODBC
connection, make Oracle connection for TNS entry
2.
Type in the credentials and make the connection string
as Conn_string
same as TNS entry.
b.
Connecting using ODBC drivers (Approach not
applicable for Linux only for Windows)
i.
You need to go to> Start>Administrative
Tools>ODBC Data Sources>System DSN
ii.
Make a new System DSN give the DSN Name as Conn1
iii.
At the workflow manager level you need to
Connections>Relational Connections>Make new Connection
1.
You will have option of Oracle or ODBC
connection, make ODBC Connection
2.
Name the Connection String as Conn1
No comments:
Post a Comment