Error connect MongoDB Atlas SQL ODBC

Alcides_Tiriritan_Neto · October 19, 2023, 2:00pm

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

Alexi_Antonino · October 19, 2023, 2:19pm

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.

Alcides_Tiriritan_Neto · October 19, 2023, 2:37pm

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