Data Update Overview

Application Scenario

Only datasets with the extraction attribute need to be updated. Datasets with the direct connection attribute do not need to be updated.

Function Description

• Single Table Update, Folder Update, and Global Update are supported.

• You can perform update immediately or set a scheduled update task.

• During data update in FineBI, a temporary folder is generated. After the update is successful, the original folder is replaced. If any table fails to be updated, an error message will be displayed in the prompt box, and the generated temporary folder will be discarded without affecting the original data.

• When data update through any method is in progress, data update through other methods is added to the waiting queue. Data tables added to the queue will be updated later according to the queue priority. If a data table added to the waiting queue for update is modified again, the modification will not be included in this update and can be included in the next update after this update is completed.

• To avoid scheduled update of numerous single tables that takes a long time, use Global Update (for which you can set the execution frequency to once a day) as much as possible.

• During update, update tasks with similar time can be merged for execution at the same time to reduce repeated updates of self-service datasets.

• The longer the time interval between adjacent data updates, the better.

• Hidden datasets set to be not extracted are usually those used in intermediate steps.

•  If the preview is slow after a SQL dataset is added, you need to optimize SQL statements. Otherwise, the update may get stuck.

Kaspersky antivirus software cannot be installed in the environment where FineBI is deployed. If Kaspersky-similar antivirus scanning software runs in the background, data table update may fail due to file occupation caused by background scanning.