ERPL
A DuckDB extension that reads SAP ERP tables, CDS views and BW queries from SQL over RFC, BICS and ODP, and can mount an SAP system as a DuckDB catalog to join against other data.
Four extensions behind one LOAD 'erpl': erpl_rfc reads SAP ERP tables and CDS views over RFC and invokes any function module, erpl_bics runs SAP BW cubes and queries over BICS with hierarchies and lineage, erpl_odp extracts over SAP ODP in full and delta, and erpl_ape reads CDS entities through the ABAP Pipeline Engine with deletes included in the delta. An SAP system can also be mounted as a DuckDB catalog with ATTACH, after which sap."/DMO/FLIGHT" joins against a CSV in the same query. The install is a trampoline: the erpl extension carries the SAP NetWeaver RFC SDKSAP NetWeaver RFC SDKSAP's native library for calling ABAP functionality and for being called from ABAP. Downloaded from SAP under its own terms rather than from a package registry, so anything built on it carries that prerequisite per platform. libraries and the sub-extension binaries in its own payload and extracts them on first load, so there is no SDK to fetch from SAP, but DuckDB has to be started with -unsigned because the binaries are not signed by DuckDB Labs. The split is commercial as well as technical: the gratis Community Edition queries SAP ERP tables, and querying SAP Business Warehouse and replicating via ODP are Enterprise Edition.
Facts
Where it sits
Who is behind it
In the atlas: maintains 3@DataZooDEmaintainerJoachim RosskopfContributes to this
In the atlas: contributes to 3@jrosskopfSimon MüllerContributes to this
In the atlas: contributes to 1@sipemusm-DataZooContributes to this
In the atlas: contributes to 1@sm-DataZoo3 contributors
Before choosing this
Conditions
PracticalFunctional boundary
DataZoo GmbH calls the extension experimental and states that minimal testing and benchmarking were done. The Business Source License 1.1 it carries restricts offering the software to third parties on a hosted or embedded basis, so an embedding product needs a commercial licence. Telemetry is on by default and is switched off per session with SET erpl_telemetry_enabled = false or for the machine with DATAZOO_DISABLE_TELEMETRY=1.
What it declares
Every artifact
- Type
- Package
- Origin
- Independently maintained
As a package
- Where it runs
- does not say
- Distributed through
- does not say
Connections
Getting data into an analytical store and keeping it current
Calling ABAP function modules from outside the system over RFC
SAP's application server and development platform for ABAP. For the things here it is the system a developer's editor or an agent's tool reaches over ADT, and a program calls over RFC; where it runs is the deployment's, as for SAP BW/4HANA.
SAP's earlier ERP suite, ECC 6.0, run on-premise on the ABAP platform and succeeded by SAP S/4HANA. For the things here it is the system a tool reads from or writes to.
SAP's application server and development platform for ABAP. For the things here it is the system a developer's editor or an agent's tool reaches over ADT, and a program calls over RFC; where it runs is the deployment's, as for SAP BW/4HANA.
An in-process analytical SQL database. For the things here it is the engine an extension is loaded into, and where SAP data lands once it has been read: queried and joined there alongside files and other tables.
Download
README
quoted from DataZooDE/erpl, readHistory
Changed 5, Other 3
Features 2, Fixes 1
Features 4, Fixes 2
Changed 2
Features 4, Changed 1, Fixes 5
Features 3, Changed 7, Other 6
Features 4, Changed 3
Features 6, Changed 1, Fixes 14, Other 1
Features 2, Fixes 5
Features 2, Changed 3, Fixes 3, Other 2
Breaking 2, Features 2, Fixes 1
Other 11
Other 9
Other 5
Other 1
Other 1
Other 4
Other 4
Other 3
Other 4
Other 5
Other 1
Other 1
Other 2
Other 1
Other 3
Other 9
Other 2
Docs 1, Other 13
Other 9
Other 2
Other 5
Other 1
Other 2
Other 1
Other 4
Other 5
Other 2
Others providing
- SAP Analytics CloudSAP Analytics CloudSAP's SaaS front end for analytics: business intelligence, planning and predictive in one product, and the place a Datasphere analytic model is meant to end up being read.sap official, btpSaaS for business intelligence, planning and predictive analyticsfrom BTP/BAIP
- SAP DatasphereSAP DatasphereSAP's cloud data warehouse: spaces, modelled views and analytic models over data brought in or federated from source systems, with the business context carried along rather than rebuilt.sap official, btpCloud data warehouse with spaces, views and analytic modelsfrom BTP/BAIP
- bw-modeling-mcpbw-modeling-mcpReads, creates and modifies BW/4HANA modelling objects through the same internal APIs Eclipse BWMT and the BW/4HANA Cockpit use — and can run centrally on BTP with each caller reaching BW as themselves.independent, btpMCP server for BW/4HANA modelling objectsfrom BTP/BAIP
- sap_analytics_cloud_mcpsap_analytics_cloud_mcpThe SAP Analytics Cloud REST API as ninety tools across eleven service areas — content, data import and export, user management, transport, scheduling and translation.independent, btpMCP server for the SAP Analytics Cloud REST APIfrom BTP/BAIP
- @mariodefe/sap-datasphere-mcp@mariodefe/sap-datasphere-mcpForty-five tools across a Datasphere tenant — discovery, metadata, analytics, ETL extraction, database users, lineage and column profiling — with config-driven PII masking applied before anything reaches the model.independent, btpMCP server with forty-five tools across a Datasphere tenantfrom BTP/BAIP
- pawelwiejkut/bw_remove_characterspawelwiejkut/bw_remove_charactersAn ABAP class for a BW transformation's end routine that strips the characters an InfoObject cannot accept, checked against transaction RSKC, before they cause an activation error.independent, abapABAP class stripping invalid characters in BW end routinesfrom ABAP
- pawelwiejkut/bw_trfn_pocketknifepawelwiejkut/bw_trfn_pocketknifeA framework that handles SAP BW transformation start routines from a customisation table with its own maintenance view, instead of a routine class written per transformation.independent, abapFramework for BW transformation start routines from a tablefrom ABAP
- dbt-sap-hana-clouddbt-sap-hana-cloudA dbt adapter, installed as a Python package beside dbt-core, that lets a dbt project target SAP HANA Cloud as its warehouse through a profile in profiles.yml.sap official, btpdbt adapter targeting SAP HANA Cloud as its warehousefrom BTP/BAIP
- rfc-connectorrfc-connectorCalls abap2UI5 apps of another system over RFC: an ICF handler on the system the browser talks to forwards each roundtrip through an SM59 destination to the system the apps run on.community org, abapForwards abap2UI5 roundtrips to another system over RFCfrom ABAP
- SAP Connectivity serviceSAP Connectivity serviceThe proxy through which a cloud application reaches an on-premise system behind a Cloud Connector — HTTP, RFC and raw sockets — without that system being exposed.sap official, btpProxy from cloud apps to on-premise systems via Cloud Connectorfrom BTP/BAIP
- abap_fm_jsonabap_fm_jsonA JSON adapter that exposes ABAP function modules over HTTP: a handler class in an ICF service calls the module named in the URL and serialises its parameters to and from JSON.independent, abapJSON adapter exposing ABAP function modules over HTTPfrom ABAP
- erpl-node-rfcerpl-node-rfcAn SAP RFC client for Node.js and TypeScript that implements the protocol in Rust and ships prebuilt for seven platforms behind node-rfc's API, so there is no SAP NW RFC SDK to download.independent, abapRFC client for Node.js and TypeScript without the NW RFC SDKfrom ABAP
- open-rfcopen-rfcAn SDK-free TypeScript and JavaScript client for SAP classic synchronous RFC on Node.js, with no native addon and no runtime dependencies, that works as a drop-in under @sap/cds-rfc through an npm override.independent, capSDK-free TypeScript client for SAP synchronous RFC on Node.jsfrom CAP
- ADELE RFC APIADELE RFC APIAn RFC-callable ABAP API for extracting SAP data, implemented for the Java-based ADELE tool, with an OLAP mode for group by and count.independent, abapRFC-callable ABAP API for SAP data extraction for ADELEfrom ABAP
- @sap/cds-rfc@sap/cds-rfcCalls ABAP function modules over RFC from a CAP service.sap official, capCalls to ABAP function modules over RFC from a CAP servicefrom CAP
- Cloud ConnectorCloud ConnectorSAP's on-premises agent that links SAP BTP applications to systems in a customer's own network, as a reverse invoke proxy that exposes only the systems and resources it is configured to allow.sap official, btpSAP's on-premises agent linking SAP BTP to customer-network systemsfrom BTP/BAIP
- srijan9864/zrfcreadsrijan9864/zrfcreadAn RFC-enabled ABAP function module that counts the entries of any table against dynamic where and join criteria.independent, abapAn RFC-enabled ABAP function module that counts the entries of any table against dynamic where and join criteria.from ABAP
Details
Sources
Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.
Compatibility and provenance
Contributors
History in the atlas
- First seen.
For your agent
- Ref
artifact:datazoode-erpl- JSON
- /artifacts/datazoode-erpl.json
- MCP
- Connecting an agent