Toad® for Data Analysts

Version 2.5.1   

Release Notes

December 17, 2009


Contents

Welcome to Toad for Data Analysts

New in This Release Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Global Operations

Installation

For More Information

 


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:

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

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.


New in This Release (2.5.0)

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

General

Prerequisites/Installation

Connections

Understand

Database Navigation

Master Detail Browser

When sending tables or views to the Master Detail Browser, Toad now automatically selects all columns.

Query

Query Builder

Editor

Version Control

See the Installation Guide or Toad help for step-by-step configuration information for each version control provider.

  • Support for Team Foundation Server (TFS) 2008.
  • When configuring TFS, you can now specify a user name and password to log into TFS instead of using your Windows credentials.
  • Improved handling of working directory initialization and handling of root folder and working directory.
  • Support for multiple version control configurations that are active simultaneously.

Report

Export Wizard

Import Wizard

For DB2, you can specify a tablespace when importing data into a new table.

Data Compare 

  • Data Compare supports Access and ODBC connections in this release.

    Note: Data Compare has been tested with the following ODBC connections: Excel, Netezza, Oracle, and SQL Server.
    Sybase ASE (native provider) and PostgreSQL ODBC connections are not supported in this release.
     

  • You can right-click tables or views in the Object Explorer and select Compare Data to compare data within the context of the current connection and database.

  • When comparing data, you can now auto-map target columns for selected source tables.

  • When selecting a record, Data Compare automatically displays a side-by-side comparison of the values of the source and target row in the Row Viewer tab.

  • When synchronizing a script, Data Compare now opens a script in Toad using an existing connection.

Automate

Tools

FTP

  • You can use the new File Transfer Protocol (FTP) utility to transfer scripts, reports, or other files from Toad. Toad supports unsecured (FTP) and secure (SFTP) file transfers. To open this utility, select View | FTP Connections from the menu.
     
    Right-click one or more files in the local or remote directory to upload, download, delete, or rename the files. You can also add an FTP connection in the Project Manager or as an activity in an Automation script.

Project Management

Support for FTP connections, SQL Recall named SQL statements, and Database connections has been added to the Project Manager via the right-click menu. For Database connections, only databases that are currently connected can be added to the Project Manager.

 

 


Resolved Issues and Enhancements

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

Resolved Issues and Enhancements in 2.5.1

Feature

Platform

Resolved Issue

Defect

Installation

 

Toad for Oracle Bundles

Toad for Data Analysts is now enabled when you enter a Toad for Oracle key with RAC support.

ST67813

1)      Toad for Data Analysts now correctly validates the license key against the productlicense.xml file.

ST66326

Connections

Netezza

When connecting to Netezza using the ODBC 4.05.02.8098 driver, if a session timeout occurs Toad for Data Analysts now detects the disconnect and automatically reconnects the session.

ST68727

Automation

Oracle

When adding an Export Wizard activity to an Automation script, the script no longer fails if a user profile limits you to running three sessions.

ST67621

Data

ODBC

An exception error no longer occurs when viewing columns that have a decimal data type. 

ST67716

Resolved Issues and Enhancements in 2.5.0

Feature

Platform

Resolved Issue

Defect

Installation

All

You can now install Toad on Windows Vista without performing a silent install.

ST48360

General

ODBC

Toad now logs more information needed to help troubleshoot a support bundle, such as ODBC conformance levels, support functions, etc.

ST52998

Connections

All

The following issues have been resolved:

  • Right-clicking a connection and selecting Service | Manager no longer results in an error.

  • When auto-commit is disabled, clicking a Commit or Rollback toolbar button now displays a success or failure message in the status bar.

ST63119

ST55971

Oracle

The following issues have been resolved:

  • If the Oracle password expires and you enter a new password in Toad, the next time you connect, the updated password is now used.

  • Setting auto-connect on startup for two or more databases no longer results in an error.

ST65179

ST60832

Automation

All

