Creating a database content analysis - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
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.