Forum Discussion

BalajiL's avatar
BalajiL
Resolver I
10 months ago
Solved

SAP realtime integration with Fabric

Business expects to ingest/integrate SAP data in realtime.  What is the best approach to bring SAP data realtime and 5 minute latency is the requirement.    Proposed bringing data from SAP ECC to ...
data engineering
  • BalajiL's avatar
    BalajiL
    10 months ago

    hi v-menakakota : We reached out to MSFT for enabling SAP Mirror private preview for POC. You can close this thread for now, I will come back if there is any specific query.

BhaveshPatel's avatar
BhaveshPatel
Super User
10 months ago

Hi BalajiL 

 

Power BI Dataflow Gen2 is a better option when moving data from SAP.

You can achieve a latency near real-time. Move data from SAP HANA to Fabric SQL, and ETL integration is also available. Data Storage is in ADLS Gen 2 in Delta Lake. 

 

You can connect to SSMS ( SQL Server Management Studio) as well

 

 

 

 

BalajiL's avatar
BalajiL
Resolver I
10 months ago

Thanks BhaveshPatel for your response. Dataflow gen2 does not support SAP ECC and CDC feature - looks a limitation.  Do you have any exposure of bringing SAP ECC  and SAP Hana to Datasphere and then to Fabric considering SAP restricting ODP framework etc. 

  • v-menakakota's avatar
    v-menakakota
    Community Support
    10 months ago

    Hi BalajiL ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    Dataflow Gen2 doesn’t support SAP ECC or CDC as of now, so that’s a limitation for real-time data.

    About your question  moving data from SAP ECC or SAP HANA to Datasphere and then to Fabric is possible, but since SAP restricts some parts of the ODP framework, it may not work for all scenarios. Usually, customers use SAP SLT or Datasphere to first bring the data into ADLS or Azure SQL, and then connect that to Fabric for reporting.

     

    Currently, there’s no direct native option for real-time connection from SAP ECC to Fabric. The SAP mirroring feature that Microsoft is testing in private preview is expected to support this in future.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

    Best Regards, 
    Community Support Team  

    • BalajiL's avatar
      BalajiL
      Resolver I
      10 months ago

      Thanks v-menakakota for your prompt response and clarification. Just a question the SLA to Fabric is 5 minute latency. In that case, if data flows from SAP ECC to Datasphere to ADLS and then to Fabric can meet the 5 minute latency.  How about CDC enabled in this route.  Please clarify.