ODI Loading Using RDBMS-Specific Strategies

Loading Using RDBMS-Specific Strategies

Certain RDBMSs have a mechanism for transferring data across servers. For example:

• Oracle: database links
  
• Microsoft SQL Server: linked servers
  
• IBM DB2 400: DRDA file transfer
  

Other databases implement specific mechanisms for loading files into a table, such as Oracle's External Table feature.
These loading strategies are implemented into specific KM that create the appropriate objects (views, dblinks, etc.) and implement the appropriate commands for using these features.