Hi Team, I am new to Alteryx. I would like to understand a bit more detail about embedded MongoDB. * What data would be stored in this DB? * Is workflow stored anytime in the DB? * Is the Data stored as encrypted in the DB? Many Thanks in Advance. Regards, Ratheesh

Hi @ratheesh, Short answers to your questions: * The data stored is Metadata about the server. It will contain information about schedules, output logs, users, gallery apps, logins etc * If you publish the app to the gallery, then it is stored in the MongoDB or if you decide to select 'Run workflow from Scheduler DB when scheduling then it will be stored in the DB. However, it is not readily readable. * Some of the information is encrypted, some is stored as Blobs, and some is just raw data, but remember that the MongoDB in itself is not unprotected... As with anything, you should guard those passwords.

how data stored in MongoDB

ratheesh

Hi Team,

I am new to Alteryx. I would like to understand a bit more detail about embedded MongoDB.

What data would be stored in this DB?
Is workflow stored anytime in the DB?
Is the Data stored as encrypted in the DB?

Many Thanks in Advance.

Regards,

Ratheesh

MongoDB

Accepted answers

KaneG

Hi @ratheesh,

Short answers to your questions:

The data stored is Metadata about the server. It will contain information about schedules, output logs, users, gallery apps, logins etc
If you publish the app to the gallery, then it is stored in the MongoDB or if you decide to select 'Run workflow from Scheduler DB when scheduling then it will be stored in the DB. However, it is not readily readable.
Some of the information is encrypted, some is stored as Blobs, and some is just raw data, but remember that the MongoDB in itself is not unprotected... As with anything, you should guard those passwords.

All comments

KaneG

Hi @ratheesh,

Short answers to your questions:

The data stored is Metadata about the server. It will contain information about schedules, output logs, users, gallery apps, logins etc
If you publish the app to the gallery, then it is stored in the MongoDB or if you decide to select 'Run workflow from Scheduler DB when scheduling then it will be stored in the DB. However, it is not readily readable.
Some of the information is encrypted, some is stored as Blobs, and some is just raw data, but remember that the MongoDB in itself is not unprotected... As with anything, you should guard those passwords.

ratheesh

Thank you for the response!!

ToddNT

@KaneG Anywhere we can find further documentation?

KJennings

Hi,

I would like to elaborate on the original poster's question. It makes sense that the info described would be located in the MongoDB, but where and how is it stored, and can it be retrieved?

For example, I need to generate a report of all my server's users, grouped by permission. Where does one find that data in MongoDB? Or, I need to generate a list of all workflows on the server, by owner. Again, where does one find that data in MongoDB?

Is any of this documented at all?

Regards,

Kevin Jennings

csmallwood

@KJennings

Have you reviewed the server usage workflow?

https://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-Server-Usage-Monitoring-amp-Reporting/ba-p/35688

great post to get you started

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280