Transcript Quest Software Corporate Overview

Discover the Hidden
Treasures of Toad®
Bert Scalzo
Database Domain Expert
Quest Software, Inc.
Copyright © 2006 Quest Software
Today’s Agenda
• Review of Toad for Oracle (10 Quick Slides)
– Quick Facts & Brief History
• Which version you should use
– Available Editions & Bundles
• Which Edition or Bundle you should buy
– Latest Version 9.6 – but Toad 9.7 just around the corner 
• Hidden Treasures (Mostly Live Product Demo)
–
–
–
–
–
Project Manager
Application Designer
Data Import/Export
Code Xpert
Quest SQL Optimizer for Oracle
• Resources and Wrap-Up (Q&A)
Toad for Oracle
Toad for Oracle provides efficient and accurate development and
administration to Oracle database professionals of all skill and
experience levels. It is the most widely-used tool of its kind on
the market.
Quick Facts:
•
•
•
•
•
•
Quest Software has owned Toad for Oracle for 10 years
Considered the de-facto standard
Started as freeware on www.toadsoft.com
Has over one million users world wide
Has a great Yahoo Toad discussion group – free – join
Runs an open beta program to let users drive direction
Toad’s Long Pedigree
9iR2
Original Toad Freeware
Oct ‘98
June ‘99
Feb ’00
v5
V6.1
V6.3
Dec ‘00 April ‘01 Dec ‘01 Apr ‘02
v6.5
v7.2
v7.3
Script
Manager,
SQL*Loader
Wizard.
v7.4
v7.5
HTML Schema
Generator,
CMD Line
Support.
Project
Manager,
QSR.
Team Coding,
Data Grid
support for
advanced data
types.
v7.0
Initial Quest
Already has 70 Debugger, SQL DBA Module. Toad Reports.
release.
distinct
Modeler, Oracle 8
Yahoo! Groups and
screens.
object support.
Toadsoft.com
established.
Oct ‘02 May ‘03
9.2.0.8
10gR2
Nov ‘03 July ‘04
June ‘05
v7.6
v8.0
v8.5
Session
Browser,
new
toolbars.
XML Support,
CodeXpert,
Script Debugger.
Rebranded –
Toad for Oracle
JIT Debugging,
Citrix, RAC,
enhanced 10g
support.
10.2.0.4
11gR1
Toad for Oracle Freeware
Update July ‘05
Oct ’05
Oct ’06
Jun ’07
v8.6
v9.0
v9.1
Nov ’07
v9.5
Policy Manager. Integration with
Action Recall. SQL Optimizer 7.2
Debugger, Profiler,
Toad Tips
Code Xpert
Vista support.
CodeXpert
enhancements.
integration.
StatsPack Browser
ASM, ADDM, AWR
Oracle 11g
Mgt
support.
Single Merged
Re-designed
Editor.
Modeler, M/D Brower,
New Reporting Engine. Improved
Please note that any future plans represent our intentions as of the date hereof, and our development plans and
priorities are subject to change due to competitive factors, availability of resources and other matters common to all
independent software vendors. Accordingly, these general indications of development schedules should not be relied
upon if making a purchasing decision and should not be interpreted or construed as any form of a commitment that
Quest will ultimately release any or all of the above-described products or features on the schedule or in the order
described, or at all. The content, release, and timing of any features or functionality described above remains at the
sole discretion of Quest Software, Inc.
12 July 2007
Apr ’08
v9.6
Debugger into
Standard, Schema
Browser merged
with DB Browser,
integration with
QCTO and TDM,
Vulnerability
Assessment in
Health Check
Toad for Oracle 9.6 Developer Bundles
Toad for Oracle
The development tool of
choice for database
professionals world wide.
Toad for Oracle is the
essential tool for an
Oracle developer to
perform daily tasks
efficiently and accurately.
New for Toad for Oracle
9.6:
• PL/SQL debugger
• Knowledge Xpert for
PL/SQL and Oracle
Administration
•Simplified customization
• Improved PL/SQL
Profiler
Toad for Oracle
Professional
Built for developers that
focus on building code for
quality and
maintainability.
Includes all functionality
in the Toad for Oracle
base edition, plus:
• Code Xpert
• Export File Browser
New for Toad for Oracle
9.6:
• Import/Export utility
wizards
• Code Xpert – updated to
simplify reporting; plus
new “Toad Code Rating”
– green, yellow, red
Toad for Oracle Xpert
Designed for developers
with SQL tuning
responsibilities that need
to ensure optimal
database performance
Includes functionality in
Toad for Oracle
Professional, plus Quest
SQL Optimizer for Oracle,
which includes:
• SQL Scanner
• Virtual Index Generator
New for Toad for Oracle
9.6 – SQL Optimizer 7.3
• Integration with
Benchmark Factory
• Users can select where
code is tuned (SQL Lab
or Batch Optimizer)
• Users can use a “Plan”
table from a different
schema
Toad Development
Suite for Oracle
Enables Database
Development Best
Practices and ensures
that the best possible
code is deployed to
production.
Integrated suite of three
tools:
• Toad for Oracle Xpert
• Quest Code Tester for
Oracle
•Benchmark Factory for
Databases Oracle Edition
New for Toad for Oracle
9.6:
• Greater workflow
integration with Quest
Code Tester for Oracle 1.8
New for Quest Code
Tester for Oracle 1.8
• User Interface
enhancements
Toad for Oracle 9.6 DBA Bundles
Toad for Oracle DB Admin
Module (formerly DBA Module)
Maintain database health and stability and
ensure the best possible performance,
while minimizing the impact of changes to
the database environment.
New for Toad for Oracle 9.6:
Check: Vulnerability Assessment
• AWR Browser
• Enhanced DB Browser
• Flashback archives for Oracle 11g
• Health
Toad DBA Suite for Oracle
Simplifies common database administration
and helps you become more proactive in
solving database-related performance issues
before end users are impacted.
The suite includes: Toad for Oracle Xpert,
with DB Admin Module;
Spotlight on Oracle Standard Edition; Toad
Data Modeler; Benchmark Factory for
Databases Oracle Edition
New for Toad for Oracle 9.6:
• Tighter workflow integration with Toad Data
Modeler
New for Toad Data Modeler 3.1
• Live reverse engineering making it easier to
add entities to models
• Generate alter reports that include changes
between two models from the Convertor and
Comparator dialogs
• Import models from Toad Data Modeler 2.0
• The DB Admin Module must be purchased with or added onto another edition of Toad for Oracle.
Toad for Oracle 9.6 Bundle Updates
Base Edition
• Debugging moved to base edition (this includes DBMS, JDWP,
External and SQL*Plus Script debugging)
• Knowledge Xpert for PL/SQL moved to base edition
• Knowledge Xpert for DBA moved to base edition
Professional Edition
• Oracle Import Utility moved to Pro (still in DB Admin module)
• Oracle Export Utility moved to Pro (still in DB Admin module)
DBA Module
• Now called the DB Admin Module
7
Toad for Oracle 9.6 Functionality Updates
Base Edition
•
•
•
•
Improved initial setup
Toolbar/Menu customization
Code Editor Insight updates
Profiler Analysis updates
DB Admin Module
•
•
•
•
Database Browser updates
Vulnerability Assessment added to database Health Check
AWR Browser
Additional support for 11g (Flashback archives)
Integration with other Quest Products
•
•
•
Quest Code Tester for Oracle 1.8
Toad Data Modeler 3.1
Quest SQL Optimizer for Oracle 7.3
– Select way in which you want to optimize
– Batch optimizer enhancements and new options
8
Toad for Oracle 9.7 work is wrapping up 
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Parser Updates (Base)
Data Generation (Professional)
Action Recall enhancements (Base)
Code Xpert enhancements (Professional)
Database Browser (DB Admin Module)
RMAN Scripting Templates (DB Admin Module)
Stats Pack and AWR Advisories (DB Admin Module)
Trace File Browser (DB Admin Module)
Schema Compare enhancements (Base – basic compare & DB Admin
Module – Compare using Def Files & Sync)
Integration (Dev Suite & DBA Suite)
Benchmark Factory
Subversion support (Base)
Getting Started videos (Base)
Oracle Licensing notification
Window disabling
Oracle Version check
Toad Customer User files
Now it’s Time to
Discover the
Hidden Treasures
of Toad®
Project Manager
• Share project assets such as templates,
scripts, and code snippets
• Maintain code consistency
• Ensure adherence to standardization
and formatting
Application Designer
• In 9.6 feature introduced as
Action Palette, but then in 9.7
renamed to App Designer
• Record workflow steps in Toad
and store for future use
• Recall actions for execution
and modification
• Schedule actions to run
automatically
Data Import/Export
• Extract objects and data subsets from an Oracle export file
• Reduces need to import an entire Oracle export file
• Decreases program errors and saves time
Code Xpert
• Automate the process of performing objective code quality
reviews
• Check code against a pre-defined set of rules
• Help ensure database development best practices are followed
Quest SQL Optimizer for Oracle
•
•
Automate the SQL optimization process and generate replacement SQL
Analyze indexing strategy & perform Index Impact Analysis
Resources and Next Steps
•
Toad World: www.toadworld.com
– Blogs, articles, tips and tricks, special offers
•
Technical Briefs
– Implementing Database Development Best Practices for Oracle
– What's New in Toad for Oracle 9.6
•
White Papers
– Discover the Hidden Treasures of Toad
– Engineering Better PL/SQL for Simpler, More Effective Database
Applications
– Simplifying Oracle Database Administration
– The Oracle Database Administrator of Tomorrow: The Impact of New
Technologies
– Maximize DB Performance via Toad
•
Trial Downloads: http://www.quest.com/toad-for-oracle/software-downloads.aspx
Thank you
Presenter: John Pocknell
E-mail: [email protected]