Generate the SQL script

Before using this function, the properties associated with the model should be reviewed. Open the FTM model in the Modeling perspective. Select the model, right-click and select the Properties¹ option. The following window is opened. Select the FTM Configuration Data Properties entry. These properties are stored in a properties file (resources/File.properties) in the same project as the model. If a model is transferred to another workspace, these properties will not need to be setup again, but it's enough to transfer the properties file.

To generate the configuration data SQL script, select the top level model node and right-click its name. Select FTM > Generate Config Data SQL. The complete model is validated and errors or warnings are displayed before generating the SQL script.