Mongodb - how to connect?

Question

Hi

I have access to one of our mongo db's using Robo 3t. And it works fine.

I have a collection called UBM2_RawBookings which I want to access in alteryx.

If I connect to the Admin databse it connect fine. But I cannot connect to the others?

MongoDB Input (1) Mongo Error (getCollectionNames) : { msg:"Authentication failed.: generic server error" code: Authentication failed.: generic server error }

image.png

Hamder83 · Answer

I found out :

* The MongoDB Input tool doesn't support the use of an authentication database. You must be able to authenticate directly to the same database from which you want to pull data.

This was the issue for me. If I create a user on the db directly it works.

Evaldo · Answer

I have the same problem. By Localhost e pelo Compass runs, but not by the Alteryx Designer. In my case it is just name and password.

patrick_mcauliffe · Answer

For some connections, I've had to manually type one of the Database names before it would populate the list.

Does the connection use a certificate to authenticate or is it just a name and password?