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

  1. Log on to the DataV console.
  2. Click the Data Sources tab and then Add Data Source.
  3. Select MySQL Compatible Database from the Type drop-down list.
  4. Enter database information.
    Add Data Source
    ParameterDescription
    NameThe name of the data source. Enter a custom name.
    DomainThe 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 NameThe username that is used to connect to the database.
    PasswordThe password that is used to connect to the database.
    Port NumberThe port that is used to connect to the database.
    DatabaseThe name of the database. Select the desired database.
    insecureAuthIf 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 MySQLIf 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. Add a Data Lake Analytics database
  5. After the database passes the connectivity test, click OK.