Connecting to MySQL

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 'Create project' 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.