topic Re: Connecting to Server's MongoDB in Alteryx Server Discussions

Connecting to Server's MongoDB

patrick_digan — Thu, 24 May 2018 01:10:43 GMT

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.

Re: Connecting to Server's MongoDB

AngelaO — Mon, 15 Aug 2016 18:21:58 GMT

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.

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.

If you connect to it successfully you will get a blinking cursor that will eventually drop you back at the command prompt like this:

Is your port being blocked?

Re: Connecting to Server's MongoDB

patrick_digan — Mon, 15 Aug 2016 20:35:13 GMT

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

Re: Connecting to Server's MongoDB

levell_x_dunn — Fri, 28 Jul 2017 00:03:35 GMT

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

Re: Connecting to Server's MongoDB

vtadinad — Tue, 07 Nov 2017 15:40:47 GMT

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

Re: Connecting to Server's MongoDB

skaps — Wed, 29 Nov 2017 10:28:12 GMT

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.

Re: Connecting to Server's MongoDB

chient — Thu, 18 Jan 2018 18:21:27 GMT

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.

Re: Connecting to Server's MongoDB

KJennings — Fri, 19 Jan 2018 19:14:54 GMT

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?

Re: Connecting to Server's MongoDB

levell_x_dunn — Fri, 19 Jan 2018 20:38:27 GMT

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.

Re: Connecting to Server's MongoDB

KJennings — Fri, 19 Jan 2018 21:00:41 GMT

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,

Re: Connecting to Server's MongoDB

levell_x_dunn — Fri, 19 Jan 2018 21:37:13 GMT

Hi @KJennings,

It's possible Lucene isn't one I typically use or found useful.

For workflows, you can find that under AtleryxService db and As_applications to get the modules names and users who ran them and when

For what workflow is loaded in the Gallery, I would us appInfos in the AlteryxGallery db give you information on what workflows have been uploaded

Alteryx has a Gallery report tool which was on their download page, but I can't find it anymore, but I used that as one of my starting points and modified it for my own needs

Re: Connecting to Server's MongoDB

KaneG — Sun, 21 Jan 2018 23:09:39 GMT

Just to round off the information. The 3rd DB that you're talking about is AlteryxGallery_Lucene, however you shouldn't need to get anything from that.

Some more info can be found among the User Managed info here.

Re: Connecting to Server's MongoDB

KJennings — Mon, 22 Jan 2018 16:26:02 GMT

Hi @levell_x_dunn, @KaneG

Thank you for that information, it is exactly what I was trying to locate.

Regards,

Re: Connecting to Server's MongoDB

MarcSchoenwandt — Tue, 23 Jan 2018 04:50:21 GMT

Does anyone know where the actual worklflows/apps are stored? I've been snooping around with the MongoDB input, but can't seem to find a way to get my hands on the actual files. I assume they have been stored as blobs and I've converted some of __ServiceData fields that seem to have some data in it, but it looks like it's just metadata and not the actual workflow.

Re: Connecting to Server's MongoDB

The_Dev_Kev_Env — Wed, 21 Mar 2018 14:54:03 GMT

Hi All,

I am in midst of creating an orchestrator of sorts and would like to use the MongoDB as a way to identify if workflow was added to queue or complete.

Use-case aside, the "AS_QUEUE" table shows null for the workflow name that I am running ("appName"). This I assume because it is not an app and I am running it from it's disk location. My question is if there is a way I can get that workflow path/name and join it to the queue/results tables? I have been able to find the workflow path/name in "AS_Applications", but have not found a successful way to join that back to queue/results collections.

Any insight here?

Best,

Re: Connecting to Server's MongoDB

Greg_Murray — Wed, 06 Feb 2019 20:52:31 GMT

Hi there,

Another VM user over here.

I can connect to the VM using telnet. The password and username work fine when connecting to the MongoDB on the server using localhost.

But, If I enter a database name (AlteryxService, AlteryxGallery, etc.), I don't get anything in the Collection drop down. Any ideas what might be happening?

Thanks,

Re: Connecting to Server's MongoDB

JohnBell — Sat, 02 Mar 2019 00:00:56 GMT

@Greg_Murray

I was getting the same thing today.

When I was on the controller the DB and collection would not come up in the drop down; but when I went to the worker machine, after entering the DB, the collection drop down got populated.

I'm not sure why the difference between the controller and worker...

Hope this might help you.

Thanks,

John

Re: Connecting to Server's MongoDB

suzb — Tue, 01 Sep 2020 19:43:54 GMT

we have the same issue. has anyone found a solution to the collection drop-down not working? I'm on Alteryx 2018.3.5