Packages affect models of various database platforms and versions depending on their Visibility and relations with other packages (Extension, Dependency). To create and immediately execute scripts, take advantage of Scripting Window located in Expert Mode Menu.Ī package contains various means of customization such as scripts, macros, customized form definitions, data type conversion rules, etc. Scripts/Macros can be accessed via Expert Mode Menu | Customization | Script Explorer. Note: Macros are similar to scripts except they can be configured to appear in custom Macro menu or context menu of selected objects. This document is available in the Expert Mode | Reference Guide (with Expert Mode enabled).Ĭode written in JScript, VBScript or Internal script may be used to access and modify various model objects or even perform model actions such as model renaming, merging, DDL script customization, etc. Note: Useful information about available classes, methods, functions and properties accessible in Toad Data Modeler can be found in the Reference Guide. The scripting and customization capabilities include: Right-click a model name in Model Explorer or Application View and select Repair Model to repair broken models. Right-click a model name in Model Explorer or Application View and select Test Model to run an internal test of model consistency. To start scripting/customizing, you need to enable Expert Mode first.Ĭheck Expert Mode in Settings | Options | GeneralĮxpert Mode menu and Options section Expert Mode will appear. You can also leverage the power of scripting and automation to improve your workflow. Toad Data Modeler and its behavior can be easily customized in several ways to better fit your needs and requirements. Storage Performance and Utilization Management.

Information Archiving & Storage Management.Hybrid Active Directory Security and Governance.Starling Identity Analytics & Risk Intelligence.One Identity Safeguard for Privileged Passwords.

Toad data modeler import excel