Skip to main content

​
Overview

Datazone connects to SAP ERP via the Datazone CloudFeed SAP Connector, an HTTP adapter installed on your SAP system. It provides access to SAP tables, schemas, and function modules without requiring a direct database connection.

​
Prerequisites

The Datazone CloudFeed SAP Connector must be installed on your SAP environment before creating this source. Contact your SAP administrator to confirm the connector is active.

​
Connection Parameters

Set on the source when you create it. Names match the API and CLI payload.
​
string
required
Name — a unique identifier for your SAP ERP source.
​
string
required
Base URL — base URL of the SAP system running the CloudFeed connector, for example https://your-sap-host:8080.
​
string
required
Username — SAP technical user username.
​
string
required
Password — password for the specified user. Stored encrypted.

​
Extract Parameters

Set per extract, in source_parameters. See Shared Extract Parameters for mode, replication_key, and schema_mapping.
​
string
required
Table Name — the table to extract, for example MARA.
​
integer
default:"50000"
Rows SAP puts in each extraction package. Packages are streamed rather than buffered whole, so this bounds peak memory. Lower it for very wide objects.
​
integer
default:"50000"
Rows written per batch on the Datazone side.
​
boolean
default:"true"
Fetch ready packages concurrently instead of one at a time. Turn it off to minimise load on the SAP system.
​
integer
default:"4"
Number of concurrent package fetches when parallel_fetch is on. Peak memory scales with this multiplied by package_size, so raise the two together with care.
​
integer
default:"60"
Per-request timeout in seconds when talking to the CloudFeed connector.
​
object[]
SAP range-table filters, evaluated inside SAP before any data leaves the system. Each entry takes FIELDNAME, SIGN (I to include, E to exclude), OPTION (EQ, NE, GT, GE, LT, LE, BT, CP), LOW, and HIGH (upper bound, for BT).
​
object
Delta configuration, required when mode is append. Delta state is held server-side by SAP against ID, not tracked by Datazone, and is committed only after the extraction succeeds.
ID identifies the delta stream and must stay stable across runs; TYPE is SINGLE or MULTI column; OPERATOR is the comparison applied to COLUMNS.
​
string
default:"*"
Columns to read, as a comma-separated list.
​
string
Row filter applied to the extracted rows, written without the WHERE keyword. For filtering inside SAP, prefer filters.
extraction_timeout (default 7200 seconds) and check_interval (default 5 seconds) govern how long Datazone waits for SAP to finish an extraction job and how often it polls. Neither is read from source_parameters — set them through the extract’s custom_reader_config if you need to change them.

​
Required Permissions

Assign the following roles to the SAP technical user:

​
How It Works

Datazone communicates with SAP ERP via the Datazone CloudFeed SAP Connector over HTTP installed on the SAP system. No direct database port needs to be open — all data flows over HTTPS and SAP’s own authorization model is enforced.

​
Limitations

  • Maximum payload size per request: 10 MB
  • Supported versions: SAP ERP ECC 6.0 and above

​
Next Steps

  1. Create extracts to specify which tables to ingest
  2. Configure scheduling for recurring extracts
  3. Integrate the source into your data pipelines