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

Categories

Categories allow you to colorfully distinguish parts of your model. Categories can be assigned to entities, views and relationships.

Scenario

You would like to graphically distinguish all entities related to Ordering process. Or maybe you want to mark all entities containing personal data of your employees.

Solution: You can simply create a category, select its color and assign it to the appropriate entities. All the entities will share the category color.

To add a category to your model

  • Select Model Menu | Categories and click Add in the Category List  dialog.

or

  • Right-click the Categories folder in Model Explorer and select Add Category.,

or

  • In Entity/View/Relationship Properties dialog, click the ... button in the Category section.

To assign category to objects

  • Open Category Properties (via Model Menu or Model Explorer) | Switch to Objects tab and move objects to right section.

or

  • In Entity/View/Relationship Properties, choose the desired category in the Category section on General tab.

TIP:

  • If your model contains multiple categories, you can display captions of categories on Workspace. See Caption of Categories for more information.
  • To use category colors in Model Explorer, right-click in Model Explorer | Settings | enable Use Colors of Category to Draw. Object names will be now match their category color.

Change Notation

To change notation in your model

  • Go to View Menu | Notation | choose IE or IDEF1X.

IDF1X

IE

Data Warehouse Types

In physical model, you can define a Data Warehouse Type for your entities and graphically distinguish Fact and Dimension entities.

Example:

By default, the Data Warehouse options are not available and have to be activated in Settings menu.

To display Data Warehouse Type options

Select Settings Menu | Options | Physical Model | Entity tab | Form Settings | check Display Data Warehouse Type and Size.

Data Warehouse Type and Size options then become available in Entity Properties.

Display Modes

In Toad Data Modeler, you can switch between Logical (Captions), Physical (Names) and Full Names view of object names.

Select the display mode on Display Toolbar or in View Menu | Display Mode.

Logical View (Captions)

Physical View (Names)

Full Names

Related Documents