Migrating from Talend Data Preparation 1.x/2.0 installed with an embedded MongoDB - 6.5

Talend MDM Platform Migration Guide

EnrichVersion
6.5
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

Before you begin

If you have installed and used Talend Dictionary Service to create custom semantic types or update the predefined ones, you must migrate Talend Dictionary Service before migrating Talend Data Preparation. See Migrating from Talend Dictionary Service versions 6.3.x or 6.4.x to 6.5.x.

You have downloaded Talend Data Preparation 2.3.

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

Procedure

  1. Install Talend Data Preparation 2.3 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.
  2. If you have installed Talend Data Preparation 2.3 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 dprep --port 27017
    2. Switch to Talend Data Preparation database: use dataprep
    3. Drop the database: db.runCommand( { dropDatabase: 1 } )
    4. Exit mongo shell: exit
  3. Start Talend Data Preparation 2.3.
  4. Stop Talend Data Preparation 2.3.
    These two steps are necessary for the migration process to work.
  5. If you have performed any custom configuration to the 1.x/2.0 version of the <Data_Preparation_Path>/config/application.properties file, update the 2.3 version of the file by coping the values from the old configuration file.
  6. To retrieve the content of the dataset storage folder used for Talend Data Preparation 1.X/2.0, and migrate it to version 2.3, 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.0, and paste it in the 2.3 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.3 version.
  7. Start the MongoDB instance of Talend Data Preparation 1.x/2.0.
  8. Back up the MongoDB instance used for Talend Data Preparation 1.x/2.0 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 dprep
  9. Stop MongoDB of Talend Data Preparation 1.x/2.0 and start MongoDB of the 2.3. version.
  10. Drop the database of the Talend Data Preparation 2.3 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 dprep --port 27017
    2. Switch to Talend Data Preparation database: use dataprep
    3. Drop the database: db.runCommand( { dropDatabase: 1 } )
    4. Exit mongo shell: exit
  11. Restore the backup performed on the 1.x/2.0 MongoDB, on the 2.3 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>
  12. Start Talend Data Preparation 2.3.

Results

You are now ready to use Talend Data Preparation 2.3.