Forum Discussion
SAP realtime integration with Fabric
- 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.
Hi BalajiL
So, first of all, if you're interested: Microsoft offers a private preview for SAP mirroring.
Maybe it's something for you.
Here is the form for that.
Now to your question. From experience, I use Azure Logic Apps for other things. For example, for starting and stopping Fabric capacity.
If you are looking for something native, you could use Azure Data Factory to load data from SAP.
You could then control these from Fabric.
Here is an overview of the connectors for Azure Data Factory
https://learn.microsoft.com/en-us/azure/data-factory/connector-overview
Then, of course, you still have the usual SAP connectors in Fabric.
You can find them here and see what is supported.
https://learn.microsoft.com/en-us/fabric/data-factory/connector-overview
Of course, there are third-party providers that make this possible, but as you write, this is not an option for your customer, as I understand it.
That would be a first approach for you and your customer. But there are certainly other possibilities.
Perhaps you already have some initial ideas.
Best regards
- BalajiL10 months ago
Resolver I
Hi spaceman127
Thanks for your prompt response. Fabric data factory has limited SAP connectors and data factory can be used for batch processing. The ask is how to integrate realtime data into Fabric from SAP systems. SAP mirroring will be good option and that is still in private preview. Why Azure logic was suggested to have bi-directional sync and getting data realtime but it will be suitable for low volume data.
- spaceman12710 months ago
Super User
All right,
I would stick with Fabric. Preview features always carry a risk, of course, but it's worth testing.
DataFlow Gen2 in conjunction with Fabric SQL is an alternative that could also work very well, as BhaveshPatel writes.
He was quicker with the next answer 🙂
Best regards