Share via

How to Directly Connect Azure synapse workspace to MongoDB atlas (running on private network) without using SHIR ?

BM 46 Reputation points
2024-05-17T06:11:44.86+00:00

Hello,

Azure synapse Analytics configuration:
Public network access to workspace endpoints : Enabled
Allow Azure services and resources to access this workspace: Enabled
IP: Allowed all
Allow Azure Synapse Link for Azure SQL Database to bypass firewall rules: Enabled.

MongoDB Atlas:

Private endpoint enabled to connect with azure services.
Public Access Not allowed.

Problem:
I cannot create private endpoint from MongoDB atlas to allow access to azure synapse. Currently only solution was using SHIR method which required VM as proxy server and this seems bad solution as there is no other use of VM than using it only for proxy server between azure synapse and MongoDB atlas.

Question:
Is there any way to establish connection between azure synapse and MongoDB atlas without enabling public access to MongoDB Cluster or using SHIR method ?

Can we get outbound IP of azure synapse?

Can we create private endpoint between MongoDB Atlas and Azure synapse to create secure connection?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,503 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,291 Reputation points Microsoft Employee
    2024-05-20T10:30:54.88+00:00

    Hi BM,

    Thank you for posting query in Microsoft Q&A Platform

    Could you please try below steps and see if that helps?

    1. Create a virtual network in Azure that will be used to host the private endpoint.
    2. Create a private endpoint in the virtual network for MongoDB Atlas. This will allow Azure Synapse to access MongoDB Atlas through the private endpoint.
    3. Configure the private endpoint to use a private IP address that is within the same IP address range as the virtual network used by Azure Synapse.
    4. Configure the MongoDB Atlas cluster to allow traffic from the private IP address range used by the virtual network.
    5. Configure Azure Synapse to use the private endpoint to access MongoDB Atlas.

    If above not helps, then you might need to consider using SHIR.

    Hope this helps. Please let me know how it goes.