The DuckDB extension
for SAP integration

Are you trying to make your data integration easier? Check out DataZoo’s DuckDB SAP connector ERPL. Designed for simplicity and efficiency, our extension empowers you to transform the way you handle data with SAP systems.

Install our extension with just three lines of SQL code:

SET custom_extension_repository = 'http://get.erpl.io';
INSTALL 'erpl';
LOAD 'erpl';

Install the extension! Request ODP/BICS connector!

ERPL connects DuckDB to SAP ecosystem via standard interfaces!

RFC RFC (Remote Function Call)

Read SAP tables or call Remote Function Call (RFC) functions exposed by your SAP system from DuckDB SQL. Further we provide wrappers around common functionality to make entry into SAP ecosystem more natural and easy.

Get & Install RFC Extension

ODP ODP (Operational Data Provisioning)

Use SAP Operational Data Provisioning (ODP) to extract, replicate, and transform data from various SAP systems directly into DuckDB. Thereby you combine rock solid data replication with the power of the DuckDB ecosystem.

Request Invite!

BICS BICS (BI Consumer Services)

Combine controlling information from enterprise SAP business warehouse (BW) with your Data Science and Machine Learning workloads in Python, R, or Julia. We implement the BI Consumer Services (BICS) interface you also use in Excel and Analysis for Office.

Request Invite!

ERPL solves common daily challenges for Enterprise Data Experts!

Load Table Load Customers from a SAP ERP Table

We demonstrate how to load data customer masterdata directly from KNA1 and ADRC. We further show you in this example how you can use our extension together with Google Cortex to quickly build a reporting view on many different SAP tables.

Go to Example

BW Query Understand and Execute a BW Query

In this example we show how to find details about Characteristics and Key Figures of a BW Query. We show hot to set variables on a query and gradually drill down into the data. We try to guide you how to transition from Analysis for Office to DuckDB.

Go to Example

RFC Delta replicate stock data from SAP ERP to Parquet

You see here, how to use default ODP extractors to to delta / \(\delta\) replicate stock data from ECC/ERP to DuckDB and there into Parquet. And how this can then be integrated into a serverless data pipline in the cloud.

Go to Example