The following Automation issues have been resolved for all platforms:

  • Attempting to generate a PDF from Automation with Japanese Unicode characters no longer results in a "This font is currently not supported" error message.

  • You can now customize file names by including a variable in the file name or automatically including the date that the automation script ran.

  • You can now include a variable when copying or emailing files.

  • An error no longer occurs when archiving a file.

ST53862

ST57547

ST49269

ST58587

Excel

When exporting to an Excel file using an Export Template, you can now select the Add Excel worksheet if row limit reached checkbox on the Select Excel Output Options page of the Export wizard.

ST43626

ODBC

If you are using a driver version lower than the minimum required, you are notified when starting Toad. However, the automation script now runs without notifying you of the driver requirement.

ST61691

Data

All

The hexadecimal value for binary data now displays in the grid.

Note: The data that is converted into a hexadecimal value is limited to 255 bytes to prevent errors if the binary data is too large.

ST50955

Access

Viewing data on the Data tab of the Database Explorer no longer results in an error.

ST55979

Data Compare

All

The following issues have been resolved for all platforms:

  • Navigating through the results after comparing data no longer results in an error. 

  • Comparing data against tables that were exported from one schema and imported to another schema no longer results in the primary key being incorrectly assigned to certain tables.

ST55807

ST63438

SQL Server

An incorrect DELETE statement is no longer generated when a row has a blank rather than NULL value.

ST63434

Database Explorer/ Object Explorer

Oracle

The following Oracle issues have been resolved:

  • When altering a view that contains Unicode characters the script now displays correctly.

  • For Oracle 9i only, an ora-00942 error no longer displays when attempting to view a package when logged in as a limited user.

  • For Oracle 9i only, you can enter an * in the select database filter in the Object Explorer to display all tables in all schemas.

ST57626

ST62387

ST51041

ODBC

You can now add a descriptive comment to a table. To add a comment, open the Editor window and enter the following command:

Use

comment on table <TableName> is ‘Enter your description here’;

ST51633

ODBC-Progress DB

Tables now display in the Object Explorer when connected to a Progress DB.

ST56001

SQL Server

Log shipping databases now display in the Object Explorer.

ST56665

Sybase

The correct table owner now displays in the Object Explorer.

ST62692

Editor

All

(Windows Vista only) When entering a Date value in the Set Bind Variables window, the Calendar now displays correctly.

ST64257

The following code completion issues have been resolved:

  • Aliases and temp tables are now supported.

  • The delay for displaying the Code Completion list has been reduced from 500 ms to 250 ms.

ST59056

ST63366

Access

You can now format SQL when connected to Microsoft Access.

ST49032

MySQL

When executing large queries, you can now successfully kill the process.

ST61134

Oracle

The following Oracle issues have been resolved:

  • Executing a trigger in some instances no longer results in an error.

  • You can now execute a store procedure when connected using Oracle Direct Connect.

ST60125

ST58865

Explain Plan

All

Attempting to view an explain plan after executing a multi-join query no longer results in an error.

ST57455

Export Wizard/ One Click Export

Access

You can export any table or result set to an Access database file including *.mdb and *.accdb formats in the Export wizard.

ST49407

ST53887

DB2

In some regional settings, the decimal fields are no longer separated by a comma instead of a dot when exporting data as SQL Script with the Export Wizard

ST61815

Oracle

Oracle does not support exporting to multiple target tables, so this option has been removed from the Select Target page in the Export wizard.

ST56997

Import Wizard

Access

You can import any table or result set from an Access 2007 database file including *.mdb and *.accdb formats.

ST53887

Oracle

Importing a delimited file with a Timestamp data type to an Oracle table correctly imports the rows.

 

ST63525

Job Manager

All

The Job Manager no longer collapses job entries after executing a job.

ST56241

Object Search

Oracle 10g

Object Search now searches for packages in both objects and the source code.

ST60231

Query Builder

All

