Quick BI:Add a user-created MySQL data source

Limits

Supports MySQL versions 5.5, 5.6, 5.7, and 8.0.

Step 1: Enable the Firewall

Ensure the firewall is enabled before attempting to connect to a MySQL database over the Internet.

1. Open the firewall configuration file with the following command:

   vi /etc/sysconfig/iptables

2. Insert the following command into the configuration file:

   -A RH-Firewall-1-INPUT -m state -state NEW -m tcp -p tcp -dport 3306 -j ACCEPT

3. Restart Iptables with the following command after successful configuration:

   service iptables restart

Step 2: Add a User-created MySQL Data Source

1. Log on to the Quick BI console.

2. Follow the steps illustrated below to add a data source:

   1. Navigate to the data source creation page via the data source creation entry.

   2. Select the MySQL data source option.

      

   3. Choose the user-created data source type.

3. In the Add MySQL Data Source dialog box, configure the following settings according to your business needs:

   Name	Description
   Display Name	The display name in the data source configuration list. The name cannot contain special characters or start or end with spaces.
   Database Address	The address of the MySQL database, including the IP address or domain name.
   Port	The port number corresponding to the database address.
   Database	The name of the database that is customized when you deploy the database.
   Username and Password	The username and password that are used to access the MySQL database.
   VPC Data Source	If the MySQL database is deployed on an ECS instance and uses the Alibaba Cloud VPC network, select VPC Data Source and configure the following parameters: Purchaser Accessid and Purchaser Accesskey: The AccessKey ID and AccessKey Secret of the purchaser of the instance. For more information, see Obtain an AccessKey. Note Ensure that the account has Read permissions on the destination instance. If the account has Write permissions, the system automatically adds the whitelist. Otherwise, you must manually add it. For more information, see Create a custom policy. Instance ID: The instance ID of the ECS instance. Log on to the ECS console and obtain the instance ID on the Instances tab. For more information, see View instance information. Region: The region where the ECS instance resides. Log on to the ECS console and obtain the region in the upper-left corner of the page. For more information, see View instance information.
   SSL	If the destination data source is configured with SSL, you can select the security protocol SSL to protect data security.
   SSH	If you select SSH, you must configure the following parameters: You can deploy a jump server and access the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators. SSH Host: Enter the IP address of the jump server. SSH Username and SSH Password: The username and password that are used to log on to the jump server. SSH Port: The port of the jump server. Default value: 22. For more information, see Log on to a Linux instance by using password authentication.
   Init SQL	After this feature is enabled, you can configure SQL statements that are executed to initialize the data source connection. Only SET statements are allowed. Use semicolons to separate multiple statements.
   Enable file upload entry	After this feature is enabled, file uploads are supported.

• Click Connection Test to verify the data source connectivity.

  

• Once the test is successful, click OK to finalize the data source addition.