Jump to content

Toad (software): Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
m Fixed grammatical errors
trim
Line 20: Line 20:
}}
}}


⚫
'''Toad''' is a [[Database Management|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]]. There are Toad products for developers and [[Database administrator|DBA]]<nowiki/>s, which run on [[Oracle Database|Oracle]], [[SQL Server]], [[IBM Db2|IBM DB2]] (LUW & z/OS), [[Adaptive Server Enterprise|SAP]] and MySQL, as well as, a Toad product for data preparation, which supports most data platforms. Toad solutions enable data professionals to automate processes, minimize risks, and cut project delivery timelines.
== Overview ==
⚫
Toad Software is a [[Database Management|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]]. There are Toad products for developers and [[Database administrator|DBA]]<nowiki/>s, which run on [[Oracle Database|Oracle]], [[SQL Server]], [[IBM Db2|IBM DB2]] (LUW & z/OS), [[Adaptive Server Enterprise|SAP]] and MySQL, as well as, a Toad product for data preparation, which supports most data platforms. Toad solutions enable data professionals to automate processes, minimize risks, and cut project delivery timelines.


== History ==
== History ==
[http://www.oreilly.com/pub/au/937 Jim McDaniel] (aka "TOADman"), a practicing Oracle DBA, originally designed Toad for his own use in the late 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=9780672324864|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|deadurl=no}}
Jim McDaniel (aka "TOADman"), a practicing Oracle DBA, originally designed Toad for his own use in the late 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|deadurl=no}}</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.
</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.


