Toad™ Products: Platforms Supported


Contents

Toad Products for Relational Databases

Toad Products for Non-Relational Databases

Toad Applications IDE Extensions

For More Information


Toad Products for Relational Databases

Toad for Oracle

Toad for SQL Server

Toad for IBM DB2 LUW

Toad for IBM DB2 z/OS

Toad for MySQL

Toad for Sybase

Toad Data Modeler

Toad - Mac Edition

Toad Data Point

Benchmark Factory

Quest Code Tester for Oracle

Backup Reporter for Oracle

Toad product Databases supported
Toad for Oracle 12.5

Database Server:

  • Oracle versions 8.0.6, 8.1.7, 9i, 9i R2, 10g, 10g R2, 11g, 11g R2, 12c

Cloud database service:

  • Oracle databases running on Amazon EC2
Toad™ for SQL Server® 6.5

Database Server:

  • Limited support of SQL Server 2000 (Service Pack 3 or later)

    Note: The following features are not available:

    • Index Defragmentation

    • Storage Management

    • Performance Monitor

    • Spotlight™ Essentials Performance Analytics

    • Altering procedures, functions, views in the Editor

    • Version Control
  • SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express

  • SQL Server 2008 and SQL Server 2008 Express

  • SQL Server 2008 R2 and SQL Server 2008 R2 Express

  • SQL Server 2012 and SQL Server 2012 Express

  • SQL Server 2014 Enterprise and SQL Server 2014 Express

Notes:

  • SQL Server Compact Edition is NOT supported.
  • Storage Management is not available on SQL Server Express.

Cloud database service:

  • SQL Azure
Toad for IBM DB2 LUW 6.0

Database Server:

  • IBM DB2 LUW 9.1, 9.5, 9.7, 10.1, 10.5
Toad for IBM DB2 z/OS 6.0

Database Server:

  • IBM DB2 z/OS 9, 10, 11
Toad™ for MySQL 7.3

Database Server:

  • MySQL 4.1, 5.0, 5.1, 5.5, 5.6
  • Clustrix 5.2
Toad for Sybase 2.1

Database Server:

  • Sybase ASE 12.5.4, 15.0.2, 15.0.3, 15.5, 15.7
  • Sybase IQ 15.0, 15.1, 15.2, 15.3, 15.4
  • Sybase SQL Anywhere 10, 11, 12
Toad™ Data Modeler 5.3

Database Server:

  • DB2® UDB v. 8 (LUW), 9.0 (LUW), 9.5 (LUW), 9.7 (LUW), 10.1 (LUW), 10.5 (LUW)
  • DB2 z/OS® v. 9, v.10
  • Ingres™ 9.3, 10.0
  • Greenplum 4.1, 4.2
  • Microsoft® Access® 2000, 2002, 2003, 2007, 2010
  • Microsoft SQL Azure®
  • Microsoft SQL Server® 2000, 2005, 2008, 2012, 2014
  • MySQL 5.0, 5.1, 5.5
  • Oracle 9i, 10g, 11g R1, 11g R2, 12c
  • PostgreSQL 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2
  • SQLite 3.7
  • Sybase ASE 12.5, 15, 15.5, 15.7
  • Sybase IQ 15.2
  • Sybase SQL Anywhere® 11
  • Teradata® 13

Cloud database services:

  • Oracle databases running on Amazon EC2
  • SQL Server running on Microsoft SQL Azure™
  • MySQL database running on Amazon RDS
Toad™ - Mac® Edition 1.2.2

Database Server:

  • Oracle® 9i to 12c
  • PostgreSQL 9.0, 9.1, 9.2
  • MySQL 5.5, 5.6
Toad™ Data Point 3.6

Database Server:

  • Oracle® 9i, 10g, 11g, 11g R2, 12c
  • SQL Server® 2000 SP3 to 2014, and SQL Azure
  • IBM® DB2® LUW 9.1, 9.5, 9.7, 10.1, 10.5
  • IBM DB2 zOS® 9, 10, 11
  • MySQL 4.1, 5.0, 5.1, 5.5, 5.6
  • Sybase® ASE® 12.5.4, 15.0.2, 15.0.3, 15.5
  • Sybase IQ 15
  • Sybase SQL Anywhere® 12
  • Teradata® 12.0, 13.0, 13.10, 14
  • Microsoft® Access® 2003, 2007, 2010, 2013
  • Microsoft Excel® 2003, 2007, 2010, 2013

ODBC: Most databases compatible with ODBC 3.0 or later.

QA certification is available for:

  • Greenplum® Database
  • IBM DB2 for i5/OS V5R4 and IBM i 6.1
  • Informix Dynamic 10.00, 11.0 (limited testing)
  • Ingres Community Edition 2006 R2 on Windows 32-bit (limited testing)
  • Netezza Data Warehouse Appliance 4.6.6, 6.0, 7.0
  • PostgreSQL® 8.3.4
  • Vertica 4.1, 5.0, 5.1 (with 4.0, 4.1 ODBC driver), 6.0 (with 6.0 ODBC driver), 6.1, 7.0

Non-relational databases:

  • Amazon DynamoDB
  • Amazon SimpleDB™
  • Apache Cassandra™
  • Apache HBASE™
  • Apache Hive™
  • Azure Data Market
  • Azure Table Services
  • Business Objects XI 3.0, 3.1
  • Oracle Business Intelligence Enterprise 11g
  • Google Analytics™
  • Microsoft SQL Server Analysis Services
  • MongoDB™
  • OData
  • Salesforce.com®
  • SharePoint®
