Error connect MongoDB Atlas SQL ODBC


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

In field MongoDB set: mongodb+srv://

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

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