topic Re: Connect to SAP HANA database through data gateway with COPY in Pipelines

Connect to SAP HANA database through data gateway with COPY

amaaiia — Fri, 14 Jun 2024 11:53:23 GMT

I'm trying to get SAP HANA database data through data gateway but I can't. I get the following error:

Where is Use encrypted connection option? I can't find it.

Re: Connect to SAP HANA database through data gateway with COPY

Anonymous — Mon, 17 Jun 2024 06:14:51 GMT

Hi amaaiia
Thanks for using Fabric Community.
The option mentioned above is as follows:

For more information refer to this link:
Power Query SAP HANA database connector - Power Query | Microsoft Learn

Hope this helps. Please let me know if you have any further questions.

Re: Connect to SAP HANA database through data gateway with COPY

amaaiia — Mon, 17 Jun 2024 06:23:08 GMT

Hi,

This option is available when connecting through Dataflow gen2. But not through COPY activity in a data pipeline (as it can be shown in mi screenshot)

Re: Connect to SAP HANA database through data gateway with COPY

Anonymous — Wed, 19 Jun 2024 17:48:50 GMT

Hi amaaiia
The internal team has confirmed that Copy Gateway to SAP is under development. It is advised to use Dataflow Gen2 for now.
Hope this helps.