Migrating a group of connections - 6.5

Talend Open Studio for Data Quality User Guide

Talend Open Studio for Data Quality
Data Quality and Preparation
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 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.

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.