Timing Extraction of  LogDB Database

1. Problem Description

This is because FineReport 10.0 adopts FanRuan's newly developed swift engine to better record and analyze the performance of the LogDB database, but at present, the swift engine does not fully support other databases. So faced with this situation：

• The LogDB database of FineReport 10.0 cannot be directly migrated.

• Directly connect to the built-in LogDB database for enhanced analysis, there are restrictions on SQL statements, and some SQL writing methods are not supported.

2. Solution

Users can achieve the same effect as LogDB database migration through the scheduled data entry task of Task Schedule.

1. Get LogDB database data

ClickServer>Define Data Connection，Add aJDBC Data Connection ，The setting information is shown in the table below：

Designer setting page as shown follow：

2. Create a local database

1) New table structure

Compare the table structure of the LogDB database and create a corresponding table structure in your own database. For the table structure, youi can refer：LogDB Table structure

This article only exemplifies the establishment of the fine_record_execute table under the local MySQL database, as shown follow：

2) Data connection to local database

Establish a data connection in the designer to connect to the migration database, as shown follow：

3. Create a template

1) Template Design

Query the fine_record_execute table data in the built-in LogDB database, and create a new report as shown below：

2) Adjust the display value of table field

Users can adjust the display value of each field according to their own needs. Only the time field is adjusted below.

As shown follow, the time field does not hold a standard date format.

Set the time field condition attribute to a new value, the value is TODATE($$$), the condition is 1==1, and it is guaranteed to be executed forever, as shown follow：

3) Set Data Entry Attribute

ClickTemplate>Data Entry Attribute，addBuilt-in SQL，Bind the cells to the fields of the migration database as shown follow：

4. Add Task Schedule

Click Server>Platform Management，login Decision-making Platform with admin account，click Manage>Task Schedule，add LogDB scheduled extraction tasks：

Select the data entry template we just made, and select Data Entry as the type, as shown follow：

Frequency is defined according to user needs, as shown follow：

Timing extraction of LogDB database is completed.