Using a Database Link for ETL

Set up direct links to replace the default Open Database Connectivity (ODBC) links to improve ETL performance.

When the source database is Oracle, you can use Database Link Mode and create a compatible DB Link from the Oracle Warehouse to the source. The Loading Knowledge Module (LKM) assumes that a database link already exists with the following naming convention: <DATASERVER_NAME>.WORLD@DSN_<DSN_ID>. This database link must exist in the warehouse and be accessible using the warehouse credentials (user specified against the warehouse connection in ODI).

To use a database link for ETL:

  1. Have a database administrator create a private database link.
  2. In Configuration Manager, update the ETL_SRC_VIA_DBLINK parameter.
    1. Log in to Configuration Manager.
    2. On the Tasks bar, click the Manage Data Load Parameters link.
    3. In the Search pane, select the source system in the Source Instance list.
    4. Select Code in the Parameter list and enter ETL_SRC_VIA_DBLINK in the adjacent field.
    5. Click Search.
    6. In the Data Load Parameters list, click the default No value to open the Edit Parameter Value dialog.
    7. In the Parameter Value list, select Yes.
    8. Click Save and Close.