Overview
SAP ERP (Enterprise Resource Planning) is SAP’s suite of integrated business applications covering finance, logistics, HR, and more. Datazone connects to SAP ERP systems through the CloudFeed HTTP connector, enabling you to read tables, inspect schemas, and extract data without requiring a direct database connection.Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| Name | Yes | A unique identifier for your SAP ERP source |
| Base URL | Yes | The base URL of the SAP system with the CloudFeed connector installed (e.g. https://your-sap-host:8080) |
| Username | Yes | SAP username with read permissions |
| Password | Yes | Password for the specified user (stored encrypted) |
Required Permissions
The SAP user account needs the following authorizations:- Read access to the tables you intend to extract
- Authorization to execute the CloudFeed RFC function modules
How It Works
Datazone communicates with SAP ERP via the CloudFeed module, a lightweight HTTP adapter installed on the SAP system. It exposes SAP tables and function modules as REST endpoints, which Datazone calls to list tables, read schemas, and extract data. This means:- No direct database port (e.g. 1433/3306) needs to be open
- Data flows over HTTPS
- SAP’s own authorization model is respected
Limitations
- Maximum file/payload size per request: 10 MB
- Extraction throughput depends on SAP system load and CloudFeed configuration
- Supported SAP ERP versions: ECC 6.0 and above
Next Steps
After configuring your SAP ERP source:- Create extracts to specify which tables to ingest
- Configure scheduling for recurring extracts
- Integrate the source into your data pipelines