Chat now with support
Chat with Support

Toad Data Modeler 6.4 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Copyright Legal Notices

MySQL 5.7

Databases > Specifics

Attributes

[GENERATED ALWAYS] AS (expression) [VIRTUAL | STORED]

Configurable in Attribute Properties | Generated tab.

Data Types

New data type - JSON

Tables

COMPRESSION, ENCRYPTION parameters (Entity Properties | Table Options tab | Other Table Options)

Triggers

Trigger Order - FOLLOWS, PRECEDES

Change Script Generation

  • Support for generated columns for ALTER TABLE
  • Support for multiple TRIGGERS

Reverse Engineering

Databases > MySQL 5.7 > Reverse Engineering

See Reverse Engineering - MySQL 5.0 for more information.

Script Generation

Databases > MySQL 5.7 > Script Generation

See Script Generation - MySQL 5.0 for more information.

Oracle 10g

Databases > Specifics

Entity

External tables are supported. On tab Physical Properties, select the External Table (Organization External) checkbox. The External Table Properties tab will occur on the form.

Attribute

Data Types:

For Char and Varchar2 data types, you can define Column Length in.

For User data type, you can define REF options.

Note: Change for CHAR/BYTE of attributes: Previously, it was necessary to select CHAR or BYTE for Char(x) and Varchar(x) data types of attribute (domain) in Column Length in combo box. Now there is a new item "Default" that is selected by default.

  • Reverse engineering: During RE TDM finds out what is the default item in the Oracle database. Example: BYTE is a default item in Oracle database.
    • Previous behavior: BYTE was loaded for the attribute.
    • Current behavior: “Default” item is shown for the attribute. BYTE will be shown in Model Properties dialog | Database Parameters tab | Length Semantics box (it is not used during script generation).
    • If you want to preserve the previous behavior of TDM, select the "Load CHAR/BYTE to Attributes Regardless Database Default Settings" checkbox in the RE Wizard.
  •   

    Used Sequence (trigger) - From this box, you can select a sequence that you want to use for the attribute. (A new trigger will be created in SQL script.)

    Encryption Specification - Here, you can write e.g. USING 'AES192' NO SALT.

    Index

    Example of Expression index:

    Example: Index properties (for domain index):

     

    Trigger

     

    User Data Type

    When you select Varray Type or Nested Table Type, a new tab displays (Varray Type tab or Nested Table Type tab). There, you can see new boxes where you write appropriate values. Click Create Definition and the definition will be written in the memobox.

    The content of the boxes is not saved and is not used for reverse engineering, script or report generation.

    Hints in memoboxes for User Data Types are shown.

    Other Notes

    • Dictionary types are not supported for Oracle models.
    • User Data Types on user data types in Oracle model.

    Materialized View

     

    Procedure

     

    Function

    Directory

    Java

    Support for Oracle Java Source, including reverse engineering: All the three types of Java schema objects (SOURCE, CLASS, RESOURCE) should be written to this object. - During reverse engineering only SOURCE types are loaded, and from them only sequences of characters for Java source. Other Java schema objects (CLASS, RESOURCE) are loaded only as a name. Checkbox Generate is unselected for all the Java schema objects (SOURCE, CLASS, RESOURCE).

    Sequence

    Synonym

    Tablespaces

    Related Documents

    The document was helpful.

    Select Rating

    I easily found the information I needed.

    Select Rating