Setting Data Model Properties
Go Up to Customizing the Data Model
The Model Properties Editor lets you modify the Security, Attachment, PreSQL and PostSQL properties for the model. It also displays the name handling options that were applied when the physical model was generated. The editor varies slightly between the logical and physical models.
- Right-click the model or data flow and then click Model Properties.
- For Logical Models, make your changes on the Security Information and Attachment Bindings tabs and then click OK.
- For Data Flows, make your changes on the Security Information and Attachment Bindings tabs and then click OK.
- For Physical Models make your changes on the Security Information, Attachment Bindings, PreSQL & PostSQL tabs and then click OK.
The following describe options that require additional explanation:
Security Information tab
Displays the current security information as defined in the Data Dictionary. You can add or edit security reporting information in by double-clicking the field you want to change. To set the model-wide default value for a property, go to the Data Dictionary tab and expand the Data Security Information Node. For more information, see Enforcing Security Using Data Security Types and Properties.
Attachment Bindings tab
Bind an external piece of information, or attachment to the model. You can also remove an attachment from an object, override an attachment binding's default value, or change the position of a bound attachment. To override the value of the attachment you have moved to the Selected Attachments grid, double-click the Value field of the target attachment. ER/Studio Data Architect opens the Value Override Editor or a list depending on the attachment datatype. Attachments are created in the Attachments folder of the Data Dictionary and must be applied to the data model before they will display on this tab. For more information, see Attaching External Documents to the Data Model.
PreSQL & PostSQL tab
Enter SQL to be applied before or after the CREATE OBJECT statement. If you select Generate, the PreSQL and PostSQL scripts entered here are included in the script when you generate the physical database.
Name Handling tab
The Name Handling tab is read-only and displays the name handling options that were selected in the General Options on page 3 of the Generate Physical Model Wizard when the physical data model was generated. If a naming standards template was used when generating the model, the General options in the Generate Physical Model Wizard are not available, and the settings displayed here should be disregarded.