Dataiku

Prerequisites

• Dataiku is installed.

• The MySQL driver file is downloaded.

• The IP address of the Dataiku server has been added to the IP address whitelist of your AnalyticDB for MySQL cluster.

Procedure

1. Open the Dataiku client and create a project.

   • If you are a first-time user, in the Projects section, click Create your first project.

   • If you already have projects, in the Projects section, click +NEW PROJECT in the upper-right corner.

2. Open the project and click +IMPORT YOUR FIRST DATASET.

3. On the data source page, select MySQL and click create a new connection.

4. At the top of the page, click +NEW CONNECTION and select MySQL from the drop-down list.

5. On the New MySQL connection page, configure the following parameters:

   Parameter	Description
   New connection name	A custom name for the connection.
   Host	The endpoint of the AnalyticDB for MySQL cluster. If Dataiku is installed on an ECS instance and the instance is in the same ECS as the AnalyticDB for MySQL cluster, enter the VPC endpoint. If Dataiku is installed on an on-premises server, enter the public endpoint.
   Database	The name of the database in the AnalyticDB for MySQL cluster.
   Port	The port number of the AnalyticDB for MySQL cluster. The value is fixed at 3306.
   User	The database account for the AnalyticDB for MySQL cluster.
   Password	The password for the AnalyticDB for MySQL database account.
   Driver jars directory	The path to the directory that contains the MySQL driver file.
   Other parameters	For details about other parameters, see the official Dataiku documentation.

6. After configuring the parameters, click TEST. If the test succeeds and a Connection OK message appears, click CREATE.

7. Analyze data.

   After you complete the configuration, click Import tables to datasets at the bottom of the page to batch-import table schemas. You can then analyze the data. For more information on data analysis, see the official Dataiku documentation.

   On the New MySQL dataset page, select the Preview tab to view the table data. The Connection and query OK message at the bottom of the page confirms that the connection and query were successful. After confirming the preview, click CREATE in the upper-right corner to create the dataset.