MongoDB connection to Atlas Cloud

Hi,
wanting to test MongoDB and set up a free server on Atlas. Unfortunately they don’t officially support Knime to connect.
I have a look a the MongoDB nodes, but have to admit I am not sure how to fill out the form to connect.

E.g. a comparable Java snippet copied from Atlas would look like this:
mongodb+srv://:@cluster0.foo.mongodb.net/?retryWrites=true&w=majority

Username & password are obvious.
Database would be
Collection must be cluster0
so what is host? foo.mongodb.net? or cluster0.foo.mongodb.net ?
and what about authentication db? the login site? account.mongodb.com?

thanks in advance.

Hi,
The authentication db is optional and can be left empty. The host is cluster0.foo.mongodb.net. Are you sure your collection is called cluster0? It is a collection of documents in the database, but here cluster0 is basically the name of the instance your DB is running on.
Kind regards,
Alexander

Thanks.
You are right, cluster0 is the instance.
Guess I am though still not doing it right, I get a time-out.

It’s not a drama - I will resort to the GUI given by Atlas for now. Working with NoSQL after finally knowing some SQL is … a piece of work in itself.

Hi,
If you want to try again with KNIME, let me know! I am happy to help with establishing the connection.
Kind regards,
Alexander

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.