Can we Make private enpoint connection between Azure SSIS-IR and Azure SQL Database or it is possible only with azure SQL instance

Question

Hello Guys ,

I am doing Lift and shift SSIS project on Azure , using ADF SSIS-IR and Azure SQL database . want to make secure connection using private endpoint.

but wont find any way how to proceed with that.. Appreciated if any suggestion /pointer on this.

Answer 1

@Bhalchandra Ramchan Patil Thank you for reaching out to Microsoft Q&A.

As given here in the Azure SSIS document, Use an Azure SQL Database server with IP firewall rules/virtual network service endpoints or a managed instance with private endpoint to host SSISDB.

You can use a service endpoint if using Azure SQL Database server and not a private endpoint. The difference between a service endpoint and private endpoint access is as follows:

*Azure Private Link (Private Endpoint) allows you to access Azure PaaS services over Private IP address within the VNet. It gets a new private IP on your VNet. When you send traffic to PaaS resource, it will always ensure traffic stays within your VNet.

Azure Service Endpoint provides secure and direct connectivity to Azure PaaS services over an optimized route over the Azure backbone network. Traffic still left your VNet and hit the public endpoint of PaaS service.

Access:
Service endpoint — It remains a publicly routable IP address.
Private endpoint — It is a private IP in the address space of the virtual network where the private endpoint is configured.*

Hope this helps! Please let us know if you have any further questions and we will be glad to assist you further. Thank you!

Remember:

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.