Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

Toad Data Modeler 7.3 - User Guide

Parcourir le contenu

New in this Release Product Improvement Program Toad World Community Supported Databases Connection Types by Database Toad Data Modeler Freeware About Us

Interface Layout

Application View Application Window Designer and Workspace Docking Hot Keys Inplace Editor Message Explorer Model Explorer Object Navigator Box Object Types and Properties Object Viewer Status of Items in Grids

File Menu Edit Menu View Menu Objects Menu Layout Menu Model Menu Tools Menu Macros Menu Expert Mode Menu Settings Menu Window Menu Help Menu Search Bar

Models and Model Objects

Physical Data Model

Entity Relationship Diagram Objects

Create Entities Edit Entities Copy Entities Move Entities Entity Right-Click Options

Create Attributes Edit Attributes Display Attributes in Model Order Attributes Copy Attributes Move Attributes Delete Attributes Parent Attributes

Display Keys in Model Create Keys Edit Keys Delete Keys Select Parent Key for Relationship Unique Attributes Foreign Keys in Toad Data Modeler FK Mapping

Indexes

Check Constraints

Check Constraints

Triggers

Permissions

Data Types and Dictionary

User Data Types Dictionary Types Domains Export/Import Dictionary

Notation and Cardinality Relationship Types Create Relationships Edit Relationships Referential Integrity Edit Relationship Lines Format Relationship Lines Relationship Right-Click Options

Views

Materialized Views

Materialized Views

Procedures

Functions

Defaults

Check Constraint Rules

Check Constraint Rules

Schemas

Synonyms

Users

User Groups

Basic Database Design

Select Target Database Create Entities Create Attributes Create Primary Key Create Relationship Notation and Cardinality Mandatory/Optional Parent/Child Set up Referential Integrity Rules Connect Parent and Child Entities Understanding Foreign Keys Parent Attributes

Advanced Database Design

About Advanced Options Alternate Keys Indexes Check Constraints Triggers Views Materialized Views Procedures Functions Schemas Users User Groups Permissions

Universal Data Model Logical Data Model

Objects in Logical Model

Objects in Logical Model Format Logical Objects

Edit Entities Entity Right-Click Options

Create Attributes Edit Attributes

Unique Identifiers

Create Unique Identifiers Edit Unique Identifiers Select Linking Method

Edit Relationships

Create Inheritances Edit Inheritances

Conversion to Physical Model

Convert Logical Model to Physical Model Data Type Conversion M:N Relationships Migration of Keys Inheritance

Defaults

Rules

Working with Model Objects

Add Objects Edit Objects Format Objects Select Objects Align Objects Rename Objects Copy Objects Move Objects Delete Objects Find Objects External Objects Shortcuts of Objects

About Shortcuts Create Shortcuts Edit Shortcuts Remove and List Shortcuts

Model Independent Objects

2-D Shapes Note and Line Image Stamp Caption of Categories

Features and Tools

Application Variables

Application Variables - Examples

Microsoft Excel Export/Import CSV Export to Image Import from ER/Studio Data Architect

DDL Script Generation

Script Generation Preparation How to Generate DDL Script Example of Generated Script

Autolayout Arrange Objects in Layers Arrange Relationship Lines Categories Change Notation Data Warehouse Types Display Modes Display Level for Entities Format Workspaces and Objects Line Autolayout Set Colors for Attributes and Keys Grid and Grid Size Zoom, Loupe, Overview

Model Actions Generate Change Script

Change Script Simple Change Script

Merge Models Simple Model Merge

Model Conversion

Data Type Conversion Settings PER - PER Conversion Information PER - LER Conversion Information Convert Model Simple Model Conversion

Compare Models, Generate Change Report Model Update Synchronization

Page Setup Preview PDF and Plotter Printing

Create New Project

Add Existing Models to Project Generate Project Report

XSL Transformation Customize XSLT Templates HTML Reports RTF Reports PDF Reports

Reverse Engineering

Connections Reverse Engineering Wizard Object Explorer Import Toad ERD Universal DB/ANSI Model

Scripting and Customization

Scripting Window Script Explorer Script Editor Automation - Calling TDM From Other Applications Package Explorer Scripting in Script Editor Internal Scripting How to Create Custom Properties

Custom Property Example

Scripting and Customization Samples

Create New Package Add New Properties in Metamodel Creating New Objects Modify Form Set Default Values Add Events Samples for Message Dialogs Access Property Values via Scripting File System Scripts Create Script Getting Settings Information Iterate Entity And Attributes Call Existing Script from Model Properties Form Modify HTML Reports

Customize Forms and Frames

Component Inspector Component Palette Form Explorer

Productivity Pack Rename Objects Pack Macros and User Forms Macro and User Forms - Use Case

About Metamodel

Add Existing Classes Create Classes Edit Classes

Create Properties Edit Properties

Create Methods Edit Methods

Generalizations

Create Generalization Edit Generalization

Create Associations Edit Associations

About Templates

Template Editor Manage Templates Toad for Oracle Templates

Tips and Tricks

Rename Tips and Hints for Large Models Command Line Parameters Other Quick Tips

Toad for Oracle Integration

Toad® for Oracle® Connections Import Toad® for Oracle ER Diagrams Open Toad® for Oracle® Projects Toad® for Oracle® as Default Editor Toad® for Oracle® Icons

Toad Intelligence Central (TIC) Integration

Basic Actions Publishing Models/Reports Notifications

About Naming Conventions

Verification and Synchronization

On Form Synchronization

Naming Conventions Configuration

Properties Rules Naming Convention Valid Characters Glossary

To Do List Quick Search About Gallery

Modifying Items Gallery Explorer

