Installing and configuring MongoDB to prepare for Talend Installer installation

Before you install Talend Data Stewardship, Talend Data Preparation, or Talend Dictionary Service with a Talend Installer, you must install and configure a MongoDB instance.

Before you begin

Download the following packages from the MongoDB website:

MongoDB server for your operating system
MongoDB Tools - Mongo Shell
MongoDB Command Line Database Tools (required for Talend Dictionary Service only)

Procedure

Install the MongoDB server package and set up MongoDB server as a system service.
Create a secret password for the MongoDB administrator user and store it in a safe place.
For example:
- Username: AdminUser
- Password: Password1
Use the Mongo Shell utility to install the MongoDB Shell package. This utility is called mongo in older releases and mongosh in recent releases.
Open a terminal window from the right folder and start the Mongo Shell utility to run the server without authentication.
For example, if MongoDB is installed on a localhost and on standard port (27017) then use the following command to connect to it:
```
mongo --port 27017
```

After connection, create AdminUser in admin database with the following commands:

use admin
db.createUser( { user: "AdminUser", pwd: "Password1", roles: [ { role: "userAdminAnyDatabase", db: "admin" }, { role: "clusterAdmin", db: "admin" } ] } )
exit

Shut down the MongoDB server with the systemctl stop command for Linux or with the Services applet for Windows.
Locate MongoDB configuration file called mongod.cfg. To activate authorization, you must add the following section to this file:
```
security:
   authorization: enabled 
```
Save your changes and start the MongoDB server with the systemctl command for Linux or the Services applet for Windows.
Start the Mongo CLI utility using the mongo or mongosh command. Security is now active so it needs to be started as follows:
```
mongo --port 27017 -u "AdminUser" -p "Password1" --authenticationDatabase "admin" 
```
Create the database users for Talend Data Stewardship, Talend Data Preparation, and Talend Dictionary Service, and define the user names and passwords.
For example, here is the command to create the default users and passwords to entere in the mongo shell that you started in the previous step:
```
use dataprep
   db.createUser( { user: "dataprep-user", pwd: "duser",  roles: [ { role: "dbOwner", db: "dataprep" } ] } )
   use dqdict
   db.createUser( { user: "dqdict-user",   pwd: "duser", roles: [ { role: "dbOwner", db: "dqdict" }  ] } )
   use tds
   db.createUser( { user: "tds-user",      pwd: "duser",  roles: [ { role: "dbOwner", db: "tds" }  ] } )
   exit
```
For security reasons it is not recommended to use these default values. dqdict is the database for Talend Dictionary Service application. In the example above, all 3 users are created for each application. Only define the users for the applications you want to install.

What to do next

If you only want to install Talend Data Stewardship and Talend Data Preparation, you are ready to run the Talend Installer.

If you want to install Talend Dictionary Service, you must prepare its database before running the installer.

Preparing the database for Talend Dictionary Service

Procedure

Download the Talend-DictionaryService.zip archive file from your license email and unzip it into a temporary folder.
Open a terminal window and change the working folder to the dq_dict/database subfolder located in the extracted files.
Locate the file semantic-dictionary-import.bat.
Open this file with an editor and update the placeholders:
- %%%MONGO_HOST%%%: the host for MongoDB. For example, 127.0.0.1.
- %%%MONGO_PORT%%%: the port for MongoDB. For example, 27017.
- %%%MONGO_DBNAME%%%: the database name for MongoDB. For example, use dqdict for default settings.
- %%%MONGO_USER%%%: the username for the Talend Dictionary Service database. For example, use dqdict-user for default settings.
- %%%MONGO_PWD%%%: the password for the Talend Dictionary Service database. For example, use duser for default settings.
Optional: In that script, the mongorestore utility is called from PATH. It is recommended to specify the exact path to it.
Save your changes.
Run this file.

What to do next

You can now install Talend Dictionary Service with the installer.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here