Set the parameters for this data server as follows: Name: SAP_ERP. The name of the data server as it will appear in ODI. Host (Data Server): SAP ERP System IP Address or Hostname. User: SAP User, as provided by the SAP Administrator. Password: This user’s SAP Password. This password is case-sensitive.
Set the flexfields values for this data server in the Flexfields tab. SAP Language: Code of the language used when logging in. For example EN for English, DE for German.
SAP Client Number: The three-digit number assigned to the self-contained unit which is called Client in SAP. A Client can be a training, development, testing or production client or represent different divisions in a large company.
SAP System Number: The two-digit number assigned to a SAP instance which is also called Web Application Server or WAS.
SAP System ID: The three-character, unique identifier of a SAP system in a landscape.
SAP SNC Connection Properties: SNC Connection Properties. This parameter is optional and can be left empty.
SAP Router String: Router String. This parameter is optional and can be left empty.
Create a Physical Schema under the data server.
Create a Logical Schema for this Physical Schema in the appropriate context.
Note: The Test button for validating the SAP Connection and the FTP Connection definition is not supported.
Except for Data Server Name, all the parameters that you provide while defining the SAP Data Server should be provided by the SAP Administrators. See Gathering SAP Connection Information for more information about these parameters.
Setting up the Project
Import the following KMs into your Oracle Data Integrator project: RKM SAP ERP LKM SAP ERP to Oracle (SQLLDR)
Import in addition the standard LKMs, IKMs and CKMs to perform data extraction and data quality checks for your project.
For more information about importing a KM, please refer to the Oracle Data Integrator User’s Guide.
Creating and Reverse-Engineering a Model
Note: Before using SAP ABAP 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 ERP Model:
Connect to Designer.
In the Models tree view, click Insert Model.
In the Definition tab, enter the Model name in the Name field.
In the Technology field, select the SAP ABAP technology.
Knowledge Modules Reference Guide