topic MongoDB Atlas Data Copy Connectivity in Pipelines

MongoDB Atlas Data Copy Connectivity

blull — Mon, 04 Dec 2023 19:13:12 GMT

I'm trying to utilize the new MongoDB Atlas connector in Data Pipelines/Copy Data, but have had no luck at all connecting to my MongoDB Atlas database. It seems to be a connectivity issue or something wrong with my connect string. Can anyone help with the proper format on setting up atlas as a source? Things I've tried for the server:

mytest.vsd37ej.mongodb.net
- Internal error has occurred.
  Activity ID: 5c2fb0a3-5eab-4817-9e64-92f478d17401
mongodb+srv://<username>:<password>@mytest.vsd37ej.mongodb.net
- >Connection to MongoDB server is timeout.
  A timeout occurred after 30000ms selecting a server using CompositeServerSelector{ Selectors = MongoDB.Driver.MongoClient+AreSessionsSupportedServerSelector, LatencyLimitingServerSelector{ AllowedLatencyRange = 00:00:00.0150000 }, OperationsCountServerSelector }. Client view of cluster state is { ClusterId : "2", Type : "Unknown", State : "Disconnected", Servers : [] }.

It could also be a firewall related issue but I did set a whitelist for 0.0.0.0 in my testing and it didn't make a difference either way. are there set IPs I need to whitelist in Atlas so fabric can communicate? I

Re: MongoDB Atlas Data Copy Connectivity

v-cboorla-msft — Tue, 05 Dec 2023 12:03:11 GMT

Hi blull

We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Re: MongoDB Atlas Data Copy Connectivity

blull — Sun, 10 Dec 2023 13:07:03 GMT

Any updates on this?

Re: MongoDB Atlas Data Copy Connectivity

v-cboorla-msft — Thu, 21 Dec 2023 05:36:09 GMT

Hi blull

Apologies for the issue that you are facing.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Thank you.

Re: MongoDB Atlas Data Copy Connectivity

BartoloIsmail — Tue, 14 May 2024 08:30:23 GMT

i have also the same issus with my copy activity in microsoft fabric. Should I check if there are specific permissions for Microsoft Fabric to access my mongodb atlas collection? I successfully retrieved data via a Python script and added my IP to the list of IPs.

Re: MongoDB Atlas Data Copy Connectivity

BartoloIsmail — Tue, 14 May 2024 09:08:11 GMT

'm trying to copy data via a pipeline using Microsoft Fabric to retrieve my MongoDB Atlas collection. I had an error that I corrected by adding a parameter that allows access to all IPs to access the MongoDB service. After running the test, I now encounter a new error that appears (progress... :)). I'm coming to you to ask if you could explain where this new error might be coming from. Thank you for your help.