Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Connecting to Server's MongoDB

patrick_digan
17 - Castor
17 - Castor

We have apps that use the MongoDB Input tool to read our Alteryx Mongo files. It works great on the server and in apps on the gallery. My only question is there a simple way to modify the tool so that the workflow would also work on my local machine? Obviously the localhost would have to change to something else, but my basic attempts at putting in the server name or IP address did not immediately work.

Untitled.png

17 REPLIES 17
AngelaO
Alteryx Alumni (Retired)

For it to work remotely, you would need to update where it says 'localhost' to the IP or hostname of the server.  See the yellow area below.mongo1.JPG
Ir the IP/Hostname is correct, perhaps it is failing because port 27018 is being blocked by a firewall?  You can test to see if the port is open from a command prompt using the telnet command (assuming its installed).  If the port is blocked or the service isn't available, you will get a response saying could not open connection to the host on port xxx.
e.g.
mongo2.JPG
 
If you connect to it successfully you will get a blinking cursor that will eventually drop you back at the command prompt like this: mongo2.JPG
Is your port being blocked?
Customer Support Engineer
patrick_digan
17 - Castor
17 - Castor

My telnet command indeed fails on that port. I will do some further digging.

levell_x_dunn
10 - Fireball

As long as you know the server IP address, which you can get from the server directly then the mongo connection should work as normal

 

Mongo Connection.jpg

vtadinad
5 - Atom

Hello,

 

The Mongo DB Input tool is not able to connect to the Mongo DB instance in a remote VM.

 

I have given the Server IP address and Port in the Server connection string and the username/password with a Database Name.

 

The collection drop down is not populated with the collections and not connection established.

 

I am able to connect to the same Mongo DB instance using the Compass remotely.

 

Please share your suggestions.

 

Thanks

skaps
7 - Meteor

In case the Alteryx as well the MongoDB are installed in VM, you won't get the DataBase names in the drop-down option, rather you have to enter that manually. once you enter that you click on the canvas and then again click on the MongoDB tool to get that collection being populated automatically.

chient
5 - Atom

Is replica set supported?

 

We have a 3 member replica set (1 primary plus 2 secondary).

After typed in the db name, the "collection" drop down is still not working for us.

KJennings
9 - Comet

We are using Alteryx hosted on VMs as well, and our list of databases does not populate.  Is there documentation on what databases are available within the MongoDB?

levell_x_dunn
10 - Fireball

Hi @KJennings,

 

There are three that I primarily know

 

AlteryxService, AlteryxGallery, AlteryxLucene,

 

I primarily pull from AlteryxService and AlteryxGallery to create my reports for all of the jobs, schedules and Users of the gallery and servers.

KJennings
9 - Comet

Hi @levell_x_dunn.  Thanks for the response.

 

I took a look at the db's you identified, and I wonder if the AlteryxLucene may be a site-specific DB for you, as it fails to connect for me when I try to access it via the MongoDB Input tool?

 

I examined the other two db's and do not see where workflow info may be recorded. Do you happen to include those in your reporting?

 

Regards,

kj