Forum Discussion

ati_puri's avatar
ati_puri
Icon for Resolver III rankResolver III
8 months ago
Solved

SAP ECC Connector Support in MS Fabric

Hi Team,   We are looking towards ingesting huge volumes of SAP ECC data into Fabric. As SAP discontinues OData connectivity with ADF and SAP BDC (Datasphere)connector is coming next year, will SAP...
data engineering
  • deborshi_nag's avatar
    deborshi_nag
    8 months ago

    Hi ati_puri 

     

    You can use Qlik Replicate to ingest SAP ECC data. This design is widely used for ECC data. 

     

    • Qlik Replicate can directly connect to the underlying ECC database (e.g., Oracle, SQL Server, DB2, HANA), capturing DML changes via log-based CDC or trigger-based CDC.
    • For log-based CDC, it reads the database transaction logs (redo/online/backup logs).
    • In trigger-based CDC, the system installs INSERT, UPDATE, DELETE triggers on selected source tables, which route change information into a CDC table (e.g., attrep_cdc_changes).

    Ingestion Process Overview

    1. Initial Full Load

      • Qlik performs a full extract of tables selected via SAP Business Groups, loading them into the target i.e. OneLake.

    2. Ongoing CDC (Apply Changes)

      • Changes are captured either via log reads or triggers and applied in near-real-time to the target.
      • Qlik ensures transactional consistency and preserves change order. 

    3. End-to-End Flow

      • Source → Full Load → Change Capture → Apply Changes → Target.
      • Qlik creates CDC artifacts (tables/triggers) automatically if authorized, enabling seamless setup.

    Hope this helps, please appreciate giving a Kudos or by accepting as a Solution!