Forum Discussion
Data extraction from SAP S/4 HANA Public Cloud
- 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:- OData APIs / CDS Views exposed via communication arrangements in S/4HANA Public Cloud, then ingest with Fabric (Dataflows Gen2 / Pipelines) or Power BI.
- 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!
- 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.
Hi chinian811,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help.
Thank you.