Toad® Products: Platforms Supported


Contents

Toad Products for Relational Databases

Toad Products for Non-Relational Databases

About Us


Toad Products for Relational Databases

Toad for Oracle

Toad for SQL Server

Toad for IBM DB2

Toad for MySQL

Toad for SAP Solutions

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.10

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 and Oracle Cloud
Toad® for SQL Server® 6.6

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 6.3

Database Server:

  • IBM DB2 for LUW 9.5, 9.7, 10.1, 10.5, 10.5.0.5, 11.1
  • IBM DB2 for z/OS 9, 10, 11, 12
Toad® for MySQL 7.7

Database Server:

  • MySQL 4.1, 5.0, 5.1, 5.5, 5.6
  • Clustrix 5.2
  • MariaDB 5.5.5

Toad for SAP Solutions 3.2

Database Server:

  • SAP ASE 12.5.4, 15.0.3, 15.5, 15.7, 16
  • SAP IQ 15.3, 16
  • SAP SQL Anywhere 12, 16
  • SAP HANA: 08, 09, 11, 12, 2.0
Toad® Data Modeler 6.2

Database Server:

  • IBM® DB2® z/OS® 9, 10, 11
  • IBM® DB2® LUW 9, 9.5, 9.7, 10.1, 10.5
  • IBM® DB2® UDB v. 8 (LUW)
  • Greenplum Database® 4.1, 4.2
  • Ingres 9.3, 10.0
  • Microsoft® Access® 2000-2003, 2007-2010
  • Microsoft® Azure® SQL Database V12
  • Microsoft® SQL Server® 2000, 2005, 2008, 2012, 2014, 2016
  • MySQL 5.0, 5.1. 5.5, 5.6, 5,.7
  • Oracle® 9i, 10g, 11g R1, 11g R2, 12c R1, 12c R2
  • PostgreSQL 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5
  • SQLite 3.7
  • SAP® SQL Anywhere 17
  • SAP® ASE 16.0
  • Sybase® ASE 12.5, 15, 15.7
  • Sybase® IQ 15.2
  • Sybase® SQL Anywhere 11
  • Teradata 13
  • Vertica Database 8.0
  • Other (Universal Model)

Cloud database services:

  • Oracle databases running on Amazon EC2
  • SQL Server running on Microsoft SQL Azure™
  • MySQL database running on Amazon RDS
  • Oracle® Database as a Service
Toad® Data Point 4.2

Database Server:

  • Oracle® 9i, 10g, 11g, 11g R2, 12c
  • SQL Server® 2000 SP3 to 2016, and SQL Azure
  • IBM® DB2® LUW 9.5, 9.7, 10.1, 10.5, 10.5.0.5, 11.1
  • IBM DB2 zOS® 9, 10, 11, 12
  • MySQL 4.1, 5.0, 5.1, 5.5, 5.6
  • MariaDB 5.5.5 (using MySQL provider)

  • SAP® ASE 12.5.4, 15.0.2, 15.0.3, 15.5, 15.7, 16
  • SAP IQ 15, 16
  • SAP SQL Anywhere® 12, 16
  • SAP HANA SPS 08, SPS 09, SPS 10, SPS 11, SPS 12, 2.0

  • Teradata® 12.0, 13.0, 13.10, 14, 15
  • Microsoft® Access® 2003, 2007, 2010, 2013, 2016
  • Microsoft Excel® 2003, 2007, 2010, 2013, 2016

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
  • Apache Cassandra™
  • Apache HBASE™
  • Apache Hive™
  • Azure Table Services
  • Cloudera Impala—Toad Data Point has been certified by Cloudera

  • SAP Business Objects XI 3.0, 3.1, 4.1
  • Oracle Business Intelligence Enterprise 11g
  • Google Analytics™
  • Microsoft SQL Server Analysis Services
  • MongoDB™
  • OData
  • Salesforce.com®
  • SharePoint®
Benchmark Factory® 7.6

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 (ODBC only), 2005, 2008, 2008 R2, 2012, 2014 and 2016
  • SQL Azure™: Benchmark Factory provides limited support of SQL Azure.
  • SAP® ASE: 12.5, 15, 15.5, 15.7, and 16
  • IBM DB2 LUW: 9.x through 10.x
  • IBM DB2 for z/OS: 9.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.7

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 and Oracle Cloud
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 3.3

Business Intelligence Data Sources

  • Dell Boomi
  • Google Analytics
  • Oracle Business Intelligence Enterprise Edition 10g and 11g
  • SAP Business Objects Query as a Web Service (QAAWS) XI 3.0, 3.1 and 4.1
  • Salesforce verified against API V29 - Winter 2014.
  • SharePoint Lists using Data Services over SharePoint Server 2010 and later via OData
  • Hive verified against versions 0.10 (CDH4.2) and 0.13. Hive Server 2 is supported.

  • Microsoft Analysis Services
  • OData - Generic for any OData service versions 1, 2, 3 and 4.

Relational databases

  • ODBC-compliant databases.

Non-relational databases

Cloud database connections can be made via the Admin Console with views and snapshots published to the Intelligence Central Server. This release supports connections to:

  • Azure Table Services
  • Apache Cassandra verified against versions 1.0.5, 1.2.3, 2.0.9, 2.1.7, 3.0.5, and 3.4.
  • Apache HBase verified against versions 0.89, 0.90.3 and 0.98.6.
  • MongoDB verified against versions 2.0.1, 2.6, 2.6.5, 3.0, and 3.2.4.
  • 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

About Us

We are more than just a name

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation.

Our brand, our vision. Together.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece—you—to the community, to the new Quest.

Contacting Quest

For sales or other inquiries, visit www.quest.com/company/contact-us.aspx or call 1-949-754-8000.

Technical support resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:


© 2017 Quest Software 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 Quest Software Inc.

The information in this document is provided in connection with Quest Software 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 Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE 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 QUEST SOFTWARE 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 QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software 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. Quest Software 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:

Quest Software Inc.
Attn: LEGAL Dept
4 Polaris Way
Aliso Viejo, CA 92656

Refer to our web site (www.quest.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.

Quest Software is proud of our advanced technology. For the most current information about applicable patents for this product, please visit our website at www.quest.com/legal.

Trademarks

Quest, Quest Software, Benchmark Factory, Spotlight, Toad, and the Quest logo are trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest Software trademarks, please visit our website at www.quest.com/legal. Microsoft, Windows, Windows Server, Windows Vista, Visual Studio, SQL Server, SharePoint, Access and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates in the United States and other countries. Citrix® and XenApp™ are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. SAP is the registered trademark of SAP AG in Germany and in several other countries. IBM and DB2 are registered trademarks of International Business Machines Corporation. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Google and Google Analytics are registered trademarks of Google Inc. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. Subversion is a trademark of the Apache Software Foundation. All other trademarks, servicemarks, registered trademarks, and registered servicemarks are property of their respective owners.