DataV:Create a data dashboard using a blank canvas

On the ApsaraDB RDS MySQL side

1. Create an RDS MySQL instance.

   In this example, the instance is in the China (Hangzhou) region and uses the platform-generated VPC and vSwitch.

2. Create a database account and database, then prepare example data.

   This example uses:

   • Database account: user_test.

   • Database name: mysqltest.

   • Example data: Create a Bill table in the mysqltest database 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.

   Add the DataV-Board IP address for your region to the RDS MySQL instance whitelist so DataV-Board can access the database.

   The sample database is in the China (Hangzhou) region using VPC, so add 100.104.70.0/24 to the whitelist.

You can adjust instance and database settings to match your business requirements.

On the DataV-Board 7.0 side

1. Activate the DataV-Board service.

2. Create an RDS MySQL data source.

   Configure the data source with these key parameters:

   Parameter	Description
   Type	Select RDS MySQL. For network type, select Internal of China (hangzhou).
   Name	Enter a custom name. This example uses mysql_data.
   VPC ID and Vpc-connected Instance ID	VPC ID: The VPC ID bound to the RDS MySQL instance. VPC-connected instance ID: The RDS MySQL instance ID. Find these values in the RDS instance list.
   Domain Name and Port	Domain name: The VPC internal address of the RDS MySQL instance. Port: The VPC internal port of the RDS MySQL instance. Find these values in the RDS instance list. Click the instance name to view the details as shown below.
   Username and Password	The database login account and password. This example uses user_test.
   Database	Click Obtain Data List and select the database. This example uses mysqltest.