This topic describes how to add a MySQL-compatible data source in DataV. After you add such a data source, you can use a MySQL database of a version earlier than MySQL 5.2 as a data source of the widgets in your DataV project.
Prerequisites
The MySQL-compatible database data source to be added is prepared.Procedure
- Log on to the DataV console.
- Click the Data Sources tab and then Add Data Source.
- Select MySQL Compatible Database from the Type drop-down list.
- Enter database information.
Parameter Description Name The name of the data source. Enter a custom name. Domain The domain name or IP address that is used to connect to the database. Important The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud. If you need to access a Data Lake Analytics database over the Internet, an example of the domain name is umxxxxxxxx-31xxxxxx.cn-hangzhou.datalakeanalytics.aliyuncs.com.User Name The username that is used to connect to the database. Password The password that is used to connect to the database. Port Number The port that is used to connect to the database. Database The name of the database. Select the desired database. insecureAuth If you enable this feature, MySQL databases of versions earlier than MySQL 5.2 are supported, but not all these databases are fully compatible. Compatible with Azure Database for MySQL If you enable this feature, you can use a Microsoft Azure Database for MySQL database as the data source. After you enter the database information, DataV automatically tests whether the database can be connected.
The following figure shows the information of a Data Lake Analytics database. - After the database passes the connectivity test, click OK.