I want to use the created collection as a input in input tool to query it using the post SQL statement
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)
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!
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.