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