Alteryx Designer and Mongodb Atlas connection

[TandelGouravi]

Hi all,

I am trying to set a connection between Alteryx Designer and Mongodb Atlas to read data from Mongodb Atlas for analysis.

I have connection string of the database.

Can some please help me on how to achieve this. I have gone through the documentation but it was not of much help for me.

thanks in advance.

[Raj]

@TandelGouravi 
MongoDB Advanced Connection Strings (alteryx.com)

hope this helps.

[TandelGouravi]

Hi @Raj ,

I have followed the steps for creating “Unique connection Strings for Workers”

not sure the next steps

[Raj]

@TandelGouravi 

To connect Alteryx Designer to MongoDB Atlas and read data for analysis, follow these steps:

Install MongoDB ODBC or MongoDB JDBC Driver:

Alteryx doesn’t have a direct built-in connector for MongoDB, so you'll need to install either an ODBC or JDBC driver for MongoDB.
You can download MongoDB's ODBC or JDBC driver from the MongoDB website or JDBC driver.

Configure the MongoDB Driver:

Once you’ve installed the driver, configure it using your MongoDB Atlas connection string. The driver typically has a configuration panel where you will paste the connection string (replace placeholders for username, password, etc.).
Ensure that you set the correct authentication method (MongoDB Atlas often uses SCRAM).

Set Up the Connection in Alteryx:

Open Alteryx Designer and go to the Input Data Tool.
For an ODBC driver, select ODBC as your data source and choose the MongoDB ODBC driver from the list of available connections.
If using a JDBC driver, you’ll need to use Alteryx’s Download Tool to execute the connection via Python/R code (since JDBC isn't natively supported in Alteryx).

Query the MongoDB Data:

Once the connection is established, you can query collections from MongoDB by writing MongoDB queries or leveraging the SQL interface provided by the ODBC/JDBC driver (if available).
If you are using a specific tool or version in Alteryx that requires additional configuration, let me know!

hope this helps.