SAP Data Ingestion Tools Comparison Table

NameEnvironmentEnvironment selectRun optionsInstallation neededSupported connectorsReal-time supportApplication layer extractionDatabase layer extractionSAP Extractors, CDSViews supportNew records (deltas) processing for CDSViews/HANA Calculation viewsBW data extraction supportFree of additional costsIndependent of SAP SLTPricingSchema conversionDeltaLake supportHistorical data load (primary system)Filtered historical load
Fivetran HVA
Azure, AWS, GCP
azureawsgcp
SaaS + agent
* SAP ECC (Oracle, MSSQL) * SAP S/4HANA
✅ (via CDC)
✅ (via CDC)
❌ (low-level tables only)
❌ (low-level tables only)
❌ (agent needs additional HW)
☑️ (but for low-level tables only)
consumption based (# of rows processed)
✅ (source)
✅ (source)
via the SAP Application Layer, High Volume Agent
Azure, AWS, GCP
azureawsgcp
on-prem
✅ (via CDC)
✅ (via CDC)
❌ (low-level tables only)
❌ (installation needs additional HW)
✅ (source)
via the SAP Application Layer and LDP Agent
Azure only
azure
SaaS + agent
integration runtime needs to be installed on an on-premises computer or on a virtual machine (VM).
* CDC (via ODP) * SAP BW OpenHub * SAP BW via MDX * SAP ECC * SAP HANA * SAP Table
❌ (batches only, every 5 minutes)
✅ (via SLT and ODP)
✅ (via ODP)
❌ (integration runtime needs additional HW)
☑️ (SLT is recommended and needed for SAP tables extraction)
✅ (source)
via the SAP Application Layer
❌ (source)
Azure, AWS, GCP
azureawsgcp
on-prem
installed as ABAP add-on on ERP server (no additional hardware required)
* Tables * Custom ABAP extractors * Views (HANA calculation and CDS Views), BW * Extractors (SAPI/ODP) * Info Providers (DSOs, ADSOs, Cubes) * BEx queries * Raw data etc.
✅ (near-real time)
✅ (via triggers)
✅ (via ODP)
✅ (installed as ABAP addon onto an existing SAP Netweaver machine)
✅ (but can work with SLT if already in place)
# of ingestion pipelines/ingested tables (tiered)
utilize standard SAP select options
Qlik Replicate
azureawsgcp
on-premSaaS + agent
full app installation (on-prem version)
* SAP Application * SAP Application (DB) * SAP Extractor * SAP HANA * SAP ODP
✅ (log-based + trigger based)
✅ (via CDC, or via triggers for HANA)
✅ (for the ODP connector only?)
✅ (via ODP)
❌ (installation needs additional HW)
✅ (see release log)
✅ (source)
✅ (source)
Azure, AWS, GCP
azureawsgcp
on-premSaaS
full app installation (on-prem version, Kubernetes)
❌ (installation needs additional HW)
❌ (custom connector needed)
AWS only
aws
SaaS
❌ (fully SaaS)
❌ (micro-batches only)
✅ (ODP via OData)
❌ (ODP only)
✅ (via ODP)
✅ (it’s SaaS)
☑️
❌ (parquet or CSV only)
ODP via oData only (slower)
GCP only
gcp
SaaS
❌ (fully SaaS)
✅ (via SLT)
✅ (via SLT)
✅ (via ODP)
✅ (it’s SaaS)
☑️