|Oracle® Fusion Middleware Getting Started with SAP ABAP ERP Adapter for Oracle Data Integrator
11g Release 1 (11.1.1)
Part Number E39326-02
|PDF · Mobi · ePub|
This chapter provides an overview of Oracle Data Integrator SAP ERP Knowledge Modules.
The Oracle Data Integrator SAP ABAP Knowledge Modules provide integration from SAP ERP systems using SAP JCo libraries. This set of KMs has the following features:
Reads SAP data from SAP ERP system
Loads this SAP data into Oracle or non-Oracle Staging Area
Reverse-engineers SAP metadata and proposes a tree browser to pick up only the required metadata
This adapter includes three knowledge modules:
RKM SAP ERP: Its main role is to perform customized reverse-engineering of SAP tables into ODI datastores (Models). The SAP ERP RKM is in charge of connecting to the SAP System, which provides the SAP table's metadata information, and transforming and writing the resulting metadata into Oracle Data Integrator's repository.
The LKM SAP ERP to Oracle (SQLLDR) connects to SAP and retrieves data from the SAP tables defined in the SAP Model. It is used in the interfaces. The LKM is in charge of loading source data from a SAP System to an Oracle staging area.
The LKM SAP ERP to SQL connects to SAP and retrieves data from the SAP tables defined in the SAP Model. It is used in the interfaces. The LKM is in charge of loading source data from a SAP System to a non-Oracle staging area.