Forum Discussion
Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database
Dear Memebers,
I have a busness requirement (Part of POC) where I need to write data from Fabric Onelake to SAP on-pre/cloud or HANA database usinng Dataflowgen2 or power query etc.. Any inputs, guidelines greatly appreciated.
Thanking in advance
Best
Srikanth
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
7 Replies
FabianSchut , thank you once again; we were able to write back to SAP HANA database tables via Fabric Pipeline Copy activity; we have used ODBC connection setup to achieve this after resolving intial hiccups.
Much appreciated your support and time.
Best
Srikanth
- FabianSchut
Solution Sage
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
Hi FabianSchut , thank you for your inputs, I wiill be teting the solution and share my experience here.
again much appreciated 🙂Best
Srikanth
Hi FabianSchut ,
When we tried to leverage the Copy Activity to write back to SAP HANA DB(on-prem instance), don't see SAP application under destination tab direct connector, and for ODBC connector the connection was successful ( same connection was used to pull data from SAP into Onelake in Fabric) but while expanding the Table property we get " Failed" error message( there are 100,000 tables are there under that connection). screen prints can be seen below.On other note,
1. does delta parquet format supported by SAP systems while writing the data to SAP HANA tables ?
2. does it require to change the delta parquet to SAP compatible while writing ?
Thanks in advance for your time and support
Best
Srikanth
- FabianSchut
Hi Koraganti77,
How did you try to setup the connection to SAP HAHA? Could you follow these steps:
Manage connections and gatewaysAnd 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
