Toad Data Modeler 6.4 - User Guide

Enabled/Disabled Databases

Starting with version 5.4, Toad Data Modeler implements a new system of managing databases.

Toad Data Modeler 5.3 and older:

• During application installation you were able to choose which databases should/should not be installed. This could not be changed in the application, you had to launch installation program again. By not installing unused databases, you were able to save space on drive.

Toad Data Modeler 5.4 and newer:

• All databases are now installed with the application. A default set of databases is enabled and you can enable/disable databases at any time. By disabling unused databases you can decrease the application startup time.

How to enable/disable databases

You can configure enabled/disabled databases by going to Settings Menu | Add/Remove Databases.

Disabled databases cannot be used in certain application actions (create new model, open existing model, reverse engineering...). However, most of the time you are able to enable a specific database at the time you want to work with it (see screenshot below).

Databases

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

Details of Database Support

Amazon Redshift 1.0

Toad Data Modeler offers support for Amazon Redshift 1.0, including support for Reverse Engineering and DDL Script Generation. There are however the following limitations to Redshift support:

• Databases and Libraries (and grants for them) are not supported
• CREATE TABLE: IF NOT EXISTS clause is not supported

Reverse Engineering

Available Data Providers are:

• Connection via ODBC

In order to connect using ODBC, install an appropriate ODBC driver for your database first.

To create Amazon Redshift connections

1. Select Amazon Redshift ODBC driver in Data Source Name
2. Click Property Data Link to configure connection properties
3. Enter the address to your Redshift server into Server
4. Enter your port number (default: 5439) and database name
5. Enter your user name and password
6. Change any other necessary settings and Test or click OK