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?
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.
5 people are following this question.