X hits on this document





97 / 131

  • 1.

    Define the Topology.

  • 2.

    Set up the Project.

  • 3.

    Create a model and reverse-engineer SAP tables.

  • 4.

    Design an Interface using the LKM SAP ERP to Oracle (SQLLDR). Use the SAP ERP datastore as

source of such an integration interface.

Defining the Topology

You must perform the following operations after installing or upgrading your Oracle Data Integrator version:

  • 1.

    Connect to Topology Manager.

  • 2.

    If the SAP ABAP technology does not exist in your Master Repository, import the SAP ABAP technology in Synonym INSERT_UPDATE mode from the /impexp folder.

  • 3.

    Perform an upgrade of the Master Repository. Refer to the Oracle Data Integrator Installation Guide on OTN for more information on the Master Repository upgrade process.

  • 4.

    In Topology Manager, open the JavaBeanShell technology and check on the Language tab that the JYTHON language is listed. If not, add it.

  • 5.

    Create a File data server pointing to an existing FTP server into which the extraction file will be pushed from SAP and picked up for SQL*Loader. Set the parameters for this data server as follows: Host (Data Server): FTP server IP host name or IP address. User: Username to log into FTP server. Password: Password for the user.

  • 6.

    In this File data server create a Physical Schema representing the folder in the FTP host where the extraction file will be pushed. Specify the Data and Work Schemas as follows: Data Schema: Path on the FTP server to upload or download extraction files from the remote location. This path is used when uploading extraction files from the SAP ERP system into the FTP server. It is also used by a remote agent to download the extraction files. Note that this path must use slashes and must end with a slash character. Work Schema: Local path on the FTP server’s machine. This path is used by an agent installed on this machine to access the extraction files without passing via the FTP server. This access method is used if the FTP_TRANSFER_METHOD parameter of the LKM SAP ERP to Oracle (SQLLDR) is set to NONE. As Work Schema is an OS file name, slashes/ backslashes should be used according to OS. Path names need to end on slash/ backslash.

Path names given on Data and Work schemas are not necessarily the same: the FTP service may provide access to a FTP directory named /sapfiles while the files are can be stored locally in c:\inetpub\ftproot\sapfiles.

Refer to the File Transfer Configurations section in the SAP ABAP chapter of the Oracle Data Integrator Knowledge Modules Reference Guide.


If the corresponding Logical Schema called File Server for SAP ABAP does not exist yet, create it. This Logical Schema name is fixed and must be mapped to the Physical Schema created in the previous step.

You can now add the SAP connection information. To configure a SAP ABAP data server:

1. Create a data server for SAP ABAP technology. This data server represents the SAP connection information.

Knowledge Modules Reference Guide


Document info
Document views464
Page views467
Page last viewedWed Jan 18 04:29:18 UTC 2017