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.
- 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.