Migrating a group of connections

Talend Data Management Platform Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Management Platform
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

You can import database connections from various projects or various versions of the Studio.

Some of the migrated JDBC connections may have a warning icon docked on their names in the DB connections folder in the DQ Repository tree view. This indicates that the driver path for these connections is empty after migration.

Setting the driver path manually for each of the connections could be tedious especially if you have imported big number. The Profiling perspective of the studio enables you to set the driver path once for all. You may download such a driver from the Microsoft download center, for example.

Prerequisite(s): You have already migrated your database connections from an older version of the studio as outlined in Importing data profiling items or projects.

To migrate a group of connections simultaneously, do the following:

  1. In the menu bar, select Window > Preferences to display the [Preferences] window.

  2. In the search field, type jdbc and then select JDBC Driver Setting to open the corresponding view.

  3. Set the JDBC parameters in the corresponding fields, and then click Apply to connections....

    A dialog box is displayed to list all the JDBC connections that do not have the required JDBC driver after migration.

  4. Select the check boxes of the connections for which you want to apply the driver settings and then click OK.

    A confirmation message is displayed.

  5. Click OK to close the confirmation message.

  6. In the [Preferences] window, click OK.

    A confirmation message is displayed.

  7. Click OK to close the message and the [Preferences] window.