Toad^® for Data Analysis

Version 1.1.1 (Click here for previous versions)

Release Notes

February 2008

Contents

Welcome to Toad for Data Analysis

Toad for Data Analysis is a multi-platform database tool designed for IT and Businesses that need to investigate and analyze their data. It empowers effective decision making by providing insight into business data, allows users to access and understand their data from any source, and streamlines the process of data collection ensuring the right information is delivered on time.

Toad for Data Analysis provides a full featured ER Diagrammer, Database Browser, Query Builder, and Editor for the following databases:

• Oracle

• SQL Server

• DB2 (LUW and z/OS)

• MySQL

Most companies have additional databases that they need to connect to and query. To help achieve this, Toad provides basic connectivity, querying, and reporting functionality using the Microsoft Excel, Microsoft Access, and ODBC providers. The inclusion of these additional providers should address the reporting requirements for most companies.

The purpose of the ODBC provider is to offer basic connection and querying capabilities to any database that supports an ODBC 3.0 or later driver. For a list of databases tested with the ODBC provider, see the System Requirements. This form of connectivity allows connections to databases such as Sybase, Teradata, IBM iSeries, and Ingres. Because this form of connectivity is generic, it is not full-featured and may not be as robust as the fully exploited providers for the other databases.

Back to Top

Key Features in This Release

Toad for Data Analysis provides tools that help you succeed in your query and reporting goals. Many of these tools are considered Best Practices and are beneficial for individual users as well as managers. Key features can be grouped into the following categories.
 

Updates to Toad for Data Analysis 1.1.0

General

• Performance Improvements―We are excited to announce major memory improvements for queries that return large result sets in the Editor result sets and the Database Browser Data tab! The memory only increases by a couple of megabytes initially regardless of the size of the result set. Subsequent scrolling of the result set only reads into memory what is needed to display.

• Default window to open when connecting—A separate window no longer prompts you to associate a default window to open when initially connecting to Toad. You now specify the default window to open in the Configuration wizard.
  
  
   

Understand

• Generate SQL drop script―You can now select Drop Script from the Generate SQL right-click menu in the Database Browser or Object Palette.
  
  
   

• Generate SQL retains Formatter settings―When using the right-click menu to generate SQL in the Database Browser or Object Palette, the settings specified in the Formatter Options pages are now retained.

Query

• Query Builder:
  • Heterogeneous query support―You can now add tables and views from multiple databases to create a query that combines the generated results.
  • From clause subquery support―You can now add a subquery to a From Clause using the Query Builder toolbar or the right-click menu. A Queries panel displays on the left side of the window with the From Clause subquery. You can add tables and views and create joins the same way you normally use the Query Builder.
    
    After creating the subquery, click the parent query in the Queries panel to return to the original query. A From Clause Subquery table now displays in the Diagram panel with all the columns in the subquery. Use this new table as you would any other database object.
    
    
     
  • Date ranges―When you add a Where condition for a column that uses a DateTime data type, a new Date Range tab displays in the Where Condition window. The Date Range tab allows you to select a plain text tag such as, “Today,” “Last week,” “Last 30 days,” and “Current year.” The tag you select is added to the Where condition of your query and when executed, is substituted with a BETWEEN command using the appropriate date range. Date Range tags can also be used in the Editor so you can create queries manually.
    
    Date Range tags are also useful when executing SQL statements from Automation. You no longer have to edit regularly executed queries to change a date range when you need to retrieve data every month for the previous month. 
    
    
     
• Editor:
  • View scripts in a full size window―Use docking controls to auto-hide or group the Editor panel, Code Navigator, and result sets. To display the Editor and Results panels in a separate, full size window, drag-and-drop the Results tab into the Editor window.
    
    
    
    Press F6 to switch between the two panels.
    
    
     
  • Error line highlighting―Ability to highlight the line in the Editor that caused an execution error. To do this, double-click the error message in the Script Output tab.
  • Change case and add comments―You can now change the case of text or comment or uncomment a line by selecting Editor | Advanced or from the Editor's right-click menu.
    
    
• Query Results:
  • Grid customization―You can now customize the grid style when a skin is applied to Toad. You can modify this setting in the Configuration wizard (Tools | Configuration Wizard) or in Interface Options (Tools | Options | Environment | Interface).
    
    

  • Read-only data―You can now set an option to make all data grids read-only by default.
    
    
     

  • Search data―Ability to search data grids for word or phrase matches by pressing CTRL+F. Clicking Mark All in the Find window highlights all cells in the grid that match the find criteria.
    
    
     

• Version Control―Added support for the following additional version control providers:

  • Subversion

  • CVS
     

