Migrating from Talend Dictionary Service 6.x installed with an embedded MongoDB

Migrating from Talend Dictionary Service 6.x installed with an embedded MongoDB - 7.0

Talend Real-Time Big Data Platform Migration and Upgrade Guide

EnrichVersion

7.0

EnrichProdName

Talend Real-Time Big Data Platform

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 Repository Manager

Talend Runtime

Talend SAP RFC Server

Talend Studio

task

Installation and Upgrade

Before you begin

You have downloaded Talend Dictionary Service 7.0.x.

Procedure

Stop your instance of Talend Dictionary Service 6.x but keep MongoDB running.

Back up the MongoDB instance used for Talend Dictionary Service 6.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`	`dqdict`
`mongodb.user`	`dqdict-user`
`mongodb.password`	`duser`

Example

mongodump -h localhost:27017 -d dqdict -u dqdict-user -p duser -o dump\

Stop your MongoDB instance.
Install Talend Dictionary Service 7.0.x with the embedded MongoDB, and do not start the instance.
For more information about the Talend Dictionary Service installation and configuration procedures, see Installing and configuring Talend Dictionary Service.
If you have installed Talend Dictionary Service 7.0.x in service mode, stop the instance, delete the database and stop MongoDB:
1. Open a mongo shell as Talend Dictionary Service database user and execute the following commands:
```
cd <install_dir>/mongodb/bin
./mongo dqdict -u dqdict-user -p duser --port 27017
```
2. Switch to Talend Dictionary Service database: use dqdict
3. Drop the database: db.runCommand( { dropDatabase: 1 } )
4. Exit mongo shell: exit
5. Stop MongoDB.
If you have performed any custom configuration to the 6.x version of the <Tomcat>/conf/data-quality.properties file, update the 7.0.x version of the file by coping the values from the old configuration file.
Start MongoDB of the 7.0.x version.
Restore the backup performed on the 6.x MongoDB, on the 7.0.x MongoDB instance using the following command: mongorestore -h <source_mongodb_host>:<source_mongo_port> -d <source_database> -u <source_mongodb_user> -p <source_mongodb_password> dump\
Example
```
mongorestore -h localhost:27017 -d dqdict -u dqdict-user -p duser dump\
```
Start Talend Dictionary Service 7.0.x. by launching, in order:
- Apache Zookeeper
- Apache Kafka
- Apache Tomcat (Talend Administration Center server and Talend Identity and Access Management server)
- MongoDB

Optional: Go to the <pathToTheInstallationFolder>/dq_dict/database/functionalMigration folder and execute the migration script corresponding to your system and the previous version of Talend Dictionary Service:

Previous Talend Dictionary Service version	Operating System	Script
6.3.x	Windows	functionalMigrationFrom63.bat
6.3.x	Linux	functionalMigrationFrom63.sh
6.4.x	Windows	functionalMigrationFrom64.bat
6.4.x	Linux	functionalMigrationFrom64.sh

There are no migration scripts for 6.5.x.

The scripts functionalMigrationFrom63.bat and functionalMigrationFrom63.sh perform the following actions:

Create the PHONE compound semantic type, which groups FR_PHONE, US_PHONE, UK_PHONE and DE_PHONE semantic types
Create the NA_STATE compound semantic type, which groups US_STATE and CA_PROVINCE_TERRITORY semantic types
Create the NA_STATE_CODE compound semantic type, which groups the US_STATE_CODE and CA_PROVINCE_TERRITORY_CODE semantic types
Update the UK_PHONE semantic type

The scripts functionalMigrationFrom64.bat and functionalMigrationFrom64.sh update the UK_PHONE semantic type.

When prompted, enter the login name and the password of a Talend Administration Center user:
- This Talend Administration Center user type must be Data Quality.
- This Talend Administration Center user must be a Talend Data Preparation user or a Talend Data Stewardship user.

Results

You are now ready to use Talend Dictionary Service 7.0.x.