# Creating the database connection

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.

## Before you begin

* You have opened the Profiling perspective in Talend Studio.
* You have created a column analysis and opened the analysis editor. For further information, see [Defining a column analysis](https://help.qlik.com/talend/en-US/studio-getting-started-guide-big-data-platform/8.0/defining-column-analysis "You want to create a column analysis from the Profiling perspective of Talend Studio to examine the Email and Phone columns in a MySQL databases and collect statistics on them. The analysis runs on several columns but each column is analyzed separately and independently.").
* You have imported the gettingstarted.sql file which holds the customer data into a MySQL database to which you have access. For more information, see [Setting up input customer data for the service](https://help.qlik.com/talend/en-US/studio-getting-started-guide-big-data-platform/8.0/setting-up-input-customer-data-for-service).

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

   ![](https://help.qlik.com/talend/en-US/studio-getting-started-guide-big-data-platform/Resources/images/gs-dq-select_db_columns.png)
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.

   ![](https://help.qlik.com/talend/en-US/studio-getting-started-guide-big-data-platform/Resources/images/gs-dq-create_analysis2.png)