How to resolve MongoDbConnectionTimeout for Azure Data Factory

Jake K 0 Reputation points
2024-02-29T16:14:40.7033333+00:00

Hello! Requesting guidance in setting up MongoDB Atlas as a source on Azure Data Factory. Our connection test as a linked service passes and we are able to preview collections when attempting to set up the pipeline. However, every run fails with
MongoDbConnectionTimeout

Failure happened on 'Source' side. ErrorCode=MongoDbConnectionTimeout,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=>Connection to MongoDB server is timeout.,Source=Microsoft.Connectors.MongoDbAtlas,''Type=System.TimeoutException,Message=A timeout occurred after 30000ms...

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,460 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2024-02-29T22:34:54.9733333+00:00

    Hello Jake , Since you are able to see the data in preview, that's means the connection the DB is just fine. I also see that that you are getting a timeout, I suggest you check as to what is the volume of data which you are trying to pull? Try with a small set and see if that works. Thanks
    Himanshu


  2. Tanner Bell 0 Reputation points
    2024-03-19T18:08:25.0866667+00:00

    Okay so I discovered the issue and it is that the AutoResolveIntegrationRuntime will change regions on you so you either have to create your own integration runtime and whitelist that IP address in mongo or set up a peer connection.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.