Forum Discussion
Copy data activity on microsoft fabric and mongodbAtlas problem connection
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
Hi BartoloIsmail ,
You can use this SQL Connection String with following authentication methods.
Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
I also checked the possible connection options with Talend Cloud - List of supported connectors | Talend Cloud Data Preparation User Guide Help
You can also send your data to adls gen 2 and can pull it into lakehouse using fabric data factory.
If you like to connect with MongoDB Atlas, please follow this link - Configure MongoDB Atlas in a copy activity - Microsoft Fabric | Microsoft Learn
Hope this provided some insights. Do let me know incase of further queries.
HI BartoloIsmail ,
We haven’t heard from you on the last response and was just checking back to see if you got some insights over your query.
Otherwise, will respond back with the more details and we will try to help .
Thankshi Anonymous
I'm reaching out again because the problem persists, and I would like to get additional help for troubleshooting the connection.
Hi BartoloIsmail ,
Apologize for the issue you are facing. The best course of action is to open a support ticket and have our support team take a closer look at it.
Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Hope this helps. Please let us know if you have any other queries.