LKM SAP ERP to Oracle (SQLLDR) requires a FTP server to upload data from the SAP ERP system. This data is either read locally by the agent executing the interface (when this agent runs on the FTP server machine), or remotely (when this agent is located on a different machine than the FTP server). This FTP server must be accessible over the network from both the SAP ERP machine and the agent machine.
SQL*Loader is required on the machine running the agent when executing interfaces using LKM SAP ERP to Oracle (SQLLDR). SQL*Loader is used for loading data extracted from SAP to the Oracle staging area.
Gathering SAP Connection Information
In order to connect to the SAP ERP system, you must request the following information from your SAP administrators:
SAP ERP System IP Address or Hostname: IP address/ Hostname is the technical name given to the host on which SAP is running.
SAP User: SAP User is the unique user name given to a user for logging on the SAP System. SAP Password: Case-sensitive password used by the user to log in.
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 (optional) SAP Router String (optional): SAP is enhancing security through SNC and SAP router. It is used when these securities are implemented.
Note: All the connection data listed above (except SAP SNC Connection Properties and SAP Router String) are mandatory and should be requested from the SAP Administrators. You may consider requesting support during connection setup from your SAP administrators.
Getting the Right Privileges
The SAP Adapter requires privileges to perform set up and execution operations. Please provide your administrators with the list of privileges listed in the Appendix A - SAP ABAP Required Privileges of the Getting Started with Sap ABAP ERP Adapter guide.
These privileges are required for the SAP user that they will provide you to login the SAP System.
Gathering FTP Connection Information
The SAP system will push data to a server using FTP. For later setup, gather the following information from your system administrator:
FTP userID FPT login Directory path for storing temporary data files
Validate that the FTP server is accessible both from SAP System and from ODI agent machine.
Knowledge Modules Reference Guide