Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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-se....
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
@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
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
Hi @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:
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
Hi @FabianSchut , thank you for your inputs, I wiill be teting the solution and share my experience here.
again much appreciated 🙂
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-se....
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
5 | |
5 | |
2 | |
2 | |
1 |
User | Count |
---|---|
16 | |
11 | |
7 | |
6 | |
6 |