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.
You will need:
- DuckDB in your favorite development environment.
- ERPL Extension
- Access to an SAP ERP system with the tables KNA1 and ADRC
- A RFC enabled SAP user, see our security section for more details
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.
You will need:
- DuckDB
- ERPL BW Extension
- Access to an SAP BW or BW/4 system
- A BW user, which is allowed to execute the query. (You can check e.g. with Analysis for Office)
Delta replicate stock data from SAP ERP to Parquet
You see here, how to use default ODP extractors to to 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.
You will need:
- DuckDB
- ERPL ODP Extension
- Access to an SAP ERP system, an CDS view or BW system with ODP enabled
- A user with relvant authorizations to access the ODP extractors