Connect to SAP HANA database through data gateway with COPY

[amaaiia]

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.

[v-nikhilan-msft]

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.

[amaaiia]

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)

[v-nikhilan-msft · Accepted solution]

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.