Overview
Application Scenario
FineDataLink supports connection to the MySQL server for data reading/writing using scheduled tasks and pipeline tasks and for releasing data services.
Preparation
Version and Driver
Download the driver package and upload it to FineDataLink. For the specific steps of uploading the driver package, see Driver Management.
Supported Database Version | Driver Package Download |
---|---|
V8.0, V5.6.31, V5.5, V5.5.5, V5.6.35, V5.7, V5.6.37, V5.5.46, V6.5, V5.7.16 , V5.6.29, V5.6.22, V5.6.34, V5.6.28, and V5.1 Note: You are advised to use a driver of the corresponding version for MySQL 8.0. | (Built-in) No need to download. |
Recommendation: If you use MySQL 5.5, 5.6, or 5.7, you are advised to replace the database driver with MySQL Connector/J 5.1.37 for better data retrieval performance. (MySQL Connector/J 5.1.37 does not support MySQL 5.1 and MySQL 8.0.) | |
If you use the database of other versions, you can download the corresponding driver package on the MySQL official website. |
Connection Information Collection
Collect the following information before connecting FineDataLink to the database.
IP address and port number of the database server
Database name
Username and password of the database
Procedure
1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.
Note: If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission.
2. Click the MySQL icon.
3. Set Driver to Default (or Custom and select the driver you uploaded), and fill in the connection information.
Notes
If incorrect dates occur, you can add a suffix to the value of Data Connection URL in the following format.
jdbc:mysql://IP address:Port number/Database name?
generateSimpleParameterMetadata=true&useSSL=false&serverTimezone=America/New_York
The suffix serverTimezone=America/New_York means to use the New York time zone.
If MySQL 8.0 and the TINYINT(1) field are used, add the suffix tinyInt1isBit=false to the value of the URL. Otherwise, the TINYINT field in the MySQL database will be identified as the BIT field.
4. Click Test Connection. If the connection is successful, click Save to save the configuration, as shown in the following figure.
Data Source Usage
After configuring the data source, you can use it in Data Development. For details, see Overview of Data Development.
Add the suffix &autoReconnect=true&failOverReadOnly=false to the URL of the MySQL data connection to enable automatic reconnection, avoiding scheduled task failure caused by data connection interruption.
After configuring the data source, you can use it in Data Pipeline. For details, see Overview of Data Pipeline.
After configuring the data source, you can use it in Data Service. For details, see Overview of Data Service.