The following issues have been resolved for all platforms:

  • You can now sort columns alphabetically in the Diagram pane by selecting an option from the Sort columns in diagram by name drop-down list in Tools | Options | Database | Query Builder.

  • Query Builder files no longer include the user information so they can now be opened by other users.

  • The Query Builder now includes a toolbar button that adds relational operators, such as MINUS, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL, UNION, UNION ALL, and UNION DISTINCT to a query. The available operators vary based on the database provider.

  • After adding objects to the Query Builder, you can no longer change the connection associated with those objects.

  • Update and Delete statements now include the Where clause in the Generated Query tab.

ST53260

ST59771

ST58036

ST54991

ST44655

ST58344
 

Access

You can now add Access objects in the Diagram area of the Query Builder.

ST58077

Oracle

If connections to multiple database platforms are open and you execute an Oracle query, selecting the Explain Plan tab and later selecting the tab a second time results in an “ORA-01435 user does not exist" error message.

ST55494

Reports

All

The pivot grid now displays when added to a data report and executed.

ST62271

SQL Recall

All

The right-click menu and drag-and-drop functionality has been removed from the Executed tab in SQL Recall.

ST56493


Known Issues

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

Feature

Platform

Known Issue

Defect

Installation/Upgrade

All

Customized options selected in the Configuration wizard are not applied if you are running Toad as a Restricted user.

Workaround:
Customize these settings in the Options pages in Toad (Tools | Options).

ST42154

Toad for Oracle Bundles

If you installed the Toad for Oracle 10 bundle, and used the Toad for Data Analysts license key to enable the bundle, when you upgrade to the Toad for Data Analysts 2.5.1 patch, the Toad for Data Analyst license key is replaced with a trial key.

Workaround:
Do one of the following:

  • Use the Toad for Oracle bundle license key to license the bundle. Toad for Data Analysts recognizes this key and will be enabled by default.

  • Copy your Toad for Data Analysts 2.5.0 license.key file into the installation directory for Toad for Data Analysts 2.5.1. By default, this directory is located in one of the following:

    Windows 2003 and XP: C:\Documents and Settings\All Users\Application Data\Quest Software\Toad for Data Analysts 2.5.1.

    Windows Vista and 7: C:\Users\All Users\AppData\Roaming\Quest Software\Toad for Data Analysts 2.5.1
     

ST68507

Startup

All