As the user base grew, so did the effort of maintenance and development. Finally, McDaniel realized that he could no longer dedicate substantial amounts of time to the growing quantity of software enhancement requests.
As the user base grew, so did the effort of maintenance and development. Finally, McDaniel 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.<ref>{{cite web|url=https://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx|title=Quest Software's Acquisitions|publisher=Dell Inc.|accessdate=2013-03-05}}</ref> Quest Software was acquired by [[Dell]] in 2012 to form [[Dell Software]].<ref>{{Cite web|url=http://www.businesswire.com/news/home/20120702005389/en/Dell-Acquire-Quest-Software|title=Dell to Acquire Quest Software|website=www.businesswire.com|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 web|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|language=en|access-date=2017-11-30}}</ref> Toad products are currently part of the Quest Software portfolio.
[[Quest Software]], established in 1987, acquired TOAD in October 1998.<ref>{{cite web|url=https://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx|title=Quest Software's Acquisitions|publisher=Dell Inc.|accessdate=2013-03-05}}
⚫
</ref> Quest Software was acquired by [[Dell]] in 2012 to form [[Dell Software]].<ref>{{Cite web|url=http://www.businesswire.com/news/home/20120702005389/en/Dell-Acquire-Quest-Software|title=Dell to Acquire Quest Software|website=www.businesswire.com|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 web|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|language=en|access-date=2017-11-30}}</ref> Toad products are currently part of the Quest Software portfolio.


== Offerings/Features ==
== Features ==
* '''Connection Manager -''' Allow users to connect natively to the vendor’s database whether on-premise or DBaaS.
* 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.
* 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.
* 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.
* 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.
* 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.
* 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.
* Scalability testing and database workload replay - Ensures that database code and SQL will scale properly before it gets released into production.

=== '''Version History''' ===
{| class="wikitable"
!Version
!Full Support as of
|-
|12.12
|10/12/2017
|-
|12.11
|7/13/2017
|-
|12.10
|9/29/2016
|-
|12.9
|6/16/2016
|-
|12.8
|11/3/2015
|-
|12.7
|6/16/2015
|-
|12.6
|9/25/2014
|}

=== '''Related Software''' ===
[[Oracle Database|Oracle]], [[SQL servers|SQL Server]], [[IBM Db2|IBM DB2]] (LUW & z/OS), [[SAP (software)|SAP]] and [[MySQL]]


== Awards and Honors ==
== Awards and Honors ==
Line 78: Line 45:
!Reference
!Reference
|-
|-
! colspan="4" | '''Awards won as Quest Software (QSFT)'''
! colspan="4" | Awards won as Quest Software (QSFT)
|-
|-
|SQL Server Magazine Editor’s Best Award – Best Database Development Tool
|SQL Server Magazine Editor’s Best Award – Best Database Development Tool
|2009
|2009
|Toad for SQL Server - Gold
|Toad for SQL Server – Gold
|<ref>{{Cite news|url=http://www.itprotoday.com/business-intelligence/2009-sql-server-magazine-editors-best-and-community-choice-awards|title=2009 SQL Server Magazine Editors' Best and Community Choice Awards|date=2009-11-18|work=IT Pro|access-date=2017-11-30}}</ref>
|<ref>{{Cite news|url=http://www.itprotoday.com/business-intelligence/2009-sql-server-magazine-editors-best-and-community-choice-awards|title=2009 SQL Server Magazine Editors' Best and Community Choice Awards|date=2009-11-18|work=IT Pro|access-date=2017-11-30}}</ref>
|-
|-
|Windows IT Pro’s Community Choice & SQL Server Magazine Editor’s Best Awards - Best Database Development Tool
|Windows IT Pro’s Community Choice & SQL Server Magazine Editor’s Best Awards – Best Database Development Tool
|2011
|2011
|Toad for SQL Server – Gold/Silver
|Toad for SQL Server – Gold/Silver
|<ref>{{Cite news|url=http://www.itprotoday.com/microsoft-sql-server/2011-sql-server-magazine-editors-best-and-community-choice-awards|title=2011 SQL Server Magazine Editors' Best and Community Choice Awards|date=2011-11-18|work=IT Pro|access-date=2017-11-30}}</ref><ref>{{Cite news|url=https://www.thestreet.com/story/11334839/1/quest-software-sweeps-2011-windows-it-pro-and-sql-server-magazine-awards-with-13-wins.html|title=Quest Software Sweeps 2011 Windows IT Pro And SQL Server Magazine Awards With 13 Wins|last=Wire|first=Business|date=2011-12-06|work=TheStreet|access-date=2017-11-30|language=en-US}}</ref>
|<ref>{{Cite news|url=http://www.itprotoday.com/microsoft-sql-server/2011-sql-server-magazine-editors-best-and-community-choice-awards|title=2011 SQL Server Magazine Editors' Best and Community Choice Awards|date=2011-11-18|work=IT Pro|access-date=2017-11-30}}</ref><ref>{{Cite news|url=https://www.thestreet.com/story/11334839/1/quest-software-sweeps-2011-windows-it-pro-and-sql-server-magazine-awards-with-13-wins.html|title=Quest Software Sweeps 2011 Windows IT Pro And SQL Server Magazine Awards With 13 Wins|last=Wire|first=Business|date=2011-12-06|work=TheStreet|access-date=2017-11-30|language=en-US}}</ref>
|-
|-
! colspan="4" | '''Awards won as Dell Software'''
! colspan="4" | Awards won as Dell Software
|-
|-
|SQL Server Pro Editors' Best and Community Choice Awards - Best Database Development Product
|SQL Server Pro Editors' Best and Community Choice Awards – Best Database Development Product
|2012
|2012
|Toad for SQL Server
|Toad for SQL Server
|<ref name=":0">{{Cite news|url=http://www.itprotoday.com/microsoft-sql-server/2012-sql-server-pro-editors-best-and-community-choice-awards|title=2012 SQL Server Pro Editors' Best and Community Choice Awards|date=2012-11-19|work=IT Pro|access-date=2017-11-30}}</ref>
|<ref name=":0">{{Cite news|url=http://www.itprotoday.com/microsoft-sql-server/2012-sql-server-pro-editors-best-and-community-choice-awards|title=2012 SQL Server Pro Editors' Best and Community Choice Awards|date=2012-11-19|work=IT Pro|access-date=2017-11-30}}</ref>
|-
|-
|SQL Server Pro Editors' Best and Community Choice Awards - Best Database Management Product 
|SQL Server Pro Editors' Best and Community Choice Awards – Best Database Management Product
|2012
|2012
|Toad for SQL Server
|Toad for SQL Server
Line 132: Line 99:
* [[ODBC]] generic
* [[ODBC]] generic
* [[Oracle Corporation|Oracle]] databases running on Amazon EC2
* [[Oracle Corporation|Oracle]] databases running on Amazon EC2
* Oracle Business Intelligence Enterprise Edition
* Oracle Business Intelligence Enterprise Edition
* [[Oracle Database|Oracle]]
* [[Oracle Database|Oracle]]
* Oracle databases running in the Oracle Database Cloud Service
* Oracle databases running in the Oracle Database Cloud Service
* [[PostgreSQL]]
* [[PostgreSQL]]
* [[salesforce]]
* [[salesforce]]
* SAP® Business Objects
* SAP® Business Objects
* SAP Sybase ASE
* SAP Sybase ASE
* SAP Sybase IQ
* SAP Sybase IQ
* SAP Sybase SQL Anywhere
* SAP Sybase SQL Anywhere
* [[Teradata]]
* [[Teradata]]
* [[Vertica]]
* [[Vertica]]
Line 153: Line 120:
* ''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}}).


==References==
== References ==
<references />
<references />


==External links==
== External links ==
* [http://www.ToadWorld.com/ Official Toad User Community]
* [http://www.toadworld.com/ Official Toad User Community]
* [https://www.quest.com/toad/ Quest Software Toad] company website
* [https://www.quest.com/toad/ Quest Software Toad] company website
{{Quest Software Inc}}
{{Quest Software Inc}}


{{DEFAULTSORT:Toad (Software)}}
[[Category:Computer programming tools]]
[[Category:Computer programming tools]]
[[Category:Integrated development environments]]
[[Category:Integrated development environments]]

Revision as of 05:58, 18 December 2017

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 that database developers, database administrators, and data analysts use to manage both relational and non-relational databases using SQL. There are Toad products for developers and DBAs, which run on Oracle, SQL Server, IBM DB2 (LUW & z/OS), SAP and MySQL, as well as, a Toad product for data preparation, which supports most data platforms. Toad solutions enable data professionals to automate processes, minimize risks, and cut project delivery timelines.

History

Jim McDaniel (aka "TOADman"), a practicing Oracle DBA, originally designed Toad for his own use in the late 1990s.[1] 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, McDaniel 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.[2] Quest Software 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] Toad products are currently part of the Quest Software portfolio.

Features

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

Awards and Honors

Name of of Award/Recognition Year Won Product Reference
Awards won as Quest Software (QSFT)
SQL Server Magazine Editor’s Best Award – Best Database Development Tool 2009 Toad for SQL Server – Gold [7]
Windows IT Pro’s Community Choice & SQL Server Magazine Editor’s Best Awards – Best Database Development Tool 2011 Toad for SQL Server – Gold/Silver [8][9]
Awards won as Dell Software
SQL Server Pro Editors' Best and Community Choice Awards – Best Database Development Product 2012 Toad for SQL Server [10]
SQL Server Pro Editors' Best and Community Choice Awards – Best Database Management Product 2012 Toad for SQL Server [10]

Supported databases and environments

Toad supports the following databases and environments:

Toad runs on all 32-bit/64-bit Windows platforms, including Microsoft Windows Server, Windows XP, Windows Vista, and Windows 7 and 8 (32-Bit or 64-Bit). Quest Software has also released a Toad Mac Edition. Quest Software provides Toad in commercial and trial/freeware versions. The Freeware version is available from the ToadWorld.com community.[11]

Books

  • 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).

References

  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? {{cite book}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  2. ^ "Quest Software's Acquisitions". Dell Inc. Retrieved 2013-03-05.
  3. ^ "Dell to Acquire Quest Software". www.businesswire.com. 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. Retrieved 2017-11-30.
  7. ^ "2009 SQL Server Magazine Editors' Best and Community Choice Awards". IT Pro. 2009-11-18. Retrieved 2017-11-30.
  8. ^ "2011 SQL Server Magazine Editors' Best and Community Choice Awards". IT Pro. 2011-11-18. Retrieved 2017-11-30.
  9. ^ Wire, Business (2011-12-06). "Quest Software Sweeps 2011 Windows IT Pro And SQL Server Magazine Awards With 13 Wins". TheStreet. Retrieved 2017-11-30. {{cite news}}: |first= has generic name (help)
  10. ^ a b "2012 SQL Server Pro Editors' Best and Community Choice Awards". IT Pro. 2012-11-19. Retrieved 2017-11-30.
  11. ^ "Toad World". Dell Software Inc. 2016.
Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=Toad_(software)&oldid=815941961"