Forum Discussion
Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database
Hi Koraganti77,
Unfortunately, the Data Flow Gen2 doesn't support a data destination like SAP on-prem/cloud or HANA. The list of data destinations can be found here: https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-data-destinations-and-managed-settings.
If you are looking for a low-code option to provide a write back to SAP on-prem/cloud or HANA, you could use the copy activity within a data pipeline from MS Fabric. There SAP on-prem/cloud or HANA is supported, as can be found here: https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-support#s.
If you are familiar with Python, you could also use a notebook and write your own script to write the data to SAP cloud or HANA. On-prem would be more difficult in this case, due to the fact that there is no on-prem gateway for the notebook in Fabric yet.
Therefore, I suggest you use a copy activity.Kind regards,
Fabian
Solution SageHi Koraganti77,
How did you try to setup the connection to SAP HAHA? Could you follow these steps:
Manage connections and gateways
And select On-premises. Within On-premises, you have the option to select the SAP HANA:
sure FabianSchut , I will test this one and come back. thanks a ton though
Hi Koraganti77 ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Yilong Zhou