Jump to content

Toad (software): Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
Fxrs90 (talk | contribs)
75 edits
edited article categories
 
(44 intermediate revisions by 30 users not shown)
Line 1: Line 1:
{{Short description|Database management software}}
{{other uses|Toad (disambiguation)}}
{{Other uses|Toad (disambiguation)}}
{{merge|Toad Data Modeler|date=November 2015}}
{{refimprove|date=September 2016}}
{{more citations needed|date=September 2016}}
{{Infobox software
{{Infobox software
| name = TOAD
| name = TOAD
| logo =Quest TOAD.png
| logo = Toad-Original RGB.png
| caption =
| caption =
| author = Jim McDaniel
| author = Jim McDaniel
| developer = [[Quest Software]]
| developer = [[Quest Software]]
| latest release version =
| latest release version =
| latest release date =
| latest release date =
| latest preview version =
| latest preview version =
| latest preview date =
| latest preview date =
| status =
| status =
| programming language = Various (depending on the database used)
| programming language = Various (depending on the database used)
| platform =
| platform =
| language =
| language =
| genre = Database management tools
| genre = Database management tools
| license = Proprietary
| license = Proprietary
| website = https://www.quest.com/toad/
| website = https://www.quest.com/toad/
}}
}}
'''Toad''' is a database management toolset from [[Quest Software]] that [[database]] developers, database administrators and data analysts use to manage both relational and non-relational databases using [[SQL]].


