Creating a database content analysis - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

From the Profiling perspective of Talend Studio, you can create an analysis to examine the content of a given database.

Prerequisite(s): At least, one database connection is set in the Profiling perspective of the studio. For further information, see Connecting to a database.

To create a database content analysis, you must first define the relevant analysis and then select the database connection you want to analyze.

From the Statistical information view, you can:
  • Click a catalog or a schema to list all tables included in it along with a summary of their content: number of rows, keys and user-defined indexes.

    The selected catalog or schema is highlighted in blue. Catalogs or schemas highlighted in red indicate potential problems in data.

  • Right-click a catalog or a schema and select Overview analysis to analyze the content of the selected item.
  • Right-click a table or a view and select Table analysis to create a table analysis on the selected item. You can also view the keys and indexes of a selected table. For further information, see Displaying keys and indexes of database tables.
  • Click any column header in the analytical table to sort alphabetically the data listed in catalogs or schemas.