Updated at: 2022-12-09 03:49:50
Database Data Aggregation is for configuring database data synchronization. Database data is obtained through JDBC.
Note: Supportive for MySQL5.6, Oracle 11g, Shentong Database 7.0.
The specific operations are as follows:
1. Click Remote Aggregation > New to enter the Select Source page, and click Database to make configuration, as follows:
2. Click Next to make data Query, as follows:
Cron expression example:
• Execute once every 5 minutes: */5 * * * *
• Execute once every 2 days, from clock 8 to 11 in the 5th and 15th minutes: 5, 15 8-11 */2 * *
• Execute once every hour between 11pm and 7am: * 23-7/1 * * *
• Execute once on the 4th of each month and at 1: 30 am from Friday to Sunday: 30 1 4 * 5-7
• Execute once at 3 am on January 1st: 0 3 1 1 *
3. Click Next to Detect. After successful detection, click Next to Finish. The following steps can be performed herein:
• Click Start Search to jump to the Search to automatically search for the synchronized database information;
• Click View List to jump to the Remote Aggregation list to view the status of aggregation tasks, etc.;
• Click Add More Data to Select Source again and continue to add and configure new remote aggregation tasks.
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%B3%A8%E6%84%8F%20(1)_15.png)
The specific operations are as follows:
1. Click Remote Aggregation > New to enter the Select Source page, and click Database to make configuration, as follows:
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%95%B0%E6%8D%AE%E5%BA%93%E6%95%B0%E6%8D%AE%E9%87%87%E9%9B%86_E.png)
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%95%B0%E6%8D%AE%E5%BA%93%E6%95%B0%E6%8D%AE%E9%87%87%E9%9B%86_%E6%9F%A5%E8%AF%A2%E8%AE%BE%E7%BD%AE_E.png)
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%B3%A8%E6%84%8F%20(1)_15.png)
• Execute once every 5 minutes: */5 * * * *
• Execute once every 2 days, from clock 8 to 11 in the 5th and 15th minutes: 5, 15 8-11 */2 * *
• Execute once every hour between 11pm and 7am: * 23-7/1 * * *
• Execute once on the 4th of each month and at 1: 30 am from Friday to Sunday: 30 1 4 * 5-7
• Execute once at 3 am on January 1st: 0 3 1 1 *
3. Click Next to Detect. After successful detection, click Next to Finish. The following steps can be performed herein:
• Click Start Search to jump to the Search to automatically search for the synchronized database information;
• Click View List to jump to the Remote Aggregation list to view the status of aggregation tasks, etc.;
• Click Add More Data to Select Source again and continue to add and configure new remote aggregation tasks.
< Previous:
Next: >