Problem in connecting to Mongodb Atlas

KNIME Extensions
21

Hi Alexander,
When I am trying to pick the right collection to write on (with the node MongoDB writer), I am facing kind of a similar issue.
I am trying to “Select Collection” and fetch but I am getting back the error message “not authorized on config to execute command”.

My team is mentioning this to me:
It seems you are connecting to “config”, a system-only database,
Could you try with “heroku_xxxx” please, our data are in this db

Should we actually investigate there? If I am not pointing on the right place, it would explain why the table is empty?

Bertrand

22

Hi Bertrand,
Yes, maybe that is it. What are you using as authorization database in the connector node and what are you selecting in the Reader node?
Kind regards,
Alexander

23

Hi Alexander,

Authentification database - I was using the heroku_xxx but I also tried admin.
In the reader node, I was only using the heroku one.
But seems with the “read” rights on every table, that is now working !

Thanks a lot for your help in the last days, that was very useful ! A new database connected through Knime (already using sql server, postgre and neo4j and Knime is great to be able to merge all those data !)
Bertrand

24

Hi Bertrand,
Great to hear! Happy KNIMEing!
Alexander