Benchmark Factory™ 7.1

Database Server:

  • Oracle: 9i, 9.2, 10g, 11g, and 12c (requires Oracle 9, or later, client libraries).

    Notes:

    • Benchmark Factory has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.
    • Oracle Capture/Replay of workloads must use Oracle 9i or later.
  • SQL Server: 2000, 2005, 2008, 2008 R2, 2012, and 2014
  • SQL Azure™: Benchmark Factory provides limited support of SQL Azure.
  • SAP®: 12.5, 15, 15.5, 15.7, and 16
  • IBM DB2 LUW: 8.1.5 through 10.x
  • IBM DB2 for z/OS: 8.x through 10.x
  • MySQL: 4.5 and 5.x

Note: The 32-bit version of Benchmark Factory requires the 32-bit version of the client libraries (including ODBC drivers). The 64-bit version requires 64-bit client libraries.

Quest Code Tester for Oracle 2.6.2

Database Server:

  • Oracle 9i Database Release 2 (9.2.0.6 or above)
  • Oracle 10g R1
  • Oracle 10g R2
  • Oracle Express Edition
  • Oracle 11g R1
  • Oracle 11g R2
  • Oracle 12c
  • Cloud Database Server-Oracle databases running on Amazon EC2.
Backup Reporter for Oracle® 2.0

Database Server:

  • Oracle 9i, 10g, 11g R1, 11g R2, 12c

Cloud database services:

  • Oracle databases running on EC2

Toad Products for Non-Relational Databases

Toad for Cloud Databases

Toad Intelligence Central

Toad Decision Point

Toad product Databases supported
Toad for Cloud Databases 1.6

Non-relational databases:

  • Microsoft Azure Table Services
  • Apache Cassandra
  • Amazon SimpleDB
  • Hadoop Hbase
  • Apache Hive
  • MongoDB

Relational databases:

  • ODBC-compliant databases.

Note: Though not a Cloud database, support for ODBC-compliant relational databases enables Toad to join data from a local relational database to a remote Cloud database in a single SQL query.

Business Intelligence Data Sources:

  • Microsoft Analysis Services
  • Oracle Business Intelligence Enterprise Edition 11g
  • SAP Business Objects Query as a Web Service (QAAWS) XI 3.1
  • Salesforce force.com
Toad Intelligence Central 2.4

Business Intelligence Data Sources

  • Dell Boomi
  • Windows Azure DataMarket
  • Google Analytics
  • Oracle Business Intelligence Enterprise Edition 10g and 11g
  • SAP Business Objects Query as a Web Service (QAAWS) XI 3.0 and 3.1
  • Salesforce
  • SharePoint Lists using Data Services over SharePoint Server 2010 and later via OData
  • Apache Hive
  • Microsoft Analysis Services
  • OData - Generic for any OData service

Relational databases

  • ODBC-compliant databases.

Non-relational databases

  • Microsoft Azure Table Services
  • Apache Cassandra
  • Amazon SimpleDB
  • Apache HBase
  • MongoDB
  • Amazon DynamoDB
Toad Decision Point 2.4

Business Intelligence Data Sources

  • Microsoft Analysis Services
  • Google Analytics
  • Oracle Business Intelligence Enterprise Edition 10g and 11g
  • SAP Business Objects Query as a Web Service (QAAWS) XI 3.0 and 3.1
  • Salesforce

Business Intelligence Data Sources (via Decision Point Local Storage only)

  • Dell Boomi
  • Windows Azure DataMarket
  • SharePoint Lists using Data Services over SharePoint Server 2010 and later via OData
  • Apache Hive
  • OData - Generic for any OData service

Relational databases

  • ODBC-compliant databases with specific support for Microsoft Access, Oracle, Microsoft SQL Server and MySQL

Non-relational databases (via Decision Point Local Storage)

  • Microsoft Azure Table Services
  • Apache Cassandra
  • Amazon SimpleDB
  • Apache HBase
  • MongoDB
  • Amazon DynamoDB

Toad Application IDE Extensions

Toad Extension for Eclipse

Toad product Databases supported
Toad™ Extension for Eclipse 2.1.2
  • Oracle 9i to 12c
  • PostgreSQL 9.0, 9.1, 9.2
  • MySQL 5.5, 5.6

About Dell Software

Dell listens to customers and delivers worldwide innovative technology, business solutions and services they trust and value. For more information, visit www.software.dell.com.

Contacting Dell

Technical Support:
Online support

Product Questions and Sales:
(800) 306-9329

Email:
info@software.dell.com

Technical support resources

Technical support is available to customers who have purchased Dell software with a valid maintenance contract and to customers who have trial versions. To access the Support Portal, go to http://software.dell.com/support/.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. In addition, the portal provides direct access to product support engineers through an online Service Request system.

The site enables you to:


 

© 2014 Dell Inc.

ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Dell Inc.

The information in this document is provided in connection with Dell products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Dell products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, DELL ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL DELL BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF DELL HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Dell makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Dell does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Dell Inc.
Attn: LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

Refer to our web site (software.dell.com) for regional and international office information.

Patents

Toad for Cloud Databases contains patent pending technology.

Toad Intelligence Central contains patent pending technology.

Toad Data Point contains patent pending technology.

Trademarks

Dell, the Dell logo, Quest, Benchmark Factory, Spotlight, LiteSpeed, SQL Navigator, vWorkspace, and Toad are trademarks of Dell Inc. and/or its affiliates. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell disclaims any proprietary interest in the marks and names of others.