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 }
Hey @Hamder83 are you using the fqdn with ":port" at the end?
Something like this:
mymongomachine.domain:27018
But it does not show anything in Database, and I cannot get to recon anything than if I enter admin
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?
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.
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.