question

NavinDondapati avatar image
0 Votes"
NavinDondapati asked KranthiPakala-MSFT commented

SAP HANA View as External Table from On-premise

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

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @NavinDondapati,

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.

0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @NavinDondapati ,

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 Docs

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NavinDondapati ,

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.

0 Votes 0 ·

Hi @NavinDondapati ,

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.





0 Votes 0 ·