We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Server Discussions

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

Connecting to Server's MongoDB

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.


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.
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
17 - Castor
17 - Castor

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

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

5 - Atom



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.



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.

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.

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?

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.

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?