Manually Installing the Database Engines

MariaDB and MySQL

MongoDB

MariaDB and MySQL

Databases are installed on the Discovery Server to collect, analyze, and work with the data received from the robots. Nintex Process Discovery uses four application databases managed by one or the other database engine:

Database

Database engine

PD application database #1 (data segregated by Team) MySQL 8.0.11 (or higher)

 

 

 

PD application database #2 (data aggregated for all Teams)

Process Library database

User Management platform database

You can choose manually install MariaDB 10.3.7 (or higher) or MySQL 8.0.11 (or higher).

See MariaDB and MySQL – Manual installation

MongoDB

Nintex Process Discovery uses MongoDB to store user actions in collections:

  1. Raw data collections:

  2. Images + metadata recorded by Discovery Robots (segregated by team)

    Collection prefix - pd-rawdata-${TEAM_GUID}

  3. Masked images:

  4. Only if masking is enabled (segregated by team)

    Collection prefix - pd-masking-rawdata-${TEAM_GUID}

Process Discovery automatically installls MongoDB on the PD installation server. However, you can manually install MongoDB on a remote server and configure the connection.
Connecting to remote MongoDB

You can configure the connection to MongoDB before or after you install Process Discovery.

Pre- Process Discoveryinstallation configuration

Post- Process Discoveryinstallation configuration

Pre-Process Discovery installation configuration

If you haven't installed Process Discovery yet and you wish to configure MongoDB first, then follow these instructions:

  1. Download, install, and configure MongoDB and Robo 3T (optional) following the instructions in MongoD Manual Configuration.

  2. Open the file Nintex_PDServer64BitSetup.exe.json and set the parameters according to New Value column in the below table. Note that some parameters are optional.

  3. Run the Process Discovery server installation package.

Parameter

Description

Default value

New Value

Comments

INSTALL_MONGODB

Whether to install MongoDB on Process Discovery server

true

false

-

MONGODB_CONNECTION_STRING

MongoDB connection

mongodb://localhost:27017/kryon-db?authSource=admin

mongodb://${MONGO_SERVER_FQDN}:27017/kryon-db?authSource=admin

Edit the value to include the remote server FQDN. You can also change the default port (27017) and the database name.

MONGODB_DBNAME

Database name for Process Discovery usage

Nintex-db

-

This is an optional configuration, if you choose to change the DB name, make sure you change the connection string appropriately.

MONGODB_ADMIN_USER

Admin user name

Nintex-admin

-

Optional configuration

MONGODB_ADMIN_USER_AUTH

Admin user password

Kryon2020!

-

Optional configuration

MONGODB_Nintex_USER

Default user name

Nintex-rw

-

Optional configuration

MONGODB_Nintex_USER_AUTH

Default user password

Kryon123!

-

Optional configuration

Post-Process Discovery installation configuration

If you have already installed Process Discovery and you wish to configure MongoDB on a remote server, then follow these instructions:

  1. Download, install, and configure MongoDB and Robo 3T (optional) following the instructions in MongoDB and Robo 3T Manual Configuration.

  2. Open the file ${Installation_Folder}\Nintex\installer-assets\config\prod\scripts\config.prod.properties.json and change the following parameters:

  3. Parameter

    Description

    Default value

    New Value

    Comments

    INSTALL_MONGODB

    Whether to install MongoDB on Process Discovery server

    true

    false

    -

    MONGODB_CONNECTION_STRING

    MongoDB connection

    mongodb://localhost:27017/kryon-db?authSource=admin

    mongodb://${MONGO_SERVER_FQDN}:27017/kryon-db?authSource=admin

    Edit the value to include the remote server FQDN. You can also change the default port (27017) and the database name.

    MONGODB_DBNAME

    Database name for Process Discovery usage

    Nintex-db

    -

    This is an optional configuration, if you choose to change the DB name, make sure you change the connection string appropriately.

    MONGODB_ADMIN_USER

    Admin user name

    Nintex-admin

    -

    Optional configuration

    MONGODB_Nintex_USER

    Default user name

    Nintex-rw

    -

    Optional configuration

  4. Run configureAll.ps1 by opening CMD as administrator and running:

  5. CD C:\Nintex\installer-assets\config\prod\scripts
    powershell.exe -Command "C:\Nintex\installer-assets\config\prod\scripts\configureAll.ps1 -h 'C:\Nintex' -configDir 'C:\Nintex\config' -n prod -servicesDir 'C:\Nintex\PDServer\MicroServices' -utilsDir 'C:\Nintex\PDServer\Support'"

  6. Change users passwords (optional):

    1. Open System Environment variables (Start > Edit system environment variables > Environment Variables)

    2. Edit the values of MONGODB_ADMIN_USER_AUTH or MONGODB_Nintex_USER_AUTH

    3. Click OK/Save.

  7. Restart the “Nintex Server - Process Discovery Service” Windows service.