How to create a collection(table) in Mongo DB and access it from input tool?

Question

I want to use the created collection as a input in input tool to query it using the post SQL statement

JoeS · Answer

Hi @Harathi1

There is also the MongoDB output tool as well if you want to write to MongoDB.

So you can read and write using those tools.

If you must use an ODBC driver you would need to find a 3rd party one that will integrate with Alteryx. Personally I have been happy with the MongoDB tools, as they do allow a nice interface and allow you to filter before reading the data in as well.

Harathi1 · Answer

Hi @JoeS

Thank you for the quick response, I want to write data in mongo DB

example :we create a table in SQL right similarly I want to create a collection (table) in mongo DB  and read it back using the input tool(using ODBC connection) so that I can use pre SQL and post SQL statements to filter or update the data in DB.

Thanks in advance!

JoeS · Answer

Hi @Harathi1

To read from MongoDB there is a specific building block for that function.

You will find it in the Connectors section of the palette "MongoDB Input".

You can also search in the top right (the way I do it so I don't have to navigate over to the connectors section)