Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Toad Data Modeler 7.3 - 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 Microsoft SQL Server 2019 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 Oracle 19c PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 PostgreSQL 11 PostgreSQL 12 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

2-D Shapes

Toad Data Modeler allows you to insert the following 2-D shapes to your ER diagram:

  • Note
  • Line
  • Stamp
  • Categories
  • Image
  • Rectangle
  • Ellipse
  • Text
  • Label Quadrangle
  • Label Ellipse

The objects are available on Graphics Objects Toolbar and in the Objects Menu| Add New for both physical and logical model.

To change format of these objects

Right-click the object and select Format.

TIP: Feel free to arrange and order the objects on Workspace. Arrange Objects in Layers

Note and Line

A note can refer to a model, Workspace, particular entity, attribute, relationship etc.

To add a note to your model

  1. Click   icon on Graphics Objects Toolbar or select Objects | Add New | Note and click the work area.
  2. Double-click the Note to edit it.
  3. Write a text on tab General. The automatic word wrap function is available.

TIP: To change a format of Note, right-click it and select Format. To adjust the size of a Note to a length of text contained, click the Shape tab and select Recalculate Size.

Note Shortcuts

You can also create shortcuts of Notes:

Scenario

You have a Note which describes your Customer entity. The entity is places on multiple Workspaces. You would like to have the Note on every Workspace where is the entity.

Solution: Create multiple shortcuts of your Note object and place each onto a different Workspace.

To make a connection between a Note and an object that the note relates to, you can use a Line.

Lines

To add a Line

  1. Click  or select Objects | Line.
  2. Click the object and then click the Note.

To change the look of the lines on the Workspace

  1. Right-click the WS and select Workspace Format.
  2. Click the Line tab and select the line end type.
  3. Right-click the line and select Line Style.

Image

You can add logos and other images to your ER diagrams and then relate them to any object on Workspace using a Line.

To insert an image

  1. Click icon on Graphic Objects Toolbar (or select Objects | Add New | Image).
  2. Click on the Workspace where you want to insert the image.
  3. Select the image from the Open dialog and click Open.

Note: Images that you insert to your ER diagrams aren't saved together with your model.

To edit an image

Double-click the image on the Workspace.

Image in Model Explorer

Take notice of the Image item in Model Explorer. From here, you can manage your images as well.

Image and Shortcuts

You can create shortcuts of an Image on every Workspace of your model or create multiple shortcuts on one Workspace.

Stamp

Add a Stamp to the Workspace to display information about your model such as Author, Company, Date of Creation etc.

To add a stamp

  1. Click icon on Model Objects Toolbar (or select Objects | Add New | Stamp), and click anywhere on Workspace.

  1. To change the format of the Stamp, right-click it and select Format.

To edit a stamp

Double-click the Stamp on Workspace. Model Properties dialog displays, here you enter the information which is shown in Stamp.

Stamp and Shortcuts

You can create shortcuts of a Stamp on every Workspace of your model or create multiple shortcuts on one Workspace.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation