Toad^® for Data Analysts

Version 2.1.0 

Release Notes

November 16, 2008

Contents

Welcome to Toad for Data Analysts

Toad for Data Analysts is a multi-platform database query tool built for anyone who needs to access data, understand data relationships, and quickly produce reports.

With Toad for Data Analysts, you can:

• Connect to almost any database or ODBC data source (See System Requirements)

• Write SQL queries and join data across all platforms

• Automate and schedule frequent and repetitive tasks

• Streamline data collection

• Collaborate with team members

• Export data in a variety of file formats

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

• Oracle

• SQL Server

• DB2 (LUW and z/OS)

• Sybase ASE

• 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 Teradata, Netezza, 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

New in This Release

Review the following sections for updates in this release and new features:

• General
• Understand
• Query
• Report
• Automate

General

Upgrades:

If you migrate settings during an upgrade, Toad only migrates shared reports and project manager files if you are using the default directory in the Network Settings option page (Tools | Options | Environment | Network Share). If you specified a custom network share directory, the files will not be migrated.

Performance Improvements:

• The startup code in has been optimized and the result is a much faster startup time, especially for a “warm restart”.

• The memory footprint has been reduced by optimizing the code and reducing the number of assemblies loaded.

• The editor has been optimized to provide better support for medium to large scripts. Both the load time and memory footprint for loading scripts that are approximately 10 MB has been greatly improved.

• Script output has been optimized to spool much faster and use less memory, especially in cases where large amounts of output are generated.

Connections:

Toad now supports ODBC connections to Netezza databases. For more information, see System Requirements.

Options:

• Many options that used to be managed in the Options window are now saved automatically when you close Toad. This allows increased consistency from session to session.

• Toad includes new skins, such as Office 2007 and a true Default skin that better
  matches the standard Windows look-and-feel.

 Understand

• You can now apply or remove a named filter using a drop-down beside the filter icon.

• You can now hide object toolbars and access actions via a right-click menu instead. If you want to show the toolbars again, select Show Toolbar from the right-click menu.
   

Query

Query Builder:

• You can determine the connection used by a query by placing the cursor over the Query Builder tab.

• For heterogeneous queries, you can determine the connection associated with each table or view, by placing the cursor over the table name in the Diagram pane.
   

Editor:

The Document Recovery feature is now supported when running multiple instances of Toad.
 

Report

• The Script Output and Connection Output tabs have been combined into a single Messages tab that makes finding and viewing information easier.

• Script output has been optimized to spool much faster and use less memory, especially in cases where large amounts of output are generated.

• Toad now displays output in grid and text formats.

• The Commit and Rollback toolbar icons have been moved beside the AutoCommit drop-down on the status bar. These icons are only available if Autocommit is disabled.

• You can now disable autocommit for the current editor only from the drop-down on the status bar if Autocommit is enabled. 

Automate

• Automation has a new Run Program activity that allows you to run a program or batch file with optional command-line arguments.

• The Test button in the Automation toolbar now has a keyboard shortcut (F5).

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

Back to Top

Known Issues

The following is a list of issues known to exist at the time of the Toad for Data Analysts 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 Analysts release.

Back to Top

System Requirements

Client Requirements

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

Server Requirements

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

Citrix Requirements

Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server SP2 using the MetaFrame Presentation Server 4.0 and Citrix Presentation Server Clients 10.2. For information about installing Toad in a Citrix environment, see "Install Toad on Citrix Systems" in the Toad for Data Analysts Installation Guide.

User Requirements

User Requirements to Install Toad

Only Power users and Administrators can install Toad.

Note: (DB2 only) A Power User cannot install Toad if a DB2 for LUW version earlier than 8.1.7 already exists on the computer. Only an Administrator can install Toad under this condition. However, if the computer has an existing DB2 for LUW 8.1.7 or later installation, a Power User can install Toad as long as this user belongs to the DB2ADMNS or DBUSERS group.

If an Administrator installs Toad,  the Administrator can share the Toad shortcut icon on the desktop and menu items with any user--a Power User, Restricted User, Vista standard user--on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

• Associate file extensions.

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

 User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

• (DB2 only) 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.

• (DB2 only) A Windows Vista user must be either an administrator or a standard user that belongs to an Vista Administrators group. Additionally, to enable full functionality in Toad when Vista’s User Access Control security feature is turned on, the standard user must run Toad as an administrator. (Right-click the Toad icon on the Vista desktop and select Run as administrator.) See the Release Notes for a description of the restrictions that are in place when the standard user does not run Toad as an administrator.

• (DB2 only) A Windows Power User or Restricted User does 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 in the Toad Client Configuration wizard to import catalog entries to Toad.

• (DB2 only) To use Toad to manage DB2 for z/OS subsystems, the user ID defined in the Toad connection profile to connect a specific subsystem must either have SYSADM privileges or be granted SELECT permissions on the DB2 catalog tables.

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

1. Select Control Panel from the Windows Start menu.

2. Double-click Administrative Tools.
3. Double-click Microsoft .NET Framework 2.0 Configuration.
4. Select My Computer, and then select the Runtime Security Policy node.
5. Select Evaluate Assembly from the list of tasks in the right panel and browse to the location of Toad.exe in the File field.

6. Click Next and set the permission to Unrestricted.

• To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security.

Back to Top

Global Operations

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

Back to Top

Installation

Contents of the Release Package

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

• Toad for Data Analysts 2.1.0
• Product Documentation, including:
  • Installation Guide
  • Online Help
  • Release Notes

Installation Instructions

See the Toad for Data Analysts Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for Data Analysts 2.1 | Documentation for important installation information. For information about installing Toad silently, see "Install Toad Silently" in the Toad for Data Analysts Installation Guide.

Notes:

• If you received Toad for Data Analysts with your purchase of Toad for Oracle, note that by installing Toad for Data Analysts you agree to use the software solely on the seat for which Toad for Oracle was purchased.

• 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, the Toad installation stops and cannot complete. You must upgrade to the DB2 8 client and restart the Toad installation to avoid losing functionality in some DB2 native tools.
   

Registration

If you have a commercial Toad for Oracle license key, you can enter it in the Authorization window that displays when you initially start Toad for Data Analysts to enable it. You can access the Authorization window at a later time from Toad for Data Analysts by selecting Help | Authorization from the menu.
 

Back to Top

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad for Data Analysts team and other community members. Join the Toad for Data Analysts 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

© 2008 Quest Software, Inc.

ALL RIGHTS RESERVED.

This document contains proprietary information protected by copyright. The software described in this document 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.

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

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

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, 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.

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