Selecting the database connection you want to analyze - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
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
Last publication date
2024-02-27
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

Procedure

  1. Expand DB Connections and select a database connection to analyze, if more than one exists.
  2. Click Next.
  3. Set filters on the tables and views you want to analyze in their corresponding fields using the SQL language.
    Example of values in the Table name filter and View name filter fields.
    By default, the analysis examines all tables and views in the database.
  4. Click Finish to close the Create New Analysis wizard.
    A folder for the newly created analysis is listed under the Analyses folder in the DQ Repository tree view, and the connection editor opens with the defined metadata.
    Overview of the Analysis Metadata section containing the defined metadata.
    Note: The display of the connection editor depends on the parameters you set in the Preferences window. For more information, see Setting preferences of analysis editors and analysis results.
  5. Click Analysis Parameters and do the following:
    1. In the Number of connections per analysis field, set the number of concurrent connections allowed per analysis to the selected database connection.
      You can set this number according to the database available resources, that is the number of concurrent connections each database can support.
    2. Verify and modify filters on table and views, if any.
      You can use context values.
    3. If you want to reload all databases in your connection on the server when running the overview analysis, select the Reload databases check box .
      When you try to reload a database, a message will prompt you for confirmation as any change in the database structure may affect existing analyses.
  6. In the Context Settings view, select from the list the context environment you want to use to run the analysis.
    The table in this view lists all context environments and their values you define in the Context view in the analysis editor. For further information, see Using context variables in analyses.
  7. Press F6 to execute the analysis.
    A message opens at the bottom of the editor to confirm that the operation is in progress and analysis results are opened in the Analysis Results view.