Using a Database Link for ETL

Set up direct links to replace the default ODBC links to improve ETL performance. Database Link Mode can be used only when the source database is Oracle and a compatible DB Link can be created from the Oracle Warehouse to the source.

Database link mode should be used only when the source database is Oracle and a compatible database link can be created from the Oracle Warehouse to the source. The 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 drop-down list.
   4. Select Code in the Parameter drop-down 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 box.
   7. In the Parameter Value drop-down list, select Yes.
   8. Click Save and Close.