SAP Delta Extract connection

To access your data in SAP Delta Extract, create a connection asset for it.

Use SAP Delta Extract to extract data from SAP application systems by using ODP (Operational Data Provisioning) extraction. This connection is available for the DataStage service only.

Supported versions

  • SAP ERP 6.0 EHP6, EHP7 & EHP8
  • S/4 HANA 2020, S/4 HANA 2021, S/4 HANA 2022, S/4 HANA 2023

Prerequisite

Install the packaged Remote Function Module on the SAP Application server and configure the SAP user account with the necessary authorization to run the job. Install the SAP server components.

The SAP Delta Extract connection requires the JAR file sapjco3.jar and libsapjco3.so, which can be found through the SAP Market Place.

See [Importing JDBC drivers]({{ site.data.keyword.swdocs }}/hub/admin/jdbc-drivers.html){: external} in the {{ site.data.keyword.swhub }} documentation for the procedure and required permissions to upload the JAR file to Cloud Pak for Data. Important: By default, uploading JDBC driver files is disabled and users cannot view the list of JDBC drivers in the web client. An administrator must [enable users to upload or view JDBC drivers]({{ site.data.keyword.swdocs }}/hub/admin/post-install-enable-jdbc-upload.html){: external} in the {{ site.data.keyword.swhub }} documentation.

The extraction method uses ODP Replication API 2.0 (see SAP Notes 1931427, 2232584, 1560241).

The SNC support is enabled by downloading the SAP cryptographic library. To enable SNC configuration, refer to SNC configuration technote.

Create a connection to SAP Delta Extract

To create the connection asset, you need these connection details:

  • JAR file - sapjco3.jar and libsapjco3.so that can be downloaded on the SAP Market Place
  • Application server - Host name or IP address of the SAP server
  • System number - SAP system number
  • SAP router - consists of IP address and port number that describes the stations of a connection that is required between two hosts. Syntax: (/H/host/S/Service/W/pass)
  • ODP subscriber name (must be uniquely defined)
  • SAP username and password (or X.509 certificate) - username and password that is connected to SAP server
  • Client number - SAP client number

To create and asset with a Load Balancing connection type, you need these connection details

  • Message server - Host name of the SAP message server
  • Group - Group name of the SAP application server
  • System number or ID - Name of the SAP system

To create an asset with an SNC connection type, you need these connection details:

  • SNC name (Optional) - Specifies Client PSE or Certificate name, which is generated on the client side (server tier) concerning the partner server (SAP server).
  • SNC partner name - Specifies Server PSE or Certificate name that is generated on the SAP Server.
  • SNC QOP - Specifies the quality of protection for SNC connection. By default QOP is set to 3. Following are the possible values of this field:
    • 1: authentication only
    • 2: integrity protection
    • 3: integrity and authentication
    • 8: default
    • 9: maximum

For Credentials, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.

In the Platform assets catalog
Click New connection. See Adding platform connections.

In a deployment space
Click Import assets > Data access > Connection. See Adding data assets to a deployment space.

Next step: Add data assets from the connection

Federal Information Processing Standards (FIPS) compliance

This connection can be used on a FIPS-enabled cluster (FIPS tolerant); however, it is not FIPS-compliant.

Migration from the traditional DataStage connector

See Migrating connections.

Restrictions

You can use this connection only for source data. You cannot write to data or export data with this connection.

Parent topic: Supported connections