Chat now with support
Chat with Support

Toad Data Modeler 7.0 - 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 MySQL 8.0 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - 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 8.0

Toad Data Modeler supports MySQL 8.0 in Reverse Engineering from a database, from a SQL file, Change Script Generation and SQL/DDL Code Generation

Reverse Engineering

See Reverse Engineering - MySQL 5.0 for more information.

Script Generating

See Script Generation - MySQL 5.0 for more information.

Oracle 10g

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