Error connect MongoDB Atlas SQL ODBC

Hi,

I’m trying to connect to MongoDB Atlas SQL ODBC, but I get the following error:

In field MongoDB set: mongodb+srv://fortaleza-production.xv7f8.mongodb.net

Hi There - I can tell right away that you are not using the correct MongoDB URI. Atlas SQL requires a Federated Database Instance, and then the SQL Endpoint/URI points to that. You can enable Atlas SQL with a Quickstart federated database or Advanced configuration - see here https://www.mongodb.com/docs/atlas/data-federation/query/sql/getting-started/

And once you have enabled Atlas SQL, you then select the “connect” button from the federated database instance cards then select the Atlas SQL tile:


Hope this helps.

1 Like

Hi Alexi,

Thanks for the quick response

I’ll test it with this solution you gave me.

I saw in the image that the driver is selected for PowerBI. Can you tell me if I can make it work this same way in the Alteryx program?

Thank you again