Skip to main content Skip to complementary content

Synchronizing metadata connections and database structures

About this task

When the data in a source database is changed or updated, it is necessary that the relevant connection structure in Talend Studio follows that change or update as well. Otherwise, errors may occur when trying to analyze a column that has been modified/deleted in a database.

You can synchronize the connection structure displayed in the DQ Repository tree view with the database structures to eliminate any incoherence. You can perform synchronization at the following three different levels:

  • DB connection: to refresh the catalog and schema lists.
  • Tables: to refresh the list of tables.
  • Column: to refresh the list of columns.

Synchronizing and reloading catalog and schema lists

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

Before you begin

A database connection is created in the Profiling perspective.

Procedure

  1. In the DQ Repository tree view, expand Metadata > DB Connections.
  2. Right-click the database connection you want to synchronize with the database and select Reload database list.
    Contextual menu of a DB connection from the Profiling perspective.
    A message will prompt you for confirmation as any change in the database structure may affect the analyses created on these catalogs or schemas from Talend Studio.
  3. Click OK to close the confirmation message, or Cancel to stop the operation.

Results

The selected database connection is updated with the new catalogs and schemas, if any.

Synchronizing and reloading table lists

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

Before you begin

A database connection is created in the Profiling perspective.

Procedure

  1. In the DQ Repository tree view, expand Metadata > DB Connections.
  2. Browse through the entities in your database connection to reach the Table folder you want to synchronize with the database.
  3. Right-click the Tables folder and select Reload table list.
    Contextual menu of a table from the Profiling perspective.
    A message will prompt you for confirmation as any change in the database structure may affect the analyses created on these tables from the Talend Studio.
  4. Click OK to close the confirmation message, or Cancel to stop the operation.
    The selected table list is updated with the new tables in the database, if any.

Synchronizing and reloading column lists

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

Before you begin

A database connection is created in the Profiling perspective.

Procedure

  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.
    Contextual menu of a column from the Profiling perspective.
    A message will prompt you for confirmation as any change in the database structure may affect the analyses created on these columns from the Talend Studio.
  4. Click OK to close the confirmation message, or Cancel to stop the operation.

Results

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here