Forum Discussion
Connect to Sap ecc to Microsoft fabric
How to connect SAP ECC to Microsoft Fabric and load data into one lake house?
Which connector need to use
Hi sreekanthreddy,
There is a SAP HANA connector in Fabric that you can use to connect at the database level of SAP ECC (if it is on HANA).
Other than that, there are multiple SAP Connectors in ADF that you can look into. I have not used SAP ECC with Fabric Lakehouse as destination (in ADF), but you can try that approach. If it doesn't work for some reason, you can always extract ECC data as parquet and then convert into delta. One advantage you have is you can call Fabric data pipelines from ADF (through REST API) and in reverse as well. More of a well integrated approach.
Apart from all of this, there are multiple third party ETL tools like Fivetran which have SAP connectors and it also supports Fabric Lakehouse. Theobald is another option.
5 Replies
- govindarajan_d
Super User
Hi sreekanthreddy,
There is a SAP HANA connector in Fabric that you can use to connect at the database level of SAP ECC (if it is on HANA).
Other than that, there are multiple SAP Connectors in ADF that you can look into. I have not used SAP ECC with Fabric Lakehouse as destination (in ADF), but you can try that approach. If it doesn't work for some reason, you can always extract ECC data as parquet and then convert into delta. One advantage you have is you can call Fabric data pipelines from ADF (through REST API) and in reverse as well. More of a well integrated approach.
Apart from all of this, there are multiple third party ETL tools like Fivetran which have SAP connectors and it also supports Fabric Lakehouse. Theobald is another option.
v-achippaCommunity Support
Hi sreekanthreddy,
Thank you for reaching out to Microsoft Fabric Community.
Thank you govindarajan_d for addressing the isue.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user for the issue worked? or let us know if you need any further assistance?
If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Anjan Kumar Chippa
- v-achippa
Hi sreekanthreddy,
We wanted to kindly follow up to check if the solution provided by the super user for the issue worked
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Anjan Kumar Chippa
