X hits on this document

424 views

0 shares

1 downloads

0 comments

112 / 131

Creating and Reverse-Engineering a Model

Note: Before using SAP ABAP - BW KM, make sure that the OdiSAPAbapExecute Open Tool has already been installed. For more information, refer to the Installation and Configuration section.

To create and reverse-engineer a SAP BW Model:

  • 1.

    Connect to Designer.

  • 2.

    In the Models tree view, click Insert Model.

  • 3.

    In the Definition tab, enter the Model name in the Name field.

  • 4.

    In the Technology field, select the SAP ABAP technology.

  • 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 data store object(s) to reverse.

  • 14.

    Click Reverse.

Consequent to following above mentioned steps, selected data store objects should be reverse-engineered and appear under the new Model in Designer.

Designing an Interface Using the SAP ABAP - BW KM

To create an interface loading SAP BW data into your Oracle Data warehouse table:

  • 1.

    Create an interface with source data objects 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 BW source data object(s) and select the LKM SAP BW 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

Knowledge Modules Reference Guide

112/131

Document info
Document views424
Page views427
Page last viewedSat Dec 10 23:02:03 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments