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

Schema/Owner/Database Assignment

Features and Tools > Tools > Schema/Owner/Database Assignment

This tool allows you to assign or remove schema/owner/database to/from multiple object groups in your model at once.

To assign a schema/owner to your model

Select Tools | Schema/Owner Assignment.

Option Description

Select Schema/Owner/Database

Contains existing Schemas/Owners/Users in your model.

Select --None-- from the list to remove the existing schema from objects you mark in the Select types of objects section.

Assign to objects where value is not defined

Assigns schema/owner to objects, which have none assigned yet.

Confirm before assignment checkbox

Confirmation dialog for each object where schema is being assigned/removed will be displayed.

Select types of objects area

Mark objects which should be assigned a Schema/Owner.

Infer Relationships

Features and Tools > Tools > Infer Relationships

This feature tries to map Primary Keys or Alternate Keys to identically named attributes in other entities.

Conditions:

  • Mapping is performed between key and non-key attributes. In other words, if identically named attributes are part of primary key in various tables, e.g. ID column in table Customer and ID column in table Order, the two ID columns will not be mapped and no relationship will be created.
  • Names must be identical and data type must be the same, including parameters.
  • Non-identifying relationships are created by default. In case you need an identifying relationship, edit the automatically added relationship and change its type to identifying manually.

To run the Infer Relationship function

Select Tools | Infer Relationship.

Note: Relationships created this way will be marked with a To-Do task prompting you to check whether the relationship has been created correctly.

Example:

Model with no relationships. See the Customer ID column in tables Customer and Order Record.
In table Film there is an alternate key with two columns Title and Director. Identically named columns are in table Customer Rating.

Run the Infer Relationship function and see the result:

Infer Relationships and Reverse Engineering

The same tool can be used automatically during reverse engineering.

Create a new connection or edit an existing stored connection and check the Infer Relationships checkbox to activate this feature.

Version Control

Git Version Control

Features and Tools > Version Control > Git Version Control

To configure git

Configure Toad Data Modeler to work with Git in Options | Application | Version Control System. The values set here will be your default values for setting up new repositories in Toad Data Modeler

  1. Select Git in Type
  2. Set paths to your Git client and working directory for your repository
  3. Click Apply and Initialize Local Repository. The folder will be created (if it does not exist) and initialized
  4. Enter a path to the remote repository, user name, and password
  5. Click Apply and Clone Repository

Git application view

  • The following Git commands are displayed in Application View toolbar when you work with a model that is tracked:

Application View Button Description
Version Control System Settings Opens Options page where you can set the Version Control System preferences
Refresh Refreshes file status in Toad Data Modeler
Add to Index Adds the file to the list of tracked files
Remove from Index Removes the file from the list of tracked files
Commit Commits changes
Push Pushes the committed changes into the remote repository
Pull Pulls the current state from the remote repository
Fetch Fetches information about the current state of the remote repository
Information Displays information about the commit and its author
History Browser Allows you to browse different versions of the file, merge and compare them and create change script
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating