Forum Discussion

sreekanthreddy's avatar
sreekanthreddy
New Member
1 year ago
Solved

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 
  • govindarajan_d's avatar
    1 year ago

    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.

     

    https://theobald-software.com/en/microsoft-fabric/