SAP2Databricks

Database-level SAP data replication

  • approaches:
    • database change data capture (CDC, data pull)
    • triggers (push)

Database-level SAP data replication illustration

  • supports incremental data ingestion

Pros

  • minimal impact on the source system
  • the fastest and best-performing way to get data out of SAP

Cons

  • does not contain business or application logic
  • low-level data model
    • ~90k tables for SAP ECC
    • 40k-60k tables for SAP S/4HANA
  • data model very different for ECC and S/4HANA
  • accessing database-level data may require the SAP Enterprise License
  • higher cost of data ingestion, postprocessing and storage

← Return to Data Ingestion Comparison