topic Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database in Pipelines

Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

Koraganti77 — Mon, 09 Sep 2024 07:35:26 GMT

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

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

FabianSchut — Mon, 09 Sep 2024 14:51:11 GMT

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

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

Koraganti77 — Tue, 10 Sep 2024 13:29:03 GMT

Hi FabianSchut , thank you for your inputs, I wiill be teting the solution and share my experience here.
again much appreciated 🙂

Best

Srikanth

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

Koraganti77 — Wed, 11 Sep 2024 07:48:10 GMT

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

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

FabianSchut — Wed, 11 Sep 2024 13:29:04 GMT

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:

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

Koraganti77 — Wed, 11 Sep 2024 14:30:39 GMT

sure FabianSchut , I will test this one and come back. thanks a ton though

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

Anonymous — Tue, 17 Sep 2024 07:13:46 GMT

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

Re: Write data from Fabric Onelake to SAP on-prem/cloud database or HANA database

Koraganti77 — Tue, 17 Sep 2024 14:03:37 GMT

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