ODBC Connection in Informatica

ODBC Connection in Informatica

ODBC stands for Open Data Base Connectivity. An ODBC is a middleware or an interface 

which allows you any database to Informatica.

How to create an ODBC in Informatica

For creating an ODBC, we can follow two methods:

1. Go to Control Panel => Administrative Tools =>Data Souces (ODBC)
2. Select System DSN tab and click on Add
3. Select the driver Oracle in OraDB10g_home
4. Then click Finish.
5. Enter the following details:

o    Data Source Name: Source_Scott_ODBC (your choice)

o    TNS Service name: ORCL

o    User Id: Scott

6. Then click on Test Connection
7. There enter password and finally click on Ok.

Or you can also creating an ODBC from Informatica level as follows:

1.                   While Creating the target, first we need impliment the metadata of the target by drag the source in

2.                   Target Designer and then Generate/Execute SQL.

3.                   Click on Connect then click on Add.

1. Select System DSN tab and click on Add

2. Select the driver Oracle in OraDB10g_home
3. Then click Finish.

4. Enter the following details:
• Data Source Name: Source_Scott_ODBC (your choice)
• TNS Service name: ORCL
• User Id: Scott

5. Then click on Test Connection
6. There enter password and finally click on 
7. Ok.