SAP HANA View as External Table from On-premise

Question

SAP HANA View as External Table from On-premise

Dondapati, Navin 291

Hi Guys,

We got SAP HANA views on-premise, we would like to create external table on to Synapse Server less SQL Pool; is it possible? if so how?

Regards,
Navin

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-04-08T04:19:57.853+00:00

Hello @Anonymous ,

Thanks for the ask and also for using the Microsoft Q&A forum.

We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.

1 answer

Your answer

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-04-08T04:19:57.853+00:00

Hello @Anonymous ,

Thanks for the ask and also for using the Microsoft Q&A forum.

We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

Hi @Anonymous ,

After having conversation with internal team, one possible way is that you might want to consider leveraging ADF or Synapse pipeline capabilities to pull in the data to ADLS and then query it with Synapse Serverless SQL pool.

This article should help getting that data into ADLS: Copy data from SAP HANA - Azure Data Factory | Microsoft Learn

Incase if you have any feedback or feature request suggestion regarding this use case, I would recommend you to please log it in Azure Synapse Analytics user-voice : https://feedback.azure.com/forums/307516-azure-synapse-analytics. Please do share the feedback link here once it posted so that other users with similar idea can upvote and/or comment on your suggestion.

Hope this info helps.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-04-09T20:04:13.37+00:00

Hi @Anonymous ,

Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-04-12T17:06:08.607+00:00

Hi @Anonymous ,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Share via

SAP HANA View as External Table from On-premise

1 answer

Your answer