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 BW data server:
Create a data server for SAP ABAP technology. This data server represents the SAP connection information.
Set the parameters for this data server as follows: Name: SAP_BW. The name of the data server as it will appear in ODI. Host (Data Server): SAP BW System IP Address or Hostname. User: SAP BW User, as provided by the SAP Administrator. Password: This user’s SAP BW 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 BW RKM SAP Connection Test LKM SAP BW to Oracle (SQLLDR)
Import also 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.
Knowledge Modules Reference Guide