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.
_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:


_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: >