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
How to resolve MongoDbConnectionTimeout for Azure Data Factory
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...
2 answers
Sort by: Most helpful
-
HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
2024-02-29T22:34:54.9733333+00:00 -
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.