Name | Environment | Environment select | Run options | Installation needed | Supported connectors | Real-time support | Application layer extraction | Database layer extraction | SAP Extractors, CDSViews support | New records (deltas) processing for CDSViews/HANA Calculation views | BW data extraction support | Free of additional costs | Independent of SAP SLT | Pricing | Schema conversion | DeltaLake support | Historical data load (primary system) | Filtered historical load |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Fivetran HVA | 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) | ||
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 | ✅ | ✅ | ✅ (via CDC, or via triggers for HANA) | ✅ | ✅ (for the ODP connector only?) | ✅ (via ODP) | ❌ (installation needs additional HW) | ✅ (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) | ☑️ |