@pmscorca - Thanks for the question and using MS Q&A platform.
Synapse Analytics provides a managed virtual network feature that allows you to securely connect to on-premises data sources without the need for a self-hosted integration runtime (IR). Here is a simple reference architecture for using Synapse Analytics with an on-premises data source without a self-hosted IR:
Create a virtual network in Azure and configure a site-to-site VPN connection between the virtual network and your on-premises network.
Create a Synapse workspace and enable the managed virtual network feature. This will allow you to connect to your on-premises data source securely through the VPN connection.
Create a private endpoint for your on-premises data source in the virtual network. This will allow you to access the data source securely over the VPN connection.
Create a linked service in Synapse Analytics that points to the private endpoint for your on-premises data source.
Create a dataset in Synapse Analytics that references the linked service and points to the data you want to analyze.
Create a pipeline in Synapse Analytics that uses the dataset as a source and performs the desired data transformations and analysis.
Instead of using Self Hosted integration runtime you can use proxy machines. We will not go into the details of these solutions in this article, but the following documentation provides a step-by-step guide:
- Tutorial: How to access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint
- Tutorial: How to access SQL Managed Instance from Data Factory Managed VNET using Private Endpoint
By following these steps, you can securely connect to your on-premises data source without the need for a self-hosted IR. Let me know if you have any further questions!
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.