Logo

    SAP Data Ingestion Tools Comparison Table

    Name
    Environment
    Environment select
    Run options
    Installation needed
    Supported connectors
    Real-time support
    Application layer extraction
    Database layer extraction
    Extractors support
    New records (deltas) processing for CDSViews/HANA Calculation views
    BW data extraction support
    Free of additional costs
    Independent of SAP SLT
    Pricing / 100 sources
    Schema conversion
    DeltaLake support
    Historical data load (primary system)
    Filtered historical load
    Azure DataFactory

    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)

    # of runs, per hour of run

    ✅

    ✅ (source)

    via the SAP Application Layer

    ❌ (source)

    SNP Glue

    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

    Azure, AWS, GCP

    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)

    ✅

    ✅

    SAP Data Intelligence

    Azure, AWS, GCP

    azureawsgcp
    on-premSaaS

    full app installation (on-prem version, Kubernetes)

    * Read HANA Table * SAP HANA Client * SLT Connector * ABAP ODP Reader * ABAP CDS Reader * Data Transfer

    ✅

    ✅

    ✅

    ✅

    ✅

    ✅

    ❌ (installation needs additional HW)

    # of capacity units / month

    ❌

    ❌ (custom connector needed)

    AWS AppFlow

    AWS only

    aws
    SaaS

    ❌ (fully SaaS)

    ❌ (micro-batches only)

    ✅ (ODP via OData)

    ❌ (ODP only)

    ✅

    ✅ (via ODP)

    ✅ (it’s SaaS)

    ☑️

    # of successful runs + amount of data processed

    ❌ (parquet or CSV only)

    ODP via oData only (slower)

    Cloud Data Fusion

    GCP only

    gcp
    SaaS

    ❌ (fully SaaS)

    ✅ (via SLT)

    ✅

    ✅ (via SLT)

    ✅

    ✅ (via ODP)

    ✅ (it’s SaaS)

    ☑️

    paying for pipeline development and execution

    SAP Datasphere

    Azure, AWS, GCP

    azureawsgcp
    SaaS

    ✅

    ✅

    ✅

    ✅

    ✅

    ✅

    ✅

    ✅

    ✅

    ~$60k 1 + $5k/20 GBs outbound data transfer

    ✅

    ✅

    ✅

    ✅

    Asapio

    Azure, AWS

    on-prem

    ✅

    * RAW tables & views * CDSViews

    ✅

    ✅

    ✅ (via triggers)

    ❌

    ✅

    ❌

    ✅

    ✅

    # of ingestion pipelines/ingested tables (tiered)

    ✅

    ✅

    ✅