Model Verification Data Generation for SQL Server Refactoring Utility Schema/Owner/Database Assignment Infer Relationships

Version Control

Git Version Control Subversion

Application Settings Project Settings Subversion Actions

Version Manager

Projects and Files in Version Manager Version Manager Toolbar and Options List of Projects, Files, Versions

Options and Configuration

Default Values Dictionaries File Extensions Enabled/Disabled Databases

Amazon Redshift 1.0

Reverse Engineering Script Generation

IBM DB2 LUW 9.5

Reverse Engineering

IBM DB2 LUW 9.7

Reverse Engineering

IBM DB2 LUW 10.1

Reverse Engineering Script Generation

IBM DB2 LUW 10.5

Reverse Engineering Script Generation

IBM DB2 LUW 11.1

Reverse Engineering Script Generation - DB2 v.11.1 (LUW)

IBM DB2 z/OS 10

Reverse Engineering Script Generation

IBM DB2 z/OS 11

Reverse Engineering Script Generation

Reverse Engineering

Reverse Engineering Script Generation

Reverse Engineering Script Generation

Reverse Engineering

EDB Postgres Advanced Server 10

Script Generating Reverse Engineering

Microsoft Access 2007/2010

Reverse Engineering Specifics Script Generating

Microsoft Azure SQL Database V12

Reverse Engineering Script Generation

Microsoft SQL Server 2005

Reverse Engineering Script Generation

Microsoft SQL Server 2008

Reverse Engineering Script Generation

Microsoft SQL Server 2012

Reverse Engineering Script Generating

Microsoft SQL Server 2014

Reverse Engineering Script Generating

Microsoft SQL Server 2016

Reverse Engineering Script Generating

Microsoft SQL Server 2017

Reverse Engineering Script Generating

Microsoft SQL Server 2019

Reverse Engineering Script Generating

Reverse Engineering Script Generation

Reverse Engineering

Reverse Engineering

Reverse Engineering Script Generation

Reverse Engineering Script Generation

Reverse Engineering Script Generating

Reverse Engineering Script Generation

Oracle 11g Release 1

Reverse Engineering

Oracle 11g Release 2

Reverse Engineering Script Generation

Oracle 12c Release 1

Reverse Engineering Script Generation

Oracle 12c Release 2

Reverse Engineering Script Generation

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Reverse Engineering Script Generating

Sybase ASE 15.5

Reverse Engineering

Sybase ASE 15.7

Reverse Engineering

Reverse Engineering Script Generation

Reverse Engineering

Sybase SQL Anywhere 11

Reverse Engineering

SAP SQL Anywhere 17

Reverse Engineering Script Generation

Reverse Engineering

Vertica Database 8.0

Reverse Engineering Script Generation

Copyright Legal Notices

Script Generating

Databases > PostgreSQL 12 > Script Generating

PostgreSQL 10

Supported Databases

Toad Data Modeler provides full support to the databases listed below:

Amazon® Aurora MySQL 5.6
Amazon® Aurora PostgreSQL 9.5
Amazon® Redshift 1.0
IBM® DB2® z/OS® 11
IBM® DB2® LUW 9.7, 10.1, 10.5, 11.1, 11.5
Greenplum Database® 4.2
Ingres 9.3, 10.0
EDB Postgres Advanced Server 10
Microsoft® Access® 2007-2019, incl. Office 365
Microsoft® Azure® SQL Database V12
Microsoft® SQL Server® 2012, 2014, 2016, 2017, 2019
MySQL 5.5, 5.6, 5.7, 8.0
Oracle® 11g R1, 11g R2, 12c R1, 12c R2, 18c, 19c
PostgreSQL 9.2, 9.3, 9.4, 9.5, 10, 11, 12
SQLite 3.7, 3.32
SAP® SQL Anywhere 17
SAP® ASE 16.0
Sybase® ASE 15.7
Sybase® IQ 15.2
Teradata 13, 16.2
Vertica Database 8.0
Other (Universal Model)

IMPORTANT: You can also create and work with models from other versions of databases that have been deprecated by their production companies. Toad Data Modeler cannot provide fixes and provide support for more features of these databases. Uncheck Show Supported Databases Only to display all databases that you can create and open models for.

Details of Database Support

	Reverse Engineering
Supported Database System	From a Database	From a SQL File	Change Script Generation	SQL/DDL Code Generation
Amazon Aurora MySQL	l	l	l	l
Amazon Aurora PostgreSQL	l	l	l	l
Amazon Redshift	l	l	l	l
IBM DB2 z/OS	l	l	l	l
IBM DB2 LUW	l	l	l	l
Greenplum	l	l	l	l
Ingres	l	l	l	l
EDB Postgres Advanced Server	l	l	l	l
Microsoft Access	l	l	l	l
Microsoft Azure SQL Database	l	l	l	l
Microsoft SQL Server	l	l	l	l
MySQL	l	l	l	l
Oracle	l	l	l	l
PostgreSQL 9.5 and newer	l	l	l	l
PostgreSQL 9.4 and older	l	l	l	l
SQLite	l	l	l	l
SAP ASE	l	l	l	l
Sybase ASE	l	l	l	l
Sybase IQ	l	l	l	l
SAP SQL Anywhere	l	l	l	l
Teradata	l	l	l	l
Vertica Database	l	l	l	l
Other databases (Universal Model)	l	l	l	l

Note: Toad Data Modeler includes also support of Universal DB/ANSI Models. See Universal DB/ANSI Model for more information.

Reverse Engineering

Databases > PostgreSQL 12 > Reverse Engineering

Available Data Providers are:

Connection via ODBC
Native Connection

Connection via ODBC:

Native Connection:

Script Generating

Databases > PostgreSQL 12 > Script Generating

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation

© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center