ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Data model editor
  • Overview
  • How to?
  • Forcing the synchronization
  • Programming a regular synchronization (when the analysis is opened)
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
The analysis must be synchronized with an external database if it uses:
  • data files from an external database (Oracle, SQL Server, etc.).
  • data files whose data was not converted to the HFSQL Classic format.
This synchronization is used to take into account the possible modifications made to the structure of the data files found in the external database.
You can:
  • force the synchronization from the data model editor.
  • program an automatic check for the changes made to the external database when opening the analysis.
How to?

Forcing the synchronization

To force 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. In the "Options" tab, select the synchronization frequency:
    Synchronization options
  4. Validate.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/27/2022

Send a report | Local help