SAP Data Extraction Accelerator
1. Integration with SAP Data Extraction Tools
With SNP Glue, Asapio, SAP Datasphere and other popular ingestion tools. We support SAP Extractors, CDSViews and RAW SAP ERP tables.
Ingesting via Extractors/CDSViews | Ingesting RAW SAP ERP tables |
* Utilizes existing SAP-provided business logic.
* Incremental/delta data loading might be challenging especially for larger data sources.
* Not all CDSViews support extraction or incremental data loading.
* Certain older SAP Extractors may not sustain frequent data pulls (exceeding one per hour), which may have a serious performance impact on the source S4 system. | * Predictable performance for large SAP data sources
* Incremental data loading works without compromises.
* SAP-provided business logic must be fully re-engineering in Databricks.
* Requires experienced SAP experts.
* SAP SLT license is needed. |
2. Automate incremental data load
We’ve prepared a python package to effectively merge the CDC events into a Delta table, apply SCD2 transformations to create flat tables registered in the Databricks Unity Catalog, and many more.
3. Columns Renaming, Data Types Normalization, Descriptions, Primary Keys
Supports SAP objects ingested using either CDSViews or extractors.