Migrating to Talend Data Preparation 7.2.x with an embedded MongoDB

Migrating to Talend Data Preparation 7.2.x with an embedded MongoDB - 7.2

Talend Data Integration Migration and Upgrade Guide

Version

7.2

Language

English (United States)

EnrichDitaval

Data Integration

Product

Talend Data Integration

Module

Talend Activity Monitoring Console

Talend Administration Center

Talend Artifact Repository

Talend CommandLine

Talend Data Preparation

Talend Data Stewardship

Talend Identity and Access Management

Talend JobServer

Talend Log Server

Talend Runtime

Talend Studio

Content

Installation and Upgrade

Before you begin

Procedure

Stop your current Talend Data Preparation instance but keep the MongoDB instance running.

Back up your MongoDB by running the following command.

For Linux:

<mongo_path>/bin
./mongodump -h <source_mongodb_host>:<source_mongo_port> -d <source_database> -u <source_mongodb_user> -p <source_mongodb_password> -o <dump_output>

For Windows:

<mongo_path>\bin>mongodump -h <source_mongodb_host>:<source_mongo_port> -d <source_database> -u <source_mongodb_user> -p <source_mongodb_password> -o <dump_output>

The default value for the embedded MongoDB properties are the following:

Property	Value
`mongodb.host`	`localhost`
`mongodb.port`	`27017`
`mongodb.database`	`tdp`
`mongodb.user`	`tdp-user`
`mongodb.password`	`duser`

Stop the MongoDB instance from the previous version of Talend Data Preparation.

Note: For Windows users, you must uninstall the current MongoDB before you install Talend Data Preparation.
Install Talend Data Preparation and select the embedded MongoDB option. Do not start the instance.
If you have installed Talend Data Preparation in service mode, stop the instance and MongoDB.
Delete the database:
1. Open a mongo shell as a Talend Data Preparation database user and execute the following commands.
  For Linux:
```
cd <install_dir>/mongodb/bin
./mongo dataprep -u dataprep-user -p dprep --port 27017
```
  For Windows:
```
<install_dir>\mongodb\bin>mongo dataprep -u dataprep-user -p dprep --port 27017
```
2. Switch to the Talend Data Preparation database: use dataprep
3. Drop the database: db.runCommand( { dropDatabase: 1 } )
4. Exit mongo shell: exit

Restore the MongoDB backup on the new 7.2 MongoDB instance by using the following command.

For Linux:

<mongo_path>/bin
./mongorestore -h <mongo_host>:<mongo_port> -u <mongo_tdp_username> -p <mongo_tdp_password> -d <mongo_tdp_database> <backup_location>

For Windows:

<mongo_path>\bin>mongorestore -h <mongo_host>:<mongo_port> -u <mongo_tdp_username> -p <mongo_tdp_password> -d <mongo_tdp_database> <backup_location>

If you customized the <Data_Preparation_Path>/config/application.properties file in the previous version, you can copy the values from the old configuration file and add them to the new version.
To retrieve the content of the data-set storage folder used for the previous Talend Data Preparation and migrate it to version 7.2, complete the next step according to the your situation:
- If you have set a custom value for the dataset.content.store.file.location property, make sure that you set the same value in the application.properties file for the 7.2 version.
- If you have never modified the value of the dataset.content.store.file.location property, copy the content of the <Data_Preparation_Path>/data folder used in 1.x/2.x, and paste it in the 7.3 installation folder, following the same path.
Start Talend Data Preparation.

Results

You are now ready to use Talend Data Preparation.