Creating the database connection - 6.5

Talend Open Studio for Data Quality Getting Started Guide

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Open Studio for Data Quality
task
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
EnrichPlatform
Talend Studio
Before you proceed to analyze customer data, stored in the MySQL database in this example, you must first set up the connection to the database.

Procedure

  1. In the analysis editor, click the New Connection tab to open the [Create New Connection] wizard.
  2. From the Connection Type list, select DB connections and click Next.
  3. Click Finish to create the database connection, list it under the Metadata node and open a new step in the wizard.
  4. Expand the database connection, click on the table name and select the check boxes of the columns on which you want to create the analysis.
  5. Click OK to close the wizard and list the columns in the analysis editor.

    You can click Refresh Data to display the actual data in the analysis editor.