SAP Bulk Extract connection

To access your data in SAP Bulk Extract, create a connection asset for it. This connection is available for the DataStage service only.

Use SAP Bulk Extract to extract data from SAP data repositories using SQL queries.

Supported SAP applications

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

Prerequisite

The SAP Bulk Extract connection requires the JAR file sapjco3.jar. On UNIX, the connection also requires libsapjco3.so. SAP JCo JAR files can be found through SAP Market Place, while SNC support is enabled by downloading the SAP cryptographic library. See Importing JDBC drivers for the procedure and required permissions to upload the JAR file to Cloud Pak for Data. Important: Starting in version 4.8.4, uploading JDBC drivers is disabled by default. Starting in 4.8.5, by default in new installations, users cannot view the list of JDBC drivers in the web client. An administrator must enable users to upload or view JDBC drivers.

Create a connection to SAP Bulk Extract

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

  • JAR file
  • Application or Message server
  • System number (or ID)
  • Group (if connection type has load balancing)
  • SAP router
  • SAP username and password (or X.509 certificate)
  • Client number

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

  • SNC name
  • SNC partner name
  • SNC QOP

An RFC destination and program ID details are automatically generated by default. To specify your own destination and program ID, deselect Create RFC Destination Automatically or Auto Generate RFC Destination name.

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 > Data access tools > Connection. See Adding a connection to a project.

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

In a deployment space
Click Add to space > Connection. See Adding connections to a deployment space.

Next step: Add data assets from the connection

Where you can use this connection

You can use the SAP Bulk Extract connection in the following workspaces and tools:

Projects

Catalogs

  • Platform assets catalog

Federal Information Processing Standards (FIPS) compliance

  • 4.8.0, 4.8.1, and 4.8.2: This connection is compliant with FIPS.
  • 4.8.3 and later: This connection is not compliant with FIPS, but it is FIPS-tolerant.

Restrictions

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

Running SQL statements

You can enter the Table Name and Condition Clauses in the stage editor to automatically generate an SQL query. To write your own query, deselect Generate SQL Query and manually provide an SQL query in the stage editor.

Migration from the traditional DataStage connector

See Migrating connections.

Parent topic: Supported connections