How to create a collection(table) in Mongo DB and access it from input tool?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to use the created collection as a input in input tool to query it using the post SQL statement
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
