ODBC Connection

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:

On Windows PC:

  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:
    • Data Source Name: your choice
    • TNS Service name: ORCL
    • 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.
    4. Select System DSN tab and click on Add
    5. Select the driver Oracle in OraDB10g_home
    6. Then click Finish.
    7. Enter the following details:
      • Data Source Name: your choice
      • TNS Service name: ORCL
      • User Id: Scott
  1. 8. Then click on Test Connection
  2. 9. Enter password and finally click on Ok.