Creating a database content analysis - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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

Before you begin, you have defined at least one database connection in the Profiling perspective of Talend Studio.

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.
  • Click any column header in the analytical table to sort alphabetically the data listed in catalogs or schemas.