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
- 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 objects
- 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 routines
- 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 table
- 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 RFC
- 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 HTTP
- 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 SDK
- 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 ADELE
- 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 systems
- 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.
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