Migrating from Talend Data Preparation 1.x/2.x installed with an embedded MongoDB

Migrating from Talend Data Preparation 1.x/2.x installed with an embedded MongoDB - 7.1

Talend ESB Migration and Upgrade Guide

EnrichVersion

7.1

EnrichProdName

Talend ESB

EnrichPlatform

Talend Activity Monitoring Console

Talend Administration Center

Talend Artifact Repository

Talend CommandLine

Talend Data Preparation

Talend Data Stewardship

Talend ESB

Talend Identity and Access Management

Talend Log Server

Talend Runtime

Talend Studio

task

Installation and Upgrade

Before you begin

You have downloaded Talend Data Preparation 2.8.

You have stopped Talend Data Preparation 1.x/2.x.

Procedure

Install Talend Data Preparation 2.8 with the embedded MongoDB, and do not start the instance.
For more information about the Talend Data Preparation installation and configuration procedures, see Installing and configuring Talend Data Preparation.
If you have installed Talend Data Preparation 2.8 in service mode, stop the instance and MongoDB and delete the database:
1. Open a mongo shell as Talend Data Preparation database user and execute the following commands:
```
cd <install_dir>/mongodb/bin
./mongo dataprep -u dataprep-user -p duser --port 27017
```
2. Switch to Talend Data Preparation database: use dataprep
3. Drop the database: db.runCommand( { dropDatabase: 1 } )
4. Exit mongo shell: exit
Start Talend Data Preparation 2.8.
Stop Talend Data Preparation 2.8.
These two steps are necessary for the migration process to work.
If you have performed any custom configuration to the 1.x/2.x version of the <Data_Preparation_Path>/config/application.properties file, update the 2.8 version of the file by coping the values from the old configuration file.
To retrieve the content of the dataset storage folder used for Talend Data Preparation 1.x/2.x, and migrate it to version 2.8, complete the next step according to the your situation:
- If you have never modified the value of the dataset.content.store.file.location property, copy the content of the <Data_Preparation_Path>/data/store/datasets/content folder used in 1.x/2.x, and paste it in the 2.8 installation folder, following the same path.
- 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 2.8 version.
Start the MongoDB instance of Talend Data Preparation 1.x/2.x.

Back up the MongoDB instance used for Talend Data Preparation 1.x/2.x using the following command:

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`	`dataprep`
`mongodb.user`	`dataprep-user`
`mongodb.password`	`duser`

Stop MongoDB of Talend Data Preparation 1.x/2.x and start MongoDB of the 2.8 version.
Drop the database of the Talend Data Preparation 2.8 MongoDB:
1. Open a mongo shell as Talend Data Preparation database user and execute the following commands:
```
cd <install_dir>/mongodb/bin
./mongo dataprep -u dataprep-user -p duser --port 27017
```
2. Switch to Talend Data Preparation database: use dataprep
3. Drop the database: db.runCommand( { dropDatabase: 1 } )
4. Exit mongo shell: exit
Restore the backup performed on the 1.x/2.x MongoDB, on the 2.8 MongoDB instance using the following command: mongo_path>/bin/mongorestore -h <mongo_host>:<mongo_port> -u <mongo_tdp_username> -p <mongo_tdp_password> -d <mongo_tdp_database> <backup_location>
Start Talend Data Preparation 2.8.

Results

You are now ready to use Talend Data Preparation 2.8.