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:

In ODP extraction method, stage runtime uses only RFC communication to extract data from the SAP Application and not IDoc communication. There are some prerequisites that you must ensure before using Delta Extract stage:
  • 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.
Based on inferences from the mentioned information and SAP notes, the following prerequisites are mandatory for using ODP extraction method:
  • 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).
Note: Use Validate Stage in Delta Extract Stage GUI to check the prerequisites. Ensure that all validation checks are passed while designing the stage in either extraction mode.