Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Mongodb - how to connect?

Hamder83
11 - Bolide

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? 


Hamder83_0-1633002937471.png

Hamder83_1-1633003032458.png

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

Hamder83_2-1633003131184.png

 

5 REPLIES 5
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Hey @Hamder83 are you using the fqdn with ":port" at the end?

Something like this:

mymongomachine.domain:27018

Hamder83
11 - Bolide

Hamder83_0-1633352567238.png


But it does not show anything in Database, and I cannot get to recon anything than if I enter admin

 

Hamder83_0-1633352651469.png

 

 

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

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?

Evaldo
6 - Meteoroid

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.

Hamder83
11 - Bolide

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.

Labels