DataV:Create a data dashboard using a blank canvas

On the ApsaraDB RDS MySQL side

1. Create an RDS MySQL instance.

   For this example, an instance is created in the China (Hangzhou) region, utilizing the VPC and switch automatically generated by the platform.

2. Create the necessary database account and database, and prepare example data within the instance.

   The example establishes the following:

   • Database account: user_test.

   • Database name: mysqltest.

   • Example data: In the mysqltest database, create a bill table named Bill and populate it with 100 simulated entries dated between January 1, 2023 and January 10, 2023.

     The SQL statement is as follows.

     CREATE TABLE IF NOT EXISTS Bill (
         `id` INT AUTO_INCREMENT PRIMARY KEY,
         `bill_date` DATE NOT NULL COMMENT 'Bill date',
         `amount` DECIMAL(10, 2) NOT NULL COMMENT 'Amount'
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Bill information table';
     
     DELIMITER ;;
     CREATE PROCEDURE GenerateBillData()
     BEGIN
         DECLARE v_counter INT DEFAULT 1;
         DECLARE v_random_date DATE;
         DECLARE v_random_amount DECIMAL(10, 2);
         
         WHILE v_counter <= 100 DO
             SET v_random_date = DATE_ADD('2023-01-01', INTERVAL FLOOR(RAND() * 10) DAY);
             SET v_random_amount = ROUND(RAND() * 1000, 2);
             
             INSERT INTO Bill (bill_date, amount)
             VALUES (v_random_date, v_random_amount);
             
             SET v_counter = v_counter + 1;
         END WHILE;
     END;;
     DELIMITER ;
     
     -- Call the stored procedure to generate data
     CALL GenerateBillData();

3. Configure a whitelist.

   To ensure normal access to the RDS MySQL instance when creating a data source in DataV-Board 7.0, add the whitelist IP address of the region where the RDS MySQL database is located to the instance whitelist.

   The sample database is deployed in the China (Hangzhou) region and utilizes the internal virtual private cloud (VPC) network. Therefore, the whitelist that needs to be added is 100.104.70.0/24.

You may also configure instance and database information according to your business requirements.

On the DataV-Board 7.0 side

1. Activate the DataV-Board service.

2. Create an RDS MySQL data source.

   The core parameter configuration of the data source is as follows.

   Parameter	Description
   Type	Select RDS MySQL. For the network type, select Internal of China (hangzhou) (that is, the Hangzhou region).
   Name	Specify a custom data source name. The example in this topic is mysql_data.
   VPC ID and Vpc-connected Instance ID	VPC ID: The ID of the virtual private cloud (VPC) to which the RDS MySQL instance is bound. VPC-connected instance ID: The ID of the RDS MySQL instance. You can view it in the RDS instance list.
   Domain Name and Port	Domain name: The internal network address of the virtual private cloud (VPC) to which the RDS MySQL instance is bound. Port: The internal network port of the virtual private cloud (VPC) to which the RDS MySQL instance is bound. You can view it in the RDS instance list. Click the name of the destination instance to go to the product page and view it according to the steps shown in the following figure.
   Username and Password	The database logon account and password. The database account in this example is user_test, and the password is the database password you specify.
   Database	Click Obtain Data List and select the created database from the drop-down list. The example in this topic is mysqltest.