Version 3.1
Release Notes
March 26, 2012
| Global Operations | Getting Started | For More Information |
|
Toad is a multi-platform database query tool built for anyone who needs to access data, understand data relationships, and quickly produce reports.
With Toad, you can:
Connect to almost any database or ODBC data source
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 provides a full-featured Database Explorer, Query Builder, and Editor for the following databases:
Oracle
SQL Server
DB2 (LUW and z/OS)
Sybase ASE, Sybase IQ, and Sybase SQL Anywhere
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 section in these Release Notes. This form of connectivity allows connections to databases such as Netezza, IBM iSeries, Ingres, and Vertica. 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.
Toad for Data Analysts Premium Edition provides all the functionality of the Professional Edition and includes expanded connectivity by allowing you create connections to non-traditional data sources. The new Quest Data Services allows you to connect to Cloud and business intelligence layer data sources and to query these sources just as you would a traditional, relational database source.
The Toad for Data Analysts Premium Edition introduces Quest Data Services which allows you to connect to non-traditional data sources, for example Cloud and business intelligence data sources. In TDA 3.1, Quest Data Services supports the following non-traditional sources:
Salesforce.com
Now you can connect directly to Salesforce.com and query the data, right from within your Toad application. Salesforce.com connections are full-featured and provide Query Builder, Query Editor, Database Explorer, Data Compare, Visualization, Transform and Cleanse, Automation, and Export functionality.
Oracle Business Intelligence Enterprise Edition (OBIEE) version 11 (preview)
In TDA 3.1, you can connect to the presentation layer of an Oracle Business Intelligence implementation and query data directly.
Note: The TDA 3.1 OBIEE connection provides for your basic connectivity needs and is currently for preview only. Please look for expanded functionality and certification in future releases of Toad for Data Analysts.
Business Objects version 3.0 and 3.1
Now you can connect directly to your Business Objects queries and explore, query, and report on that data. Business Objects connections are full-featured and provide Query Builder, Query Editor, Database Explorer, Data Compare, Visualization, Transform and Cleanse, Automation, and Export functionality.
Toad's Quest Data Services premium connections provide Query Builder, Editor, Object Explorer, Database Explorer (Viewer), and Data Reporting functionality, among others. Use these Toad tools to view, query, transform, and report on your data.
For all of your Quest Data Services connections, Toad analyzes the tables (or dimensions or queries) and maps them to tables in Toad. You can add or remove tables from the table map at any time.
Stay tuned for new Quest Data Services connection offerings in future releases.
The powerful Fuzzy Logix functions that make up Toad's Advanced Analytics are now conveniently available in code completion in the query Editor.
In addition, you will find you can access the list of functions when building a Where condition or calculated column in the Query Builder (with a Local Storage connection).
Note: The Advanced Analytics functions are in-database analytics and are included with the embedded Local Storage database. Advanced Analytics functions can be used only with a Local Storage database connection.
The Toad for Data Analysts Professional edition includes the following new features and enhancements.
Local Storage
You can right-click on a table in Local Storage and select Operations | Refresh Table to refresh the table after data in the source table has changed.
You now have the option to change a column’s data type when saving data to Local Storage. This can be useful when saving data from a cross-connection query.
Cross-Connection Editor
The code completion window has been improved and now includes a distinctive icon and a descriptive tooltip for each database connection to help you easily distinguish between connections when composing cross-connection queries.
If you copy and paste a SQL statement from a single-connection editor to a cross-connection editor, Toad now automatically rewrites the statement to include the cross-connection fully-qualified names.
Transform and Cleanse, and Data Browser
The Transformation and Cleanse tool has several new features and some excellent user interface enhancements.
Two new String functions have been added in the expression editor: RemovePrefix and RemoveSuffix. These functions are similar to Ltrim and Rtrim except that the characters are removed when they appear as a prefix or suffix.
The buttons Test and Test All have been replaced by the buttons Apply and Apply All in the Transform and Cleanse window.
Transformed data is now conveniently highlighted after you apply a rule, making it easy to scan the table for changes to the data set.
A description of each rule is included in the rule list in the Data Cleansing Actions pane (and the Rule List in Data Browser). The description helps you to distinguish between rules by identifying the action of the rule.
In the Filter Data tab, the calculator has been replaced by a drop-down list of all the unique entries in the preview rows. You can also enter a number if the value you want is not in the list.
The user interface of the Group Column tab has been markedly improved to streamline the process of creating a Grouping Column.
A Format SQL button is now included in the editor window so you can easily format your SQL statement.
Data Browser
Histogram
You are now able to zoom in and zoom out in a Column Histogram.
Use Alt + click or the mouse wheel to zoom out. After zooming in, you can also drag the histogram to bring hidden areas into view.
Data Visualization
Now you can select a color scheme for your visualization charts. Click the Color Palette icon, to select a different color palette for the current visualization.
When visualizing data, you can now choose to keep the same chart type when drilling down into subsequent dimensions. When you select a chart type, also select the Use same chart type during drill down to next dimension checkbox.
Easily save a visualization file to the Project Manager with one click using the Add to Project Manager button in the Visualization toolbar (or in the Wizard bar).
You now have the option to add labels to data points in the visualization. The label displays the data point’s value. This option is available in all chart types.
A Format SQL button is now included in the editor window so you can easily format your SQL statement.
The Base and the Professional editions of Toad for Data Analysts contain the following new features and enhancements.
Teradata
Toad now allows you to create a full-featured, native Teradata connection. This type of connection provides complete Query Builder, Query Editor, and Database Explorer functionality.
Additional features include Teradata code completion, Cross-Connection Query, Teradata code snippets, and bulk import. Toad does not provide Data Compare for Teradata, at this time.
Toad lets you choose between using Teradata X views and using Teradata Non-X views (Tools | Options | Database | Teradata). Non-X views provide improved performance.
ODBC
Vertica. Toad now supports a Vertica 5.1 ODBC connection (in addition to Vertica 4.1), with 4.0, 4.1 ODBC driver.
Note: Users of ODBC driver Vertica 5.1 may experience errors when importing timestamps. For best results when importing data that includes a TIMESTAMP data type, use an early release of Vertica’s ODBC driver.
Netezza Data Warehouse Appliance. Toad now supports an ODBC connection to Netezza 6.0 (in addition to Netezza 4.6.6).
SharePoint
You can now export data to a list in SharePoint using Toad’s Export Wizard. You can also import a list from SharePoint using the Import Wizard. Toad supports SharePoint 2010.
Import
When importing data using the Import Wizard, you can now select to use your current regional settings instead of the default. The data is parsed using the settings of the region that you have specified (on your PC).
Project Manager
The Project Manager has a new feature to allow you to save a value for a bind variable. Then, when executing SQL containing that variable, Toad will not prompt you for the value. Use the Project Manager to manage your list of bind variables and their values.
Reports Designer
When you create a Data Report from data with a Master Detail relationship, the Detail Report Band is automatically inserted into the report for you.
Right-click an activity in the script design window and select Enabled to easily enable/disable the activity.
You now have the option to choose whether or not to truncate the script’s log file each time the script runs. Make the selection in the script settings pane.
You can now use drag and drop or up/down arrows to change the order of find and replace tasks in the Find and Replace activity.
Important!
Beginning with TDA 2.7, Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version,
Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\BAK folder in the Application Data Directory under Help | About.
Query Builder
This release of Toad has re-implemented the checkbox method of selecting columns in the Query Builder Diagram pane. Click a column name once in the table diagram to add the column to the query. To add the column to the query a second time, right-click the column name in the diagram and select Add to Output.
Editor
If you copy and paste a SQL statement from one editor window to another, Toad automatically changes the syntax of the statement to match that of the database connection of the second editor.
Previously, when the Editor contained multiple statements, and you selected Send To Query Builder, Toad sent the entire contents of the Editor. Now you can highlight one statement, right-click the statement and select Send To Query Builder to send only the one statement.
Code Snippets
You can right-click a code segment in the Editor and select Snippets | Add to Code Snippets to easily create a new snippet in your Favorites folder. And now you have the option to save the new snippet to the Shared Snippets or Shared Toad folder at the same time.
You can now import snippets directly into a selected folder in the Code Snippets window.
You can now export your entire code snippet library to a destination folder.
Toad now provides proxy support for FTP connections. Toad allows you to set up an HTTP or Socks proxy for an FTP connection.
The following is a list of issues addressed and enhancements implemented in this release of Toad.
| Feature | Platform | Resolved Issue / Enhancement | Defect ID |
|---|---|---|---|
| Advanced Analytics | All | In the TDA Pro edition with Analytics, the Advanced Analytics (Fuzzy Logix) functions are now available in code completion in the Editor and also when building a Where condition in the Query Builder. | n/a |
| Automation | All | You can now perform one Find and Replace task on multiple files at one time by using standard wildcard symbols in the file name. | ST81010 |
| Automation | All | In the Set Variable activity, using SQL to set a value for the variable now works as expected, including the Preview SQL button. | ST85349 |
| Automation | All | Information sharing between activities is improved. For example, if you delete an activity that creates a file, that file is also deleted from any later tasks in the script where it is used as an attachment or other input. | ST88038 |
| Automation | All | In TDA 3.1, properties and script settings now display only when the activity or settings icon is selected in the design window, making it more difficult for the user to accidentally change script settings and activity properties. | ST89010 |
| Automation | All | A Cancel button has been added to the File Collection Editor so you can cancel out of the operation even after making some modifications. In addition, you can now select multiple files at one time using Ctrl+click. | ST90101 |
| Automation | All | You now have the option to choose whether or not to truncate the script’s log file each time the script runs. | ST90268 |
| Automation | All | In the Select to File activity, response time is greatly improved when user enters a SQL statement into the text box. | ST91012 |
| Automation | All | Right-click an activity in the script design window and select Enabled to easily enable/disable the activity. | ST91388 |
| Automation | Access | When creating a connection to an Access database, you will no longer be prompted for a password unless the database is password-protected. | ST91499 |
| Automation | All | You can now customize the date/time suffix for file names used in Automation activities. | ST91746 |
| Automation | All | In the Delete File activity, when you click Add Files, the File Collection Editor correctly displays and allows you to select from the files that are created earlier in the script. | ST91851 |
| Automation | All | The Delete File activity has been improved to include an easy-to-use interface for selecting the files to delete. | ST92046 |
| Automation | All | You can now change the order of the Find and Replace tasks in a Find and Replace activity. Also, a Cancel button has been added to the Find and Replace Editor. | ST79016, ST79095 |
| Connections | Business Objects | You will no longer encounter an error when trying to view data from parameterized tables. In addition, you can now enter a default parameter value when mapping tables. | ST86808 |
| Connections | Access | You no longer encounter an error message when connecting to an Access database that is not password-protected, even when Save password is not selected in the Connection Properties. | ST91499 |
| Connections | Business Objects | This release of TDA now supports Business Objects 3.1, in addition to 3.0. | ST95337 |
| Connections | Vertica |
TDA 3.1 supports Vertica 5.1. In addition, Toad now supports the Vertica 4.1 ODBC driver. Note: Users of ODBC driver Vertica 5.1 may experience errors when importing timestamps. For best results when importing data that includes a TIMESTAMP data type, use an early release of Vertica’s ODBC driver. |
ST89802, ST93132 |
| Connections | Oracle | Previously, some users with simultaneous SESSIONS_PER_USER limits encountered an error message when trying to reconnect, due to multiple connections still active. This issue has been resolved. | ST93267, ST93610 |
| Connections | Teradata | Toad now provides support for a full-featured, native Teradata connection, including complete Query Builder, Query Editor, and Database Explorer functionality. | n/a |
| Connections | Salesforce | Toad now allows you to create a connection to Salesforce.com. | n/a |
| Connections | OBIEE | Toad now allows you to create a connection to Oracle Business Intelligence Enterprise Edition (OBIEE). | n/a |
| Connections | Business Objects | Toad now allows you to create a connection to Business Objects. | n/a |
| Connections | Salesforce | You can now go to Options | Quest Data Services to specify a proxy server for Salesforce or any Quest Data Services connection. | ST94281 |
| Connections | Salesforce | When establishing a Salesforce or other Quest Data Services connection, TDA 3.1 now displays a progress bar and a message informing the user that Toad is in the process of retrieving and mapping objects. | ST94339 |
| Connections | Salesforce | Performance is improved for Salesforce connections. | ST94408, ST94416 |
| Connections | All | An issue in a TDA 3.1 64-bit Client Beta release that caused an error when trying to make a new connection or trying to use an existing connection has been resolved. | ST95159 |
| Cross-Connection Query | All | You will no longer encounter an "Unknown database '_toadls" error when executing a cross-connection query. | ST96678 |
| Cross-Connection Query | DB2 | You will no longer encounter a Cross Query Database error when executing a cross-connection query with a DB2 connection in which databases\subsystems are cataloged using aliases names. | ST89797 |
| Cross-Connection Query | Sybase IQ | In the TDA Base edition, when attempting to execute a cross-connection query with a native Sybase IQ connection, the query executes as expected. | ST91731 |
| Data Browser | All | Data Browser processing is now done in the background. | ST89198 |
| Data Compare | Oracle | Performing Data Compare on an Oracle database, when the data type for source and target key columns is NUMBER and INTEGER, now results in a correct comparison. | ST82745 |
| Data Compare | SQL Server, Access | Comparing a SQL Server table to an Access table now works as expected. | ST91671 |
| Data Compare | SQL Server, Excel | Comparing a SQL Server table to an Excel file now works as expected. | ST91762 |
| Data Compare | Excel | Comparing two Excel files now works as expected. | ST91762 |
| Data Compare | Oracle | When you generate a script in Data Compare, Toad no longer truncates the number of decimal places for FLOAT and DECIMAL data types (Oracle database). | ST78081 |
| Data Compare | Excel | An issue that caused an error when attempting to compare an Excel file in Data Compare has been resolved. | ST93119 |
| Data Reports Designer | All | When opening a saved Data Report, the NewDataSet node now displays as expected. | ST92371 |
| Data Reports Designer | All | Detail Report Bands retain relationship in saved Data Reports after the query is modified and re-executed. | ST94478 |
| Data Reports Designer | All | The subreport feature of Data Reports Designer now works as expected. | ST91823, ST91857 |
| Data Reports Designer | All | When you add more than one table to a report and make a relationship, a Detail Band is automatically added to the report. | ST90233 |
| Database Explorer | All | In a data grid, selecting Quick Export from the right-click menu in the Database Explorer (or the Transform & Cleanse tool) now works as expected (you will no longer encounter an "Export did not find any result sets to process" message). | ST67465 |
| Database Explorer | Oracle, DB2 | Column widths now auto-resize correctly when switching to another database object, including Oracle and DB2 database objects. | ST83612, ST86938 |
| Database Explorer | DB2 | Script tab now works as expected with a DB2 connection. | ST95273 |
| Database Explorer | Netezza | With a Netezza connection, the Open script in editor button on the Script tab now works as expected. | ST91591 |
| Editor | All | In the Pivot and Chart grid, the default format for numerical data is no longer currency—it is now the number format. | ST58695 |
| Editor | Netezza | Code completion with a Netezza connection now works as expected. | ST78096 |
| Editor | All | When your Editor window includes multiple SQL statements, you now have the option to send only one statement to the Query Builder by highlighting that statement before selecting Send To Query Builder. | ST80339 |
| Editor | Oracle | For some users, the Cancel Executing Query option did not work when rerunning a modified query in the same Editor window with an Oracle connection. This issue has been resolved. | ST80766 |
| Editor | All | For all databases, including Oracle, the error log in the Editor and the Query Builder now provides the line and position for syntax errors. | ST91218 |
| Editor | All | If you copy and paste a SQL statement from one Editor window to another, Toad automatically changes the syntax of the statement to match that of the second Editor database connection. | ST91601 |
| Editor | All | In the Editor toolbar, all of the execute buttons are now consolidated under one button. This main button retains the function of the last action for the selected (active) Editor window. The other execute buttons are always available beneath the Execute SQL button via a drop-down list. | ST91761 |
| Editor | DB2 | For some users, executing multiple statements on a DB2 connection resulted in a "System.OutOfMemory" error. This issue has been resolved. | ST90692 |
| Editor | All | An issue (in a TDA 3.1 Beta release), that caused the application to stop working when the user saved and then re-opened a .tef file, has been resolved. | ST92564 |
| Editor | Oracle | An issue (in a TDA 3.1 Beta release) which caused an error message to display when executing a procedure has been corrected. | ST94012 |
| Editor, Snippets | All | You now have the option to save snippets in the Shared Snippets folder | ST90014 |
| Editor, Snippets | All | You can now import and export code snippets. | ST82391, ST91378 |
| Export | All | When exporting multiple objects to the clipboard or to one file, all objects are now exported correctly and no objects are overwritten. | ST89749 |
| Export | SQL Server | With a SQL Server connection, when exporting to an Excel Instance or performing a right-click | Quick Export | Excel Instance, Toad no longer unexpectedly adds additional decimal places to data. | ST93891 |
| Export | Excel | Numbers with more than 15 significant digits are no longer rounded up when exporting to Excel. | ST91546 |
| Export | Vertica | With a Vertica connection, Toad now correctly exports values with the DATE data type from a data grid when selecting Quick Export | Excel Instance from the right-click menu. | ST92238 |
| Export | All | When attempting to export a result set in an Editor where the connection is no longer open, the Export Wizard correctly prompts you to reconnect (instead of displaying an error message). | ST93002 |
| Export | Access | An issue (in a TDA 3.1 Beta release) that caused Toad to export as an .accdb file (instead of the version the user selected) has been resolved. | ST96228 |
| FTP | All | Toad now provides proxy support for FTP connections. Toad allows you to set up an HTTP or Socks proxy for an FTP connection. | ST90228 |
| General | All | Previously, some users encountered an error message along with a situation where a toolbar would not display. This issue has been resolved. | ST80484 |
| General | All | The File | Save As command now has improved performance. | ST91071 |
| General | All | You can now save to Excel 2007 when using the Send to Report button in the Wizard bar. | ST92242 |
| General | All | Previously, for some users, Toad unexpectedly quit when performing the Send to Report action. This issue has been resolved. | ST93526, ST93611, ST95156, ST95846 |
| General | All | Some users encountered an error when performing the Send to Report action and then using File | Preview followed by File | Print. This issue has been resolved. | ST91971 |
| General | All | Improved performance when opening File menu. | ST93721 |
| General | All | You can now once again copy rows from a data grid and paste as HTML formatted text. | ST95800 |
| General | All | An issue that caused an error message when non-Outlook users attempted to use the Refer a Friend option in the Help menu has been resolved. | ST90974 |
| General | All | An issue that caused an error for some users when performing a copy and paste action has been resolved. (This issue was never reproduced.) | ST93009 |
| Import | All | Previously, in the Import wizard, some users encountered an error message when clicking the Back button followed by the Next button after changing the file encoding option on the Preview File page. This issue has been resolved. | ST86199 |
| Import | All | You now have the option to use your current regional settings when importing data. The data is parsed using the settings of the region that you have specified (on your PC). | ST90721 |
| Import | SQL Server | Improved performance when importing, when multiple SQL Server connections are open. | ST93575 |
| Import | Access | You will no longer encounter a "Numeric value out of range" error message when importing from an Excel file containing large numeric data into an Access database. | ST93607 |
| Import | DB2 | With a DB2 connection, the skip column option on the Select a Target page in the Import wizard now works as expected. | ST93825 |
| Import | SQL Server | You will no longer encounter an error when importing null values into a nullable column in a SQL Server database. | ST96633 |
| Import | SQL Server | An issue (in a TDA 3.1 Beta release) that caused an error when trying to import null values into an Identity column when Identity Inserts is turned Off has been resolved. | ST97219 |
| Import | Netezza | An issue that caused an error when attempting to import data that includes date formats has been resolved. | ST91593 |
| Installation | DB2 | In this release of TDA 3.1, if you are upgrading from a previous version, Toad correctly migrates the DB2 catalog to the new installation. TDA 3.0 users encountered an error when attempting to open an existing DB2 connection, as a result of the missing catalog. For users who previously upgraded from TDA 2.7 to 3.0 and were unable to connect to DB2, when prompted during installation, select to migrate the catalog from TDA 2.7. | ST91007, ST91865 |
| Installation | DB2 | You can now install the TDA Base edition in a 64-bit environment that has an existing 64-bit DB2 Client installed. To do this, you must use the Base edition ToadforDataAnalysts_64bit_Client_Installer.exe. | ST91938 |
| Installation | DB2 | An issue, which for some users prevented the DB2 Management Service from starting automatically after installation, was resolved. | ST93213 |
| Local Storage | n/a | You can now change the data type of the destination column when saving to Local Storage. | ST87841 |
| Local Storage | n/a | You can now refresh a table in Local Storage. The Local Storage table is updated with the current data from the source table, including any changes that have been made to the source. | ST91722 |
| Local Storage | n/a | Relocating Local Storage to a network location, by modifying settings in Options | Local Storage, now works as expected. | ST91153, ST92368 |
| Local Storage | n/a | In a TDA 3.1 Beta version, in a Local Storage table, after importing from a query, the Refresh Table command produced an empty table. This issue has been resolved. | ST96621 |
| Object Explorer | Vertica | You will no longer encounter an out-of-memory message when performing a Refresh All with a Vertica database connection. | ST93572 |
| Object Explorer | MySQL | MySQL information_schema tables can be displayed in Object Explorer. | ST95322 |
| Object Explorer | SQL Server | The Create, Create Like, Alter, and Drop buttons now display in the toolbar on the Index tab in the Object Explorer for a SQL Server database. | ST91375 |
| Object Explorer | Netezza | An issue which caused Toad to hang after selecting the Views tab (with a Netezza connection) has been resolved. | ST79186 |
| Options | DB2 | In Options | Database | Oracle, the option Number of rows to initially fetch in Editor now displays the correct shortcut, F9. | ST90753 |
| Project Manager | All | When you right-click a file and select Browse, the file's location folder opens in a Windows Explorer window, instead of in a browser window within Toad. In addition, the file is already selected in the window for easy opening. | ST74182 |
| Project Manager | All | You can now drag and drop To-Do Items from one To-Do List to another. | ST77944 |
| Project Manager | All | You can now sort the contents of a project folder or sub-folder. Right-click a project or folder and select Sort. The contents are sorted alphabetically. | ST78965 |
| Project Manager | All | Saving a connection to the Project Manager by right-clicking a project or folder and selecting Add | Database Connection now works as expected. A list of connections is displayed to select from. | ST84461, ST88941 |
| Project Manager | All | Now you can conveniently specify a value for a bind variable and then save it in the Project Manager. Use the Project Manager to manage the list of bind variables and their values. | ST91631 |
| Project Manager | All | An issue that caused an error when the user selected a data report in a project and then selected Design Report from the right-click menu has been resolved. | ST92697 |
| Query Builder | All | The Customization dialog (right-click a column head and select Column Chooser) now displays the columns for the grid of the currently active document/window only. | ST47360 |
| Query Builder | All | You can now use Ctrl+F in the results grid in the Editor. | ST85341 |
| Query Builder | DB2 | DB2 users can now successfully reverse engineer SELECT statements that contain an ALIAS. | ST85534 |
| Query Builder | All | Now Toad remembers your last layout for Navigation Manager (pinned or unpinned) for saved Query Builder files and reverts to this layout when you open the file. | ST91596 |
| Query Builder | All | You can now right-click a column name in the table diagram and select Delete from Output. | ST91710 |
| Query Builder | Local Storage | You will no longer encounter a SQL Syntax error when querying tables in Local Storage that have Join Properties specified. | ST91818 |
| Query Builder | All | In Query Builder, the table diagram now once again includes the column checkboxes. You can add the column a second time by performing a right-click | Add to Output. | ST90390, ST91991 |
| Query Builder | All | The elapsed time is now displayed in the lower right corner of the Query Builder window while a query is executing. | ST92001 |
| Query Builder | All | If you create a calculated field, it is automatically added as a column to the criteria pane. | ST95336 |
| Query Builder | All | Fully-qualified names are not used if you deselect the option Use fully qualified object names in the Query Builder Options. | ST95430 |
| Query Builder | Oracle | Query Builder correctly reverse engineers Oracle left and right joins. | ST93270, ST95231 |
| Query Builder | All | Reverse engineering a query by opening a Query Builder window and then using the Open Query button on the Wizard bar now works as expected. | ST93723, ST93608 |
| Query Builder | All | In the Criteria pane, column width is now auto-sized to the column name. | ST91854 |
| Query Builder | All | Building a sub-query in Query Builder now has improved performance. | ST95153 |
| Query Builder | OBIEE | Query Builder now correctly formats date literals in a query with an OBIEE connection. | ST96632 |
| SharePoint | All | You can now import a list from SharePoint using TDA's Import wizard. You can also export data to a SharePoint list using the Export wizard. | ST72352, ST91305, ST91306 |
| SharePoint | All | TDA 3.1 now informs the user if they try to import/export to an unsupported version of SharePoint. TDA supports SharePoint 2010. | ST95169 |
| Trans & Cleanse, Data Browser | All | A Format SQL button is now included in the editor window so you can easily format your SQL statement. | ST83860 |
| Trans & Cleanse, Data Browser | All | Filter Data: This interface now includes a drop-down list of all unique entries in the preview rows. | ST83866 |
| Trans & Cleanse, Data Browser | All | You can now copy and paste rules within the rule list (or actions in the actions list), drag and drop rules to change their order, or use undo/redo. | ST87059, ST88975 |
| Trans & Cleanse, Data Browser | All | Group Column: You can now easily delete a single group expression by clicking the delete button to the left of the expression. | ST87062 |
| Trans & Cleanse, Data Browser | All | Calculated and grouping columns now have a default name. | ST87075 |
| Trans & Cleanse, Data Browser | All | In the expression editor, the hex function now works as expected. | ST87244 |
| Trans & Cleanse, Data Browser | All | Transform and Cleanse now correctly escapes characters that require it. | ST90503 |
| Trans & Cleanse, Data Browser | All | New string functions have been added: RemovePrefix and RemoveSuffix. | ST90928 |
| Trans & Cleanse, Data Browser | All | Added a delete button to easily delete each rule in the rule list. | ST92566 |
| Trans & Cleanse, Data Browser | All | Column histogram now has zoom in/out and pan actions for easy viewing. | ST92694 |
| Trans & Cleanse, Data Browser | All | The Test and Test All buttons have been replaced with Apply and Apply All buttons. | n/a |
| Trans & Cleanse, Data Browser | All | Group Column: The process of grouping is now streamlined as a result of significant enhancements to the Group Column user interface. | ST88973 |
| Trans & Cleanse, Data Browser | All | With the new Add to Project Manager button, now with one click you can save a Transform and Cleanse or Data Browser session as a file and add it to a project in the Project Manager. | n/a |
| Trans & Cleanse, Data Browser | All | Filter Data: You will no longer encounter a "mismatched input" error when performing a Filter on columns that contain a line break. | ST86914 |
| Trans & Cleanse, Data Browser | All | Group Column and Calculate Column: You can now overwrite an existing column with transformed data by entering the name of the existing column. | ST88974 |
| Trans & Cleanse, Data Browser | All | Find Duplicates: Enhancements to the Find Duplicates user interface include: options renamed (for clarity), a caption displays the number of duplicates found. | ST90847 |
| Visualization | All | You can select a color scheme for your Visualization charts to give your data optimum visibility. | ST83457 |
| Visualization | All | Chart scaling is improved. In addition, you can now zoom in and out of a visualization chart. | ST86804 |
| Visualization | All | You can copy the visualization chart as an image to the clipboard. | ST86812 |
| Visualization | All | You can now add labels to data points in all chart types. | ST86949 |
| Visualization | All | You can now choose to keep the same chart type when drilling down into subsequent dimensions. | ST87001 |
| Visualization | All | When you use the zoom in and pan actions in a graph, the cursor remains as a pointer, so now you can more easily see the data points to click on for drilling down into the data. | ST87145 |
| Visualization | All | The query no longer re-executes unnecessarily. | ST87948 |
| Visualization | All | With the new Add to Project Manager button, now with one click you can save a Data Visualization session as a file and add it to a project in the Project Manager. | n/a |
| Visualization | All | Numbers using scientific notation format now display correctly in Data Visualization. | ST86912 |
Note: This list does not include every resolved issue for this release. To inquiry about an issue not listed here, please contact the Toad for Data Analysts Team at the Toad for Data Analysts community Web site.
The following is a list of issues known to exist at the time of this release.
|
Feature |
Platform |
Known Issue |
Defect ID |
|---|---|---|---|
| General | Sybase ASE |
Currently, opening a Toad file in TDA 3.0 or later that contains a connection to Sybase ASE and was saved in TDA 2.7 (or earlier) results in an error message. The following workaround is for a Query Builder file, but a similar method can be used for any Toad file. Workaround 1:
Workaround 2:
|
N/A |
| Excel | 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 | |
|
Installation/ Upgrade |
All |
(MSI installs on Windows Vista and 7) If you are using MSI to install Toad on Windows Vista or 7 with UAC enabled, you can install a file that adds a "Run as administrator" option when right-clicking the MSI file: http://www.symantec.com/connect/downloads/msi-run-administrator-context-menu-vista |
N/A |
|
Toad for Data Analysts does not support installation paths that contain UNICODE characters. |
N/A |
||
| Toad for Data Analysts 3.0 or later doesn’t support User IDs that contain Unicode characters. | ST90367, ST90372 | ||
| The Toad for Data Analysts Read Only installation is read-only for all databases, with the exception of MySQL. If you are using a Read Only installation of Toad for Data Analysts, you will be able to modify a MySQL (and only MySQL) database. | N/A | ||
|
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):
Workaround (Toad Bundle installation): |
ST66330 | ||
|
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 3.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 3.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 3.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 3.1 |
N/A |
|
|
Connections |
ODBC |
Currently, Toad does not support ODBC connections to the following databases:
|
ST69744 |
| Access |
Currently, for a password-protected Access database, selecting Save password in the Connection Properties dialog does not preserve the password for the next Toad session. Workaround:
Note: This will allow you to connect to the database and save the password for this session of Toad. Repeat the procedure if you re-launch Toad. |
ST94125 | |
| Automation | All |
Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\BAK folder in the Application Data Directory under Help | About. |
N/A |
| All |
If Toad for Data Analysts 3.1 is launched as administrator on Windows 7/Vista systems with UAC turned on and Outlook running, the auto-populate SMTP server info and contact list in Automation Email and Error Emails does not function properly. Workaround: Submit this information manually. Another option is to either run Toad for Data Analysts 3.1 not as administrator, or turn UAC off, or close Outlook when adding the Send Email activity in Automation. |
ST80857 | |
| All | Currently, in Automation you cannot use a period (.) in a date/time format string when customizing the date/time suffix for a file name. | ST97217 | |
|
Access |
Running an automation script on an Access connection that requires a password or user name causes Toad to hang. Workaround:
|
ST71102 |
|
| Data |
ODBC - Ingress |
In some cases, earlier Ingress ODBC drivers display an "Invalid number of columns or parameters specified" error message when displaying data that has Unicode characters. Workaround:
|
N/A |
|
Data Compare |
Excel 2007 |
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:
|
N/A |
| Execution Plan | SQL Server |
You cannot generate an estimated execution plan for a local temporary table because the execution plan uses a different connection to generate the plan and does not know about the temp table. Workaround:
|
N/A |
| Export Wizard/ One Click Export | Access, Excel
|
Limitations when exporting fractional seconds:
|
N/A
|
| Import Wizard |
Excel |
Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error. |
N/A |
| Attempting to import data from a template that contains multiple worksheets results in an error.
|
ST77978 | ||
|
ODBC - Netezza |
(Netezza only) Currently, you can only import data into the SYSTEM schema. |
ST68390 |
|
| ODBC - DB2 iSeries, Netezza | Currently, the Truncate table checkbox is disabled on the Select Target page when using an ODBC connection to a DB2 iSeries or Netezza database. | ST77986 | |
| Oracle, DB2 | When importing data using the Add Query feature, BLOB data is not imported even though the dialog and log indicate that the import was successful. | ST77255 | |
| Object Explorer/ Database Explorer | Sybase ASE | Currently, only foreign key constraints can be added or modified for existing Sybase ASE tables. | ST55111 |
| 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 | |
|
Query/ |
All |
The Query Builder currently uses a 24-hour format for timestamps. Attempting to run a query with a date range that includes a 12-hour timestamp format results in incorrect formatting of the timestamp. | ST78729 |
|
ODBC - Teradata |
Heterogeneous (cross-connection) 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:
|
ST55378 |
|
|
Oracle |
In the TDA Base edition, when creating a heterogeneous (cross-connection) query, there are limitations when using the following ODBC drivers:
|
ST70733 |
|
| Local Storage | Currently, in a cross-connection query using Local Storage, Toad does not support quoted table alias names (example, the table alias "foo bar"). Quoted column names are supported. | ST86483 | |
|
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:
|
N/A |
|
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. |
N/A |
The following is a list of third party issues known to exist at the time of this release.
| Feature | Platform | Known Issue | Defect ID |
|---|---|---|---|
|
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 canceled”. 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 |
|
| Automation | All |
If you are running Windows XP with Service Pack 2 in strong security mode, Windows blocks you from opening zip files sent by Automation if they were created using the Windows Compression wizard. This is a security feature in Windows. Workaround:
|
N/A |
|
Data |
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 |
| Editor | Teradata |
If you experience performance issues using a Teradata connection, especially when using code completion in the Editor, use the Teradata Non-X views (instead of the X views). To use Teradata Non-X views
|
N/A |
|
Export Wizard/ |
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: 2007 PIAs: |
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. | N/A | |
| Import Wizard | DB2 | When importing data using the Add Query feature and selecting a Single new table, TIMESTAMP data types are mapped to DATETIME data types. | N/A |
| Object Explorer/ Database Explorer | DB2 iSeries | The primary Key column of an iSeries table displays as Nullable in the Database Explorer even though the Not Null checkbox was not selected when creating the table. | N/A |
|
Query Builder |
Access and Excel |
Currently, you cannot create a heterogeneous (cross-connection) 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 (cross-connection) queries, see Create Cross-Connection Queries in the help. |
N/A |
|
Excel |
Currently, you cannot create a heterogeneous (cross-connection) 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 (cross-connection) queries, see Create Cross-Connection Queries in the help. |
N/A |
|
| Sybase ASE | You cannot create a heterogeneous (cross-connection) query when connected using a Sybase ODBC driver. | N/A | |
| Sybase ASE |
Cross-connection query: Sybase has difficulty dealing with numeric literals in queries. You may encounter the following error: Implicit conversion from datatype 'CHAR' to 'INT' is not allowed. Use the CONVERT function to run this query. when attempting to execute a cross-connection query such as: Select * from table where numeric_column = 50 Work-around: Change the query to something similar to the following using the cast function: Select * from table where numeric_column = CAST(50 AS SIGNED) |
ST96868 |
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
|
Platform |
1 GHz |
|
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
|
Hard Disk Space |
475 MB to run Toad Professional edition, 350 MB to run Toad Base edition Note: The disk space required may vary based on the edition of Toad selected for installation. |
|
Operating System |
Windows Server 2003 Windows XP Professional (32-bit or 64-bit) Windows Vista (32-bit or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows 7 (32-bit or 64-bit) |
| .NET Framework |
Microsoft .NET Framework 3.5 (Service Pack 1) Note: The following conditions apply:
Teradata .NET Data Provider You must install the Teradata .NET Data Provider (13.10 or later) to use a Teradata native connection in Toad. Note: To use a Teradata connection in a cross-connection query, you must also install a Teradata (13.10 or later) ODBC driver. |
| Database Client |
Existing DB2 Client Support (DB2 native provider only) Toad installs a DB2 9.7 (Fix Pack 4) client as part of the installation process. The DB2 9.7 client can co-exist with an existing DB2 8 client, but is incompatible with a DB2 7 client. If a DB2 7 client already exists on your computer, the Toad installation stops and cannot complete. To resolve, first upgrade to the DB2 8 client. Then restart the Toad installation to avoid losing functionality in some DB2 native tools. Existing 64-bit DB2 Client (DB2 native provider only) If you have a 64-bit DB2 client installed, you must install Toad using the ToadforDataAnalysts_64bit_Client.exe. 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. Toad supports 9i or later Oracle Clients and Oracle Instant Clients. Notes:
|
|
Additional Requirements |
Web Browser Microsoft Internet Explorer 6.0 or later Spatial Data Types To work with spatial data types used in SQL Server 2008, you must install SQL Server 2008 Client Tools or SQL Server Management Studio 2008. |
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
|
Operating System |
IBM AIX 5.1, 5.2, 5.3 HP-UX 11i 1.5, 2 (32-bit or 64-bit) Red Hat Enterprise Linux AS release 3 and 4 (32-bit or 64-bit) Solaris 7, 8, 9, 10 (32-bit or 64-bit) SuSE 7, 8, 9 Windows 2003 (32-bit or 64-bit) Windows XP
Windows Server 2000 Service Pack 4 or later Windows 2000 Professional Edition Service Pack 4 or later Windows XP (32-bit with 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 or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit)
z/OS (V1R6 Base Services [5694-A01] or later)
IBM AIX 5.1, 5.2, 5.3, 6.1 HP-UX 11i 1.5, 2 (32-bit or 64-bit) Red Hat Enterprise Linux AS release 3 and 4 (32-bit or 64-bit) Solaris 7, 8, 9, 10 (32-bit or 64-bit) SuSE 7, 8, 9 Windows 2000, 2003 (including 64-bit), 2008, XP, Vista, Windows 7
Windows 2003 Windows Server 2000 Service Pack 4 or later Windows 2000 Professional Edition Service Pack 4 or later Windows XP (32-bit with 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 or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit)
Windows Server 2000 Service Pack 4 or later Windows 2000 Professional Edition Service Pack 4 or later Windows XP (32-bit with 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 or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit) |
|
|
Toad supports the following databases: Oracle 9i, 10g, 11g, 11g R2 Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.
SQL Server 2000 (Service Pack 3 or later) SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express SQL Server 2008 and SQL Server 2008 Express SQL Server 2008 R2 and SQL Server 2008 R2 Express Note: SQL Server Compact Edition is not supported. IBM DB2 for LUW 8.1.5 or later IBM DB2 for LUW 9.1 or later
IBM DB2 for z/OS 8 IBM DB2 for z/OS 9 IBM DB2 for z/OS 10 Notes:
MySQL 4.1, 5.0, 5.1 Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5 Sybase IQ 15 Sybase SQL Anywhere 12 Teradata 12.0, 13.0, 13.10 Access 2003, 2007, 2010 Excel 2003, 2007, 2010 |
|
ODBC Database Server |
Toad for Data Analysts allows you to create a connection to a database that supports an ODBC 3.0 or later driver. ODBC connectivity provides basic querying capability, but may not be as full-featured as a native connection in Toad. Toad has been tested on the following databases, using an ODBC connection:
Note: For a list of databases that are not supported, see Known Issues in the Release Notes. |
| Cloud Database Service |
Oracle databases running on Amazon EC2 SQL Azure Note: To connect to SQL Azure, you must have read access to the master database. SQL Server databases running on Amazon EC2 Toad can manage Amazon RDS and any other cloud or service offering compatible with MySQL. |
|
Quest Data Services - Premium Connections |
Toad has been tested with, and supports, the following Business Intelligence / Cloud platforms:
|
| Application Virtualization |
Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003.
|
| Desktop Virtualization (VDI) |
Toad has been tested with Quest vWorkspace 7.0 running on Windows XP Professional 32-bit (Service Pack 2). |
|
Note: Toad may work in virtualization environments other than the ones in which it was tested. |
|
Only Windows Administrators and Power Users can install Toad.
Note: The following exceptions exist for Power Users:
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:
The following describes the requirements and restrictions for users who launch and run Toad:
To run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.
This release has the following known capabilities or limitations: During installation, if the user overrides the default installation directory location, the directory path cannot contain Unicode characters. This is due to the fact that we install a DB2 LUW client in the user specified Toad Installation directory and the DB2 installation does not support such characters.
The Toad release package contains the following products:
See the Toad for Data Analysts Installation Guide for more information.
|
|
|
|
|
Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA |
|
Web site |
See our web site for regional and international office information.
Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. 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, policies and procedures. The guide is available at: http://support.quest.com.
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
© 2012 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
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, Benchmark Factory, Toad, T.O.A.D., Toad World, and vToad are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see http://www.quest.com/legal/trademark-information.aspx. Other trademarks and registered trademarks used in this guide are property of their respective owners.