Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BartoloIsmail ,

Thanks for using Fabric Community.

Here are some steps to troubleshoot the connection and set up MongoDB Atlas as a source:

 

  1. Verify Connection String:
    • Double-check your connection string for typos or incorrect formatting.
  2. Firewall Rules:
    • Ensure your network allows outbound connections to MongoDB Atlas on port 27017 (or the custom port you might be using). Check your Data Pipelines service's network configuration and any firewalls in between.

 

Additional Tips:

Consider increasing the timeout value in your connection string using connectTimeoutMS parameter. This might help if there's a slight delay in establishing the connection.

Docs to refer - Configure MongoDB Atlas in a copy activity - Microsoft Fabric | Microsoft Learn

Hope this helps. Do let us know incase of further queries.

BartoloIsmail's avatar
BartoloIsmail
Frequent Visitor
2 years ago

Is there a way to deposit a JSON file into my bronze layer of my Microsoft Fabric lakehouse in a non-manual manner using a Talend job, for example, without using the MongoDB Atlas pipeline connectors or MongoDB Atlas SQL via Gen2 flows? I've noticed that there are SQL string connections available, but they seem only usable by tools like Power BI Desktop, for instance