Migrating from Talend Data Preparation 1.X/2.0 installed with an external MongoDB - 6.4

Talend Data Management Platform Migration Guide

EnrichVersion
6.4
EnrichProdName
Talend Data Management 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 Installer
Talend JobServer
Talend Log Server
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

Warning

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 version 6.3.x to 6.4.x.

Before you begin:

  • You have downloaded Talend Data Preparation 2.1.

  1. Stop your instance of Talend Data Preparation 1.X/2.0 but not MongoDB.

  2. Back up the MongoDB instance used for Talend Data Preparation 1.X/2.0.

    To backup your MongoDB, open a command prompt window and execute 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>

  3. Stop your 1.X/2.0 MongoDB instance.

  4. Install MongoDB 3.4.2 and start it.

    Talend Data Preparation 2.1 uses the 3.4.2 version of MongoDB.

  5. Install Talend Data Preparation 2.1 with the external MongoDB, and configure it with the same settings as your 1.X/2.0 instance.

    For more information about the Talend Data Preparation installation and configuration procedures, see the Talend Installation Guide.

  6. If you have performed any custom configuration to the 1.X/2.0 version of the <Data_Preparation_Path>/config/application.properties file, you can port them to the 2.1 version of the file.

  7. To retrieve the content of the dataset storage folder used for Talend Data Preparation 1.X/2.0, and migrate it to version 2.1, 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.1 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.1 version.

  8. Start Talend Data Preparation 2.1.

  9. Stop Talend Data Preparation 2.1.

    These two steps are necessary for the migration process to work.

  10. Start the version 3.4.2 instance of MongoDB.

  11. Drop the database of the Talend Data Preparation 2.1 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

  12. Restore MongoDB, open a command prompt window and execute 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>

  13. Start Talend Data Preparation 2.1.

You are now ready to use Talend Data Preparation 2.1.