||It has been suggested that this article be merged with Toad Data Modeler. (Discuss) Proposed since November 2015.|
|This article needs additional citations for verification. (September 2016) (Learn how and when to remove this template message)|
|Original author(s)||Jim McDaniel|
|Written in||Various (depending on the database used)|
|Type||Database management tools|
Toad solutions from Quest Software is a database management toolset that database developers, database administrators and data analysts use to manage both relational and non-relational databases using SQL.
Supported databases and environments
Toad supports the following databases and environments:
- Amazon Redshift
- Amazon SimpleDB
- Amazon DynamoDB
- Apache HBase
- Apache Hive
- Apache Cassandra
- Google Analytics
- IBM DB2
- IBM Informix Dynamic
- IBM DB2 for Linux, UNIX and Windows
- IBM DB2 for z/OS
- IBM Netezza
- Microsoft Access
- Microsoft Excel
- Microsoft OData
- Microsoft SQL Server
- Microsoft SQL Server Analysis Services
- Microsoft SQL Server databases running on Amazon EC2
- Microsoft SharePoint
- Microsoft Windows Azure Table Storage Service
- Microsoft Windows Azure Marketplace DataMarket
- Microsoft Windows Azure SQL Database
- ODBC generic
- Oracle databases running on Amazon EC2
- Oracle Business Intelligence Enterprise Edition
- SAP® Business Objects
- SAP Sybase ASE
- SAP Sybase IQ
- SAP Sybase SQL Anywhere
Toad runs on all 32-bit/64-bit Windows platforms, including Microsoft Windows Server, Windows XP, Windows Vista, Windows 7 and 8 (32-Bit or 64-Bit). Quest Software has also released a Toad Mac Edition. Quest provides Toad in commercial and trial/freeware versions. The Freeware version is available from the ToadWorld.com community.
Jim McDaniel (aka "TOADman"), a practicing Oracle DBA, originally designed Toad for his own use in the late 1990s. He called it Tool for Oracle Application Developers: "TOAD" for short. McDaniel made the tool available to others first as shareware and later as freeware, distributing it freely over the Internet.
As the user base grew, so did the effort of maintenance and development. Finally, the author realized that he could no longer dedicate substantial amounts of time to the growing quantity of software enhancement requests.
Quest Software, established in 1987, acquired TOAD in October 1998 and became part of Dell in September 2012 as Dell Software. In 2016, Dell Software was sold off and renamed back to Quest Software.
- Toad Pocket Reference for Oracle plsql 1st Edition by Jim McDaniel and Patrick McGrath, O'Reilly, 2002 (ISBN 0596003374, ISBN 978-0-596-00337-1)
- Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005 (ISBN 0596009712, ISBN 978-0-596-00971-7)
- TOAD Handbook by Bert Scalzo and Dan Hotka, Sams, 2003 (ISBN 0672324865, ISBN 978-0-672-32486-4)
- TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (ISBN 0321649109, ISBN 978-0-321-64910-2).
- "Toad World". Dell Software Inc. 2016.
- Scalzo, Bert; Hotka, Dan (February 2003). Toad Handbook. Developer's Library. Jim McDaniel. Sams Publishing. p. xiv. ISBN 9780672324864. Retrieved 2013-10-23.
I've been working on TOAD now for more than six years. Or has it been seven?
- "Quest Software's Acquisitions". Dell Inc. Retrieved 2013-03-05.
- "About Quest Software – now a part of Dell".
- Hufford, Austen (2016-06-20). "Dell to Sell Software Unit to Francisco Partners and Elliott Management". Wall Street Journal. ISSN 0099-9660. Retrieved 2016-11-09.
- "Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management". Quest Community. Retrieved 2016-11-09.