Data Model Scripts

The data model scripts allow the link between a data model and global scripts. When a data model is using a custom SQL object (views, tables, stored procedure), a global Script should be created in order to be able to generate this custom SQL object and should also be attached to this specific data model.

When the data model will be exported, the global scripts related to this data model will be exported as well. The scripts will be executed when the import of the data model is executed.

  • The data model scripts can be called from the Tools drop-down menu OR by clicking on in the toolbar.

To add a global script to the list of scripts to execute:

  • Select the scripts from the list and click the button.

You can preview the script by clicking Preview Script.

Note

In some cases the scripts must be executed in a specific order.

Use the arrow to change the order of the scripts.

The scripts can also be executed directly from this window, click Execute.