You can add a MySQL-compatible data source in DataV to integrate older MySQL database versions as data sources for widgets.
Prerequisites
The MySQL-compatible data source that you want to add is prepared.
Add the IP addresses of the corresponding region to your data source whitelist to ensure that DataV can access your database. For more information, see Configure a database whitelist.
Limits
This feature is supported only in DataV Enterprise Edition or higher.
Procedure
Access the DataV console.
-
On the Workbench page, click in the navigation pane on the left. On the Data Source page, click New Data Source.
-
From the Type dropdown, select MySQL-compatible Database.
-
Enter the database connection details.
Parameter
Description
Name
A custom name for the data source.
Domain Name
The connection address of 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 number of the database.
Username
The username used to log on to the database.
Password
The password used to log on to the database.
Database
The name of the currently selected database.
insecureAuth
Enables compatibility with older MySQL versions (below 5.2). Full compatibility is not guaranteed.
Compatible With Azure Database For Mysql
Enables compatibility with Azure Database for MySQL.
After you enter the database information, the system automatically tests the connection.
-
After the connection test succeeds, click OK to add the data source.
What to do next
To use the data source in your widgets, see Configure a widget data source.
FAQ
For more information, see FAQ about data source configuration and usage.