How to synchronize and reload column lists - 6.5

Talend Open Studio for Data Quality User Guide

Talend Open Studio for Data Quality
Data Quality and Preparation
Talend Studio

You can compare and match the column lists in the DQ Repository tree view with those in the database.

Prerequisite(s): A database connection has been created in the Profiling perspective of the studio.

To synchronize and reload a column list, do the following:

  1. In the DQ Repository tree view, expand Metadata > DB Connections.

  2. Browse through the entities in your database connection to reach the Columns folder you want to synchronize with the database.

  3. Right-click the Columns folder and select Reload column list.

    A message will prompt you for confirmation as any change in the database structure may affect the analyses created on these columns from the Studio.

  4. Click OK to close the confirmation message, or Cancel to stop the operation.

    The selected column list is updated with the new column in the database, if any.