Forum Discussion

chinian811's avatar
chinian811
Regular Visitor
8 months ago
Solved

Data extraction from SAP S/4 HANA Public Cloud

Hello everyone. I am new to the forum. The data of my organization resides in SAP S/4 HANA (Public Cloud version) and we would like to extract the data into Fabric for analytics and reporting.   Do...
  • deborshi_nag's avatar
    8 months ago

    Hello chinian811 

     

    No, unfortunately you cannot use the Fabric “SAP HANA database” connector directly against SAP S/4HANA Public Cloud.
     
    You can use:
    1. OData APIs / CDS Views exposed via communication arrangements in S/4HANA Public Cloud, then ingest with Fabric (Dataflows Gen2 / Pipelines) or Power BI. 
    2. SAP Datasphere → Fabric via Microsoft’s Mirroring/Copy Job integrations, or via partner tools that replicate SAP data into OneLake with business context preserved. Please note this is a Preview feature! 

    Hope this helps - please appreciate giving a Kudos or accepting as a Solution

  • v-sgandrathi's avatar
    8 months ago

    Hi chinian811,

    Thank you deborshi_nag for your response to the query.

    Along with the information already provided, here are a few key practical points you may want to mention to the customer:

     

    Authentication & security: S/4HANA Public Cloud requires API-based access, so you’ll need to coordinate with your SAP admin to set up Communication Users, Communication Systems, and Communication Arrangements. Only approved APIs and CDS views are accessible.

    Data scope: Not all tables or fields are available in the Public Cloud. Reporting is typically based on released CDS views, which may need to be checked to ensure they meet specific requirements.

    Performance & data volume: OData extraction works best for incremental or specific datasets and isn’t intended for large-scale replication. For high volumes, consider Datasphere or certified SAP partners.

    Change data capture (CDC): OData APIs don’t offer native CDC. Incremental updates rely on delta-enabled CDS views or timestamp filters.

    Licensing & roadmap: Some integrations, like SAP Datasphere to Fabric, may depend on license or preview status, so it’s important to confirm availability and SLAs before using in production.

    Thank you.