• data files from an external database (Oracle, SQL Server, etc.).
• data files whose data was not converted to the HFSQL Classic format.

• force the synchronization from the data model editor.
• program an automatic check for the changes made to the external database when opening the analysis.

Forcing the synchronization

1. Open the analysis containing the external data files in the data model editor.
2. On the "Analysis" tab, in the "Analysis" group, expand "Synchronization" and select "Update analysis from external databases". The external database synchronization wizard starts.
3. Select the databases used in the analysis to check.
4. Specify the type of check and validate. You have the ability to check:
   • the data files (tables) common to the external database and to the analysis.
   • all the data files (tables) found in the external database.
5. The list of data files that are not consistent with the current analysis is displayed. The current analysis can be updated. Choose the modifications to apply.
6. Program (if necessary) a regular check of the structure of the external databases. This check will be automatically performed when the analysis is opened. Specify (if necessary) the frequency of this check.
7. Validate.

Programming a regular synchronization (when the analysis is opened)

1. Open the analysis containing the external files in the data model editor.
2. Open the analysis description window:
   • right-click to open the context menu of the analysis scheme.
   • select "Analysis description".
3. On the "Options" tab, select the synchronization frequency:
   
4. Validate.