'''Toad''' is a [[Database Management|database management]] toolset from [[Quest Software]] for managing relational and non-relational databases using [[SQL]] aimed at database developers, database administrators, and data analysts. The Toad toolset runs against [[Oracle Database|Oracle]], [[Database server|SQL Server]], [[IBM Db2|IBM DB2]] (LUW & z/OS), [[Adaptive Server Enterprise|SAP]] and MySQL. A Toad product for data preparation supports many data platforms.
== 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
* [[Ingres]]
* [[Microsoft Access]]
* [[Microsoft Excel]]
* Microsoft [[Open Data Protocol|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
* [[MongoDB]]
* [[MySQL]]
* [[ODBC]] generic
* [[Oracle Corporation|Oracle]] databases running on Amazon EC2
* Oracle Business Intelligence Enterprise Edition
* Oracle
* [[PostgreSQL]]
* [[salesforce]]
* SAP® Business Objects
* SAP Sybase ASE
* SAP Sybase IQ
* SAP Sybase SQL Anywhere
* [[Teradata]]
* [[Vertica]]

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.<ref>{{cite web |url=http://www.toadworld.com |title=Toad World |date=2016 |publisher=Dell Software Inc.}}</ref>


== History ==
== History ==
A practicing Oracle DBA, Jim McDaniel, designed Toad for his own use in the mid-1990s.<ref>{{cite book|url=https://books.google.com/books?id=eKwSVQ7kiaIC|title=Toad Handbook|last1=Scalzo|first1=Bert|last2=Hotka|first2=Dan|date=February 2003|publisher=[[SAMS Publishing|Sams Publishing]]|others=Jim McDaniel|isbn=978-0-672-32486-4|series=Developer's Library|page=xiv|quote=I've been working on TOAD now for more than six years. Or has it been seven?|accessdate=2013-10-23}}</ref> He called it ''Tool for Oracle Application Developers'', shortened to "TOAD". McDaniel initially distributed the tool as [[shareware]] and later online as [[freeware]].
Jim McDaniel (aka "TOADman"), a practicing Oracle DBA, originally designed Toad for his own use in the late 1990s.<ref>
{{cite book
| last1 = Scalzo
| first1 = Bert
| last2 = Hotka
| first2 = Dan
| others = Jim McDaniel
| title = Toad Handbook
| url = https://books.google.com/books?id=eKwSVQ7kiaIC
|deadurl=no |accessdate=2013-10-23
| series = Developer's Library
|date=February 2003


[[Quest Software]] acquired TOAD in October 1998.<ref>{{cite web|url=http://www.quest.com/company/acquisitions.aspx|title=Quest Software's Acquisitions|publisher=Dell Inc.|accessdate=2013-03-05|url-status=dead|archiveurl=https://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx|archivedate=2012-02-03}}</ref> Quest Software itself was acquired by [[Dell]] in 2012 to form [[Dell Software]].<ref>{{Cite press release|url=http://www.businesswire.com/news/home/20120702005389/en/Dell-Acquire-Quest-Software|title=Dell to Acquire Quest Software|website=www.businesswire.com|date=2 July 2012 |language=en|access-date=2017-11-30}}</ref><ref>{{Cite news|url=http://searchoracle.techtarget.com/news/2240159039/Quest-Software-its-Toad-tool-leaping-over-to-Dell|title=Quest Software, its Toad tool leaping over to Dell|work=SearchOracle|access-date=2017-12-06|language=en-US}}</ref> In June 2016, Dell announced the sale of their software division, including the Quest business, to [[Francisco Partners]] and [[Elliott Management Corporation]].<ref>{{Cite news|url=https://techcrunch.com/2016/06/20/confirmed-dell-sells-software-division-to-francisco-partners-and-elliott-management/|title=Confirmed: Dell sells software division to Francisco Partners and Elliott Management|last=Miller|first=Ron|work=TechCrunch|access-date=2017-11-30|language=en}}</ref> On October 31, 2016, the sale was finalized. On November 1, 2016, the sale of Dell Software to Francisco Partners and Elliott Management was completed, and the company re-launched as Quest Software.<ref>{{Cite press release|url=http://www.businesswire.com/news/home/20161101005616/en/Quest-Launches-Independent-Software-Company-Backed-Francisco|title=Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management|website=www.businesswire.com|date=November 2016 |language=en|access-date=2017-11-30}}</ref>
| publisher = [[SAMS Publishing|Sams Publishing]]
| isbn = 9780672324864
| page = xiv
| quote = I've been working on TOAD now for more than six years. Or has it been seven?
}}
</ref>
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.


== Features ==
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.
* Connection Manager - Allow users to connect natively to the vendor’s database whether on-premise or DBaaS.
* Browser - Allow users to browse all the different database/schema objects and their properties effective management.
* Editor - A way to create and maintain scripts and database code with debugging and integration with source control.
* Unit Testing (Oracle) - Ensures code is functionally tested before it is released into production.
* Static code review (Oracle) - Ensures code meets required quality level using a rules-based system.
* SQL Optimization - Provides developers with a way to tune and optimize SQL statements and database code without relying on a DBA. Advanced optimization enables DBAs to tune SQL effectively in production.
* Scalability testing and database workload replay - Ensures that database code and SQL will scale properly before it gets released into production.


== Books ==
[[Quest Software]], established in 1987, acquired TOAD in October 1998<ref>
* ''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}})
{{cite web
* ''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}})
|url = http://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx
* ''TOAD Handbook'' by Bert Scalzo and Dan Hotka, Sams, 2003 ({{ISBN|0672324865}}, {{ISBN|978-0-672-32486-4}})
|title = Quest Software's Acquisitions
* ''TOAD Handbook 2nd Edition'' by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 ({{ISBN|0321649109}}, {{ISBN|978-0-321-64910-2}}).
|publisher = Dell Inc.
* ''TOAD Handbook 2nd Edition'' by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 ({{ISBN|0321649109}}, {{ISBN|978-0-321-64910-2}}).
|accessdate = 2013-03-05
}}
</ref>
and became part of Dell in September 2012 as Dell Software.<ref name="About Quest Software – now a part of Dell">{{cite web|title=About Quest Software – now a part of Dell|url=http://web.archive.org/web/20130411222231/http://www.quest.com/company/}}</ref> In 2016, Dell Software was sold off<ref>{{Cite news|url=https://www.wsj.com/articles/dell-to-sell-software-unit-to-francisco-partners-and-elliott-1466431704|title=Dell to Sell Software Unit to Francisco Partners and Elliott Management|last=Hufford|first=Austen|date=2016-06-20|newspaper=Wall Street Journal|issn=0099-9660|access-date=2016-11-09}}</ref> and renamed back to Quest Software.<ref>{{Cite news|url=https://www.quest.com/community/news/b/press-releases/posts/quest-launches|title=Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management|newspaper=Quest Community|access-date=2016-11-09}}</ref>


== Books ==
==See also==
* [[Comparison of database tools]]
* ''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)
== References ==
* ''TOAD Handbook'' by Bert Scalzo and Dan Hotka, Sams, 2003 (ISBN 0672324865, ISBN 978-0-672-32486-4)
{{Reflist}}
* ''TOAD Handbook 2nd Edition'' by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (ISBN 0321649109, ISBN 978-0-321-64910-2).


== External links ==
==References==
* [http://www.toadworld.com/ Official Toad User Community]
<references />
* [https://www.quest.com/toad/ Quest Software Toad] company website


{{Quest Software Inc}}
==External links==
{{Authority control}}
* [http://www.ToadWorld.com/ Official Toad User Community]{{Quest Software Inc}}


[[Category:Programming tools]]
{{DEFAULTSORT:Toad (Software)}}
[[Category:Integrated development environments]]
[[Category:Desktop database application development tools]]
[[Category:Database administration tools]]
[[Category:Database administration tools]]
[[Category:PL/SQL editors]]
[[Category:PL/SQL editors]]
Line 117: Line 66:
[[Category:Sybase]]
[[Category:Sybase]]
[[Category:MySQL]]
[[Category:MySQL]]
[[Category:Computer programming tools]]

Latest revision as of 10:51, 30 April 2024

For other uses, see Toad (disambiguation).
TOAD
Original author(s)Jim McDaniel
Developer(s)Quest Software
Written inVarious (depending on the database used)
TypeDatabase management tools
LicenseProprietary
Websitehttps://www.quest.com/toad/

Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. The Toad toolset runs against Oracle, SQL Server, IBM DB2 (LUW & z/OS), SAP and MySQL. A Toad product for data preparation supports many data platforms.

History

[edit]

A practicing Oracle DBA, Jim McDaniel, designed Toad for his own use in the mid-1990s.[1] He called it Tool for Oracle Application Developers, shortened to "TOAD". McDaniel initially distributed the tool as shareware and later online as freeware.

Quest Software acquired TOAD in October 1998.[2] Quest Software itself was acquired by Dell in 2012 to form Dell Software.[3][4] In June 2016, Dell announced the sale of their software division, including the Quest business, to Francisco Partners and Elliott Management Corporation.[5] On October 31, 2016, the sale was finalized. On November 1, 2016, the sale of Dell Software to Francisco Partners and Elliott Management was completed, and the company re-launched as Quest Software.[6]

Features

[edit]
  • Connection Manager - Allow users to connect natively to the vendor’s database whether on-premise or DBaaS.
  • Browser - Allow users to browse all the different database/schema objects and their properties effective management.
  • Editor - A way to create and maintain scripts and database code with debugging and integration with source control.
  • Unit Testing (Oracle) - Ensures code is functionally tested before it is released into production.
  • Static code review (Oracle) - Ensures code meets required quality level using a rules-based system.
  • SQL Optimization - Provides developers with a way to tune and optimize SQL statements and database code without relying on a DBA. Advanced optimization enables DBAs to tune SQL effectively in production.
  • Scalability testing and database workload replay - Ensures that database code and SQL will scale properly before it gets released into production.

Books

[edit]
  • 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 Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (ISBN 0321649109, ISBN 978-0-321-64910-2).

See also

[edit]

References

[edit]
  1. ^ Scalzo, Bert; Hotka, Dan (February 2003). Toad Handbook. Developer's Library. Jim McDaniel. Sams Publishing. p. xiv. ISBN 978-0-672-32486-4. Retrieved 2013-10-23. I've been working on TOAD now for more than six years. Or has it been seven?
  2. ^ "Quest Software's Acquisitions". Dell Inc. Archived from the original on 2012-02-03. Retrieved 2013-03-05.
  3. ^ "Dell to Acquire Quest Software". www.businesswire.com (Press release). 2 July 2012. Retrieved 2017-11-30.
  4. ^ "Quest Software, its Toad tool leaping over to Dell". SearchOracle. Retrieved 2017-12-06.
  5. ^ Miller, Ron. "Confirmed: Dell sells software division to Francisco Partners and Elliott Management". TechCrunch. Retrieved 2017-11-30.
  6. ^ "Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management". www.businesswire.com (Press release). November 2016. Retrieved 2017-11-30.
[edit]
Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=Toad_(software)&oldid=1221510160"