(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to:

C:\Program Files\Quest Software\Toad for Data Analysts 2.5.1

However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead: C:\Users\username\AppData\Local\VirtualStore\Program Files\Quest Software\Toad for Data Analysts 2.5.1

If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory.

N/A

DB2

(Windows Vista on Toad client only) From the Client Configuration Wizard, when exporting the DB2 catalog profile as a standard user, the profile should be saved to:

C:\Program Files\Quest Software\Toad for Data Analysts 2.5.1

However, a standard user does not have write privileges in Vista to C:\Program Files so the catalog profile is saved to the following directory instead:

C:\Users\db2admin\AppData\Local\VirtualStore\Program Files\Quest Software\Toad for Data Analysts 2.5.1

ST52732

Connections

ODBC

Currently, Toad does not support ODBC connections to the following databases:

  • Progress OpenEdge

  • IBM Universe

  • Oracle RDB

  • MySQL ODBC (The ODBC 3.51.17.0 driver is not supported, and attempting to connect using this driver results in columns not displaying for tables.)

    Workaround:

    Upgrade to the MySQL ODBC driver to 3.51.27.00 to display table columns.

ST51634

ST57693

ST62817

Oracle (64-bit Oracle client)

Toad is not compatible with 64-bit Oracle clients so you cannot select the client from the Current home field in the Oracle Client tab. Toad runs as a 32-bit application, even when installed on a 64-bit O/S.

ST57771

Automation

All

If Windows XP with Service Pack 2 is running in strong security mode, Windows  blocks you from opening some zip files sent using Automation.

Workaround:

  1. Save the zip file to your computer.

  2. Right-click the saved zip file and select Properties

  3. Select the Unblock checkbox.

ST49799

Data

All

If you execute a different SQL statement, in some cases, the Pivot and Chart tab still displays data from the previous execution. To resolve this issue, remove any fields from the pivot grid. You can then use the Pivot Grid Field List window to add fields from the current statement to the grid.

ST61135

Data Compare

Excel 2007

Review the following known issues for Data Compare:

  • Currently, you cannot compare an Excel 2007 file if it is already connected in the Navigation Manager in Toad for Data Analysts. If the connection already exists, an error states that the file is in use because Data Compare uses a ODBC to connect to this file.

    Workaround:
    Disconnect the Excel 2007 file from the Navigation Manager and then select the file as a connection in the Data Compare wizard.
     

  • When comparing an Excel 2007 spreadsheet with another spreadsheet or database, the DateTime values indicate that they are different if the display format does not match because Excel 2007 DateTimes are loaded as string data.

N/A

ST51743

Database Browser/ Object Explorer

Sybase ASE

Currently, only foreign key constraints can be added or modified for existing Sybase ASE tables.

ST50504

Oracle 11g

On the Create/Alter User window, if you are modifying a password, you must enter the password in the proper case. You do not need to surround the password with double quotes.

If you enter the password in lowercase on the Create/Alter User window, and the generated script has a SQL command containing the password in lowercase, you will need to type the password in lowercase to login.

If you enter the password in uppercase on the Create/Alter User window, and the generated script has a SQL command containing the uppercase in lowercase, then you will need to type the password in uppercase to login.

ST66705

Export Wizard/ One Click Export

All

Binary data types cannot be exported in this release.

ST41665

Access, Excel

Limitations when exporting fractional seconds:

  • When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.

  • When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.

N/A

Excel

Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit.

ST62482
ST62839

Import Wizard

Excel

Currently, you cannot import Excel 2007 files because they are saved using an xlsx format.

Workaround:
Save the Excel 2007 file as a 2003 compatible file before importing it.

ST42416

Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error.

N/A

Query Builder

All

When reverse engineering a query from the Query tab or the Editor, the Diagram tab does not support a SELECT statement where the columns are qualified with the database name.

Workaround:
When you visualize the query to display in the Diagram tab, Toad automatically creates calculated columns for the columns qualified with a database name. This allows you to execute the query and return the correct result set.

For a complete list of considerations and limitations, see Reverse Engineer Queries in the help.

ST49731

Teradata

Heterogeneous queries between a Teradata table and an Access or Oracle table result in the following error, if there is a Where Condition on the Teradata table's DATE column: "[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'InfoDB' failed."

Workaround:
Use the Global Where Clause editor to wrap the column on the left hand side of the Where condition in a CVDATE function so the value is cast into the correct format.

ST55378

Reports

Oracle, DB2

A number of spelling errors have been fixed in the Oracle and DB2 reports. If you migrated settings files during an upgrade of Toad, these updates do not display.

ST60185

Version Control

All

If you migrate settings when upgrading Toad, you may have to reconfigure the repository setting in version control if a "Failed to open the settings for module VersionControl reverting to defaults" error displays.

Workaround:

To reconfigure the repository, select Tools | Options | Version Control | Defaults and select the previous repository in the Version control folder field. Your previous project settings are applied.

ST63004

In previous releases, the method Toad used to generate the script was different than the current method. After upgrading Toad, a message may display stating that objects or files in version control are different than the local version. If your local version is current, you should check the objects and files into version control.

N/A

If the version control buttons do not fit on the toolbar, any buttons that do not display cannot be clicked because they disappear as soon as the cursors moves  close to them.

ST62466

 


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.

Feature

Platform

Known Issue

Defect

Installation

All

Currently, you cannot install Toad for Data Analysts to a path that contains non-English characters. By default, Toad for Data Analysts installs IBM DB2 merge modules as part of the standard installation process. These merge modules only support English characters.

Workaround (Stand-alone installation):
In the Destination Folder page of the installer, only use a destination directory that contains English characters

Workaround (Toad Bundle installation):
In the Product Selection page of the Quest Installer, only use a destination directory that contains English characters for Toad for Data Analysts.

ST66330

Connections

Oracle

(Oracle 10.2.0.1 client only) Attempting to connect to an Oracle database From Toad using the 10.2.0.1 Oracle client results in the following error: “ORA-24909: call in progress. Current operation cancelled”. This is a known issue with this Oracle client (http://www.dbmotive.com/oracle_error_codes.php?errcode=24909).

Workaround:
Upgrade your Oracle client to a later version and connect to the Oracle database.

N/A

Oracle 11 only

When connecting to Oracle 11, you must enter the password in the proper case because passwords are case-sensitive.

N/A

Data Grid

ODBC- DB2 z/OS

In compatibility mode, the ODBC driver does not return enough information for the CommandBuilder to correctly generate update or insert statements.

N/A

Excel

All

If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662

ST42486

Export Wizard/
One Click Export

All

To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:  

2003 PIAs:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en
 

2007 PIAs:

http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en
 

N/A

Query Builder

 

Access and Excel

Currently, you cannot create a heterogeneous query between and Access database and an Excel spreadsheet. This is a known limitation of the component used. For a complete list of limitations when using heterogeneous queries, see Create Heterogeneous Queries in the help.

N/A

Excel

Currently, you cannot create a heterogeneous query between two or more Excel spreadsheets. This is a known limitation of the component used. For a complete list of limitations when using heterogeneous queries, see Create Heterogeneous Queries in the help.

N/A

 


System Requirements

Client Requirements

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

Platform 1 GHZ minimum
Memory

512 MB of RAM minimum, 1 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Hard Disk Space 219 MB of disk space to run Toad

Operating System

Windows 2003 (32-bit)

Windows XP Professional (32-bit or 64-bit)

Note: DB2 connections are not supported on Windows XP 64-bit.

Windows Vista (32-bit or 64-bit)

Windows Server 2008 (32-bit or 64-bit)

Important (SQL Server only): Toad uses the Microsoft Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista and Windows Server 2008. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

Windows 7 (32-bit or 64-bit)

Additional Software

.NET Framework
Microsoft .NET Framework 3.5 (Service Pack 1)

Note: The following conditions apply:

  • The .NET Framework Client Profile is not supported.
  • To run Toad, the .NET security policy must be set to unrestricted. For more information, see User Privilege Requirements.

Web Browser
Microsoft Internet Explorer 6.0 or later


PDF Viewer

Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide)


Existing DB2 Client Support (DB2 native provider only)
Toad installs a DB2 9.5 client as part of the installation process. The DB2 9.5 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.
 

Oracle Client

Toad can connect to Oracle using Direct Connect (no need for an Oracle Client) or can connect using an Oracle Client or Oracle Instant Client. However, if you want to use LDAP, you must install an Oracle Client. See "Configure Oracle LDAP Support" in the Toad for Data Analysts Installation Guide for more information. Toad supports 9i or later Oracle Clients and Oracle Instant Clients. See "Create Oracle Connections" in the Toad for Data Analysts Installation Guide for more information about configuring an Oracle Instant Client to work with Toad.

Server Requirements

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

Operating System

Oracle Native Provider

  • IBM AIX 5.1, 5.2, 5.3

  • HP-UX 11i 1.5, 2 (32-bit and 64-bit)

  • Red Hat Enterprise Linux AS release 3 and 4 (32-bit and 64-bit)

  • Solaris 7, 8, 9, 10 (32-bit and 64-bit)

  • SuSE 7, 8, 9

  • Windows 2003 (32-bit and 64-bit)

  • Windows XP

SQL Server Native Provider

  • Windows 2000 Server (Service Pack 4 or later)

  • Windows 2000 Professional Edition (Service Pack 4 or later)

  • Windows XP 32-bit (Service Pack 2 or later) and 64-bit

  • Windows Server 2003 32-bit or 64-bit (Service Pack 1 or later)

  • Windows Vista 32-bit and 64-bit

  • Windows Server 2008 32-bit or 64-bit

DB2 UDB for z/OS Native Provider

  • z/OS (V1R6 Base Services [5694-A01] or later)

DB2 UDB for LUW Native Provider

  • IBM AIX 5.1, 5.2, 5.3, 6.1

  • HP-UX 11i 1.5, 2 (32-bit and 64-bit)

  • Red Hat Enterprise Linux AS release 3 and 4 (32-bit and 64-bit)

  • Solaris 7, 8, 9, 10 (32-bit and 64-bit)

  • SuSE 7, 8, 9

  • Windows 2000, 2003 (including 64-bit), XP

MySQL Native Provider

  • Windows 2000 Server (Service Pack 4 or later)

  • Windows Server 2003

  • Windows XP (32-bit and 64-bit)

  • Windows Vista (32-bit and 64-bit)

Native Database Support

 

 

Toad for Data Analysts supports the following databases using the native provider:
  • Oracle 9i, 10g, 11g R2
  • SQL Server 2000
  • Windows 2000 Server (Service Pack 3 or later), 2005 (Service Pack 2 or later), 2008

Note: SQL Server Compact Edition is not supported.

  • IBM DB2 for z/OS 8.1 or later

Note: At this time, Toad supports DB2 for z/OS running in Full Function mode, but does not support DB2 running in Compatibility mode.

  • DB2 UDB for LUW 8.1.5 or later, 9.1 or later
  • MySQL 5.1

  • Sybase ASE 12.5, 15.0.2, 15.0.3 (limited testing)
  • Access 2003, 2007
  • Excel 2003, 2007
ODBC

Database Support

Toad for Data Analysts supports almost all databases that you can connect to using an ODBC 3.0 or later driver. For a list of databases that are not supported, see "Connections" in Known Issues.

 

Toad for Data Analysts Quality Assurance has tested the following databases using an ODBC 3.0 or later driver:

  • DB2 for i5/OS V5R4 and IBM i6.1 (limited testing)

  • Informix Dynamic 10.00, 11.0 (limited testing)

  • Ingres Community Edition 2006 R2 on Windows 32-bit (limited testing)

  • Netezza Data Warehouse Appliance 4.5

  • Teradata V2R6.1 (limited testing)

Citrix Requirements

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2. 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:

 User Requirements and Restrictions for Running Toad

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

  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.


Global Operations

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

 


Installation

Contents of the Release Package

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

Installation Instructions

See the Toad for Data Analysts Installation Guide for installation information, including silent and read-only installation.

Notes:

Registration

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


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:

Email info@quest.com
Mail Quest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web

http://www.quest.com

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:

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.

 


 

© 2009 Quest Software, Inc.

ALL RIGHTS RESERVED.

 

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

 

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.

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

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

 

Web site: www.quest.com

Email: legal@quest.com

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

 

Trademarks

Quest, Quest Software, the Quest Software logo, AccessManager, ActiveRoles, Aelita, Akonix, AppAssure, Benchmark Factory, Big Brother, BusinessInsight, ChangeAuditor, ChangeManager, DeployDirector, DirectoryAnalyzer, DirectoryTroubleshooter, DS Analyzer, DS Expert, ERDisk, Foglight, GPOADmin, Imceda, IntelliProfile, InTrust, Invirtus, iToken, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, LogADmin, MessageStats, Monosphere, NBSpool, NetBase, NetControl, Npulse, NetPro, PassGo, PerformaSure, Quest Central, Quest vToolkit, Quest vWorkSpace, ReportADmin, RestoreADmin, SelfServiceADmin, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Storage Horizon, Tag and Follow, Toad, T.O.A.D., Toad World, vAutomator, vControl, vConverter, vFoglight, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vSpotlight, vStream, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vBackup, Vizioncore vEssentials, Vizioncore vMigrator, Vizioncore vReplicator, Vizioncore vTraffic, Vizioncore vWorkflow, WebDefender, Webthority, 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.