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 and the DLL file sapjco3.dll. 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.

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

The SAP Bulk Extract connection cannot be created in a FIPS environment.

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.

Parent topic: Supported connections