X hits on this document





99 / 131

  • 5.

    In the Logical Schema field, select the Logical Schema on which your model will be based.

  • 6.

    Go to the Reverse tab, select Customized Reverse, and select a Context which will be used for the Model's reverse-engineering.

  • 7.

    Select the RKM SAP ABAP.<PROJECT NAME>. _

  • 8.

    Click Apply.

  • 9.

    Click Reverse, and then click Yes to validate the changes.

  • 10.

    Click OK.

  • 11.

    The Session started window appears. Click OK.

  • 12.

    The Tree Metadata Browser appears if the USE GUI KM option is set to Yes (default value). _

  • 13.

    Select the table(s) to reverse.

  • 14.

    Click Reverse.

The tables selected in the Tree Metadata Browser are reverse-engineered and appear under the new Model.

Designing an Interface Using the SAP ABAP KM

To create an interface that loads SAP ERP data into your Oracle Data warehouse table:

  • 1.

    Create an interface with source datastores from the SAP ABAP Model created previously. This interface should have an Oracle target or use an Oracle schema as the Staging Area.

  • 2.

    Create joins, filters and mappings for your interface.

  • 3.

    In the Flow tab of the interface, select the source set containing the SAP ABAP source table(s) and select the SAP ERP LKM to Oracle (SQLLDR).

  • 4.

    Click Apply to save your interface.

  • 5.

    Click Execute to run the interface.

File Transfer Configurations

The ODI SAP connector extracts data using ABAP programs. At the end of the extraction process these ABAP programs will push the data file to an FTP server. Ideally this FTP server is located on the ODI agent machine. If this is not the case, the ODI agent will download the file from the FTP server to the agent for loading the data using SQLLDR. This download can be performed using FTP, SFTP or SCP.

Configuration 1: FTP Server is installed on an ODI Agent machine

T h i s c o n f i g u r a t i o n i s u s e d , w h e n F T P _ T R A N S F E R _ M E T H O D = N O N E . I n t h i s c o n f i g u r a t i o n t h e d a t movements described will be performed: a

  • 1.

    The ABAP program extracts the data and pushes the data file to the FTP server defined by the FTP data server. The file is stored in the directory given by the FTP server's data schema.

  • 2.

    SQLLDR locates the data file using the work schema of the FTP server and uploads the data into Oracle DB.

This configuration requires the following Topology settings in ODI:

Knowledge Modules Reference Guide


Document info
Document views568
Page views571
Page last viewedTue Jan 24 20:51:16 UTC 2017