This document outlines the steps to add a MySQL-compatible data source in DataV and provides guidance on configuring the necessary parameters. Utilizing a MySQL-compatible data source allows for the integration of older MySQL database versions with DataV widgets.
Prerequisites
Ensure that the MySQL-compatible data source you want to add is prepared.
You must first add the whitelist IP address of the corresponding area to your data source whitelist to ensure that DataV-Board can access your database normally. For more information, see configure database whitelist.
Limits
All versions are supported.
Procedure
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
-
From the Type dropdown, select MySQL-compatible Database.
-
Input the database details.
Parameter
Description
Name
The name of the data source. You can specify a custom name.
Domain Name
The address to connect to the database.
ImportantThis address must be a domain name or IP address that the DataV server can access through the public network or the internal network in some Alibaba Cloud regions.
Port
The port set for the database.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
insecureAuth
When enabled, it can be compatible with older versions of the MySQL database (below version 5.2, not guaranteed to be fully compatible).
Compatible With Azure Database For Mysql
When enabled, it can be compatible with Microsoft's MySQL database.
Upon entering the database information, the system will automatically test the connection to ensure it can be established successfully.
-
Once the connection is verified, click OK to finalize the data source addition.
What to do next
Once you have the raw data, you can consult datasource config for widget data adaptation.
FAQ
For additional questions, consult the FAQ about datasource config.