Connecting to MySQL

Note

This documentation is prior to May 2022.

MySQL is an open source database that stores and manipulates data. It provides comprehensive support for every application development need, and provides connectors and drivers (ODBC, JDBC, etc.) that allow all forms of applications to make use of MySQL as a preferred data management server.

Connecting to MySQL

There are three options to connect to MySQL:

• Create a new project
• Edit an existing project connection
• Export data from the Export >Run recipe button

Connecting to MySQL when Creating a New Project

1. Click Enrich. The Enrich page is displayed.
2. Click  in the upper-right hand corner. The Create a new project window is displayed.
   
3. Type in a new project name. The project name needs to be unique.
4. Select a use case from the drop-down.
5. Click Create project. The Upload a dataset window appears.
   
6. Select MySQL. The following screen is displayed for a new database connection creation:
   
7. All the fields are mandatory. Choose a connection name.
8. Type in the Host.
9. Type in the Port number.
10. Type in the Database name.
11. Type in the User name.
12. Type in the Password.
13. Type in the Temp Schema.
14. Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.

Connecting to MySQL when Editing a Dataset

1. Click Enrich. The Enrich page is displayed.
2. Create or search for a project.
3. Click .
   
4. The Change data and edit dataset window is displayed.
   
5. Click Continue.
6. Select MySQL. The following screen is displayed for a new database connection creation:
   
7. All the fields are mandatory. Choose a connection name.
8. Type in the Host.
9. Type in the Port number.
10. Type in the Database name.
11. Type in the User name.
12. Type in the Password.
13. Type in the Temp Schema.
14. Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.

Exporting Data

1. Click Enrich. The Enrich page is displayed.
2. Create, search or edit a project.
3. Click the Export >Run Recipe.
   
4. The Schedule Recipe Run window is displayed.
   
5. Select the input connection (optional).
6. Select the output connection.