Prerequisites for Delta Extract stage
Before you use the Delta Extract stage, make sure that you meet the software requirements for IBM® InfoSphere® Information Server Pack for SAP Applications and the prerequisites:
- Install the packaged Remote Function Module, especially the modules for Delta Extract stage, on the SAP Application server. For more information see Release Notes of the Pack version that you intend to use.
- Configure an SAP user account with the necessary authorizations for Delta Extract stage design and run time.
- Install the required SAP SDK libraries on the InfoSphere DataStage® server and clients.
- There will be no data extracted in Delta extract stage when run in Delta mode for the first time, as initialization with data transfer is not supported in Delta extract stage. The first time the job is run, initialization will be performed. Subsequent runs will extract the data.
For more details on usage guidelines for Delta Extract Stage, see technote 2005807.
For additional prerequisites required for specific extraction scenarios, see technote 2001268.
In addition to the mentioned prerequisites, there are few other prerequisites which depend on the extraction method you select in Delta Extract stage.
Specific prerequisites as per extraction method
BW extraction method:
In this method, stage runtime uses both IDoc (inbound and outbound IDoc) and RFC communication to extract data from SAP Application. Hence, before you use the Delta Extract stage in extraction mode, ensure that you meet the following requirements:
- Configure the SAP Dispatch/Gateway service ports on the IBM
InfoSphere
DataStage
client and server machines.Note: From Pack 8.2.0.4 version onwards, stage run time automatically uses the port based on the instance or the system number of the SAP Gateway Server provided in the IDoc Listener Settings. Similarly, for the load balancing connection, you can provide the instance or the system number of the message server while defining the connection in DataStage Administrator for SAP. In such cases, you are no longer required to configure SAP Gateway services or message server ports.
- Configure the SAP system to identify InfoSphere DataStage as both target and source system for IDocs. See Configuring a logical system in SAP for use with the IDoc Extract and Delta Extract for more details.
- Ensure that the selected InfoSphere DataStage SAP connection has a running instance of the IDoc Listener. For details on configuration, see IDoc Listener subsystem.
ODP extraction method:
- Prerequisites for DataStage:
- You must define an unique Subscriber name for the DataStage connection to SAP. You can find the setting in Connection properties (ODP Settings tab) in DataStage Administrator for SAP. The subscriber name must be uniquely defined as the DataStage server is registered using this name in the SAP server from which you are extracting data using ODP enabled DataSources. SAP server also maintains a unique Operational Delta Queue (ODQ) for the delta data. If the name is not unique, you might find an undefined behavior for example, timed out job during run with no data packets extracted from SAP server or data loss.
- Prerequisites for SAP server:
- ODP Extraction method uses ODP Replication API 2.0. To ensure if the API exist see SAP note 1931427.
- One of the following SAP servers: SAP S/4HANA on-premise, EHP6 or higher for SAP ERP 6.0
- In addition, if applicable for your specific system, you might need to implement the SAP note indicated (your SAP Administrator should assess that need).