Back to Top
 

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad for Data Analysis:

• Resolved issues and enhancements in 1.1.1

• Resolved issues and enhancements in 1.1.0
   

Resolved Issues and Enhancements in 1.1.1

Resolved Issues and Enhancements in 1.1.0

Back to Top

Known Issues

The following is a list of issues known to exist at the time of Toad for Data Analysis release.

Back to Top

Third Party Known Issues

The following is a list of third party issues known to exist at the time of Toad for Data Analysis release.

Back to Top

System Requirements

Client Requirements

Before installing Toad for Data Analysis, ensure your client system meets the following minimum hardware and software requirements:

Server Requirements

Before installing Toad for Data Analysis, ensure your server meets the following minimum hardware and software requirements:

User Privilege Requirements

The following user privileges are required for installing and running Toad for Data Analysis:

• Only Power users and Administrators can install Toad.

• If a Power user installs Toad, a Restricted user can run the application but cannot

  • Associate file extensions.

  • See the Toad shortcut icon on the desktop or the Toad menu option in the Windows Start menu. As a workaround, Restricted users can create a shortcut to the application and place it on their desktop from the install directory.

• If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and the Toad menu option in the Windows Start menu with any user on the computer.

• A Power User or Restricted User must belong to the DB2ADMNS or DB2USERS group. To add the user to one of these groups, select Start | Control Panel | Administrative Tools | Computer Management | System Tools | Local Users and Groups | Groups | DB2ADMNS or DB2USERS.

• In order to use Toad with DB2 for z/OS, any user who does not have SYSADM privileges must be granted SELECT permissions on the DB2 catalog tables.

• In order to run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

1. From the Windows Start menu, select Settings | Control Panel.

2. Double-click Administrative Tools.
3. Double-click Microsoft .NET Framework 2.0 Configuration.
4. Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.
5. Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.
6. Browse to the location of Toad.exe in the File field.
7. Click Next to view permissions for Toad.exe.
8. Set the permission to Unrestricted.

• In order to set or modify Toad Security settings, users must have privileges to create the QuestSoftware.ToadSecurity table if it does not exist. If the table does exist, users must have privileges to insert, update, and delete the QuestSoftware.ToadSecurity table.

• Power users and Restricted users do not have the authority to add or remove DB2 catalog entries using the Toad Client Configuration wizard. However, these users can use the Import Profile function to import catalog entries to Toad.
   

Citrix Requirements

Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server Service Pack 2 using the Metaframe Access Suite 3.0 and Citrix Presentation Server Clients 10.0. For information about installing Toad in a Citrix environment, see Install Toad on Citrix Systems in the Toad for Data Analysis Getting Started Guide.
 

Silent Install Requirements

Before you perform a silent installation, the following software must be installed on every system on which you are installing Toad:

• Microsoft .NET Framework 2.0 or later

• (SQL Server native provider only) Microsoft SQL-DMO

• (DB2 native provider only) Toad installs a DB2 9 client as part of the installation process. The DB2 9 client can co-exist with an existing DB2 8 client; however, it is incompatible with a DB2 7 client. If a DB2 7 client is already installed on the system where you are installing Toad, you must upgrade to the DB2 8 client before installing Toad to avoid losing functionality in some DB2 native tools.

For information about installing Toad silently, see Install Toad Silently in the Toad for Data Analysis Getting Started Guide.
 

Back to Top

Global Operations

For more information, see http://tda.inside.quest.com/shares/tda/sbin/docs/GlobalOps.htm

Back to Top

Getting Started

Contents of the Release Package

The Toad for Data Analysis release package contains the following products:

• Toad for Data Analysis 1.1.1
• Product Documentation, including:
  • Getting Started Guide
  • Online Help
  • Release Notes

Installation Instructions

For important installation information, see the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for Data Analysis 1.1 | Documentation.

Back to Top

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad for Data Analysis team and other community members. Join the Toad for Data Analysis community at http://tda.inside.quest.com/forumindex.jspa?categoryID=144.

Contact Quest Software:

Refer to our web site for regional and international office information.

Contact Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract. Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

• Quickly find thousands of solutions (Knowledgebase articles/documents).
• Download patches and upgrades.
• Seek help from a Support engineer.
• Log and update your case, and check its status.

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures. The guide is available at: http://support.quest.com/pdfs/Global Support Guide.pdf.

Back to Top

This document 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.

© 2008 Quest Software, Inc. ALL RIGHTS RESERVED.

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

If you have any questions regarding your potential use of this material, contact:

Disclaimer

The information in this document is provided in connection with Quest 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 products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST 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 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 HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest 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 does not make any commitment to update the information contained in this document.

Back to Top