Chat now with support
Chat with Support

Toad Data Point 4.3 - Release Notes

Release Notes

Toad® Data Point 4.3

Release Notes

Thursday, October 19, 2017

About Toad Data Point

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

With Toad Data Point, you can:

  • Connect to almost any database or ODBC data source (see the Release Notes for a list of tested ODBC connections)
  • 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 Data Point provides a full-featured Database Explorer, Query Builder, and Editor for the following databases:

  • Oracle®
  • SQL Server® and SQL Azure
  • IBM® DB2® (LUW and z/OS)
  • SAP® ASE, IQ, SQL Anywhere, and HANA
  • Teradata®
  • MySQL

Toad Data Point also provides querying and reporting functionality via the following provider types:

  • ODBC
  • Business Intelligence and NoSQL data sources
  • Microsoft® Excel®
  • Microsoft Access®

ODBC Connections

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 in the 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.

Business Intelligence and NoSQL Data Sources

Toad Data Point provides users with the ability to connect to non-traditional data sources, such as Business Intelligence and NoSQL sources. You can connect to these data sources and explore data and objects, query data, report results, and automate tasks.

The following data sources are supported:

Business Intelligence

Oracle Business Intelligence Enterprise Edition (OBIEE), SAP Business Objects™, Salesforce®, Microsoft SQL Server Analysis Services, Google Analytics™, OData, and SharePoint®

NoSQL

Azure Table Services, Cassandra™, Cloudera Impala, DynamoDB, HBASE™, Hive™, MongoDB™


New Features

New Features

 

Toad Data Point - Professional Edition

The Toad Data Point Professional edition includes the following new features and enhancements.

Toad Intelligence Central

Changes to Authentication Keys

This release includes an important change to Authentication keys. Beginning with Toad Data Point 4.3, a view can have only one type of key applied at a time (per data source), either a shared key or a personal key. This change is designed to simplify the process of Authentication. Please review the following details.

  • In summary, an object can have only one type of key applied at a time. A snapshot always has a shared key. A View can have either a personal key or a shared key, but not both.

    Note: For cross-connection queries, each data source can have its own separate key type, either personal or shared.

  • After a view is published, you can no longer add an additional key type, but you can change the key type.
  • If you change a personal key to a shared key, all personal keys are removed from the object.
  • If you change a shared key to a personal key, the shared key is removed from the object.

Notes:

  • A similar change to Authentication key functionality is included in Toad Intelligence Central 4.3. See the Toad Intelligence Central 4.3 documentation for more information.
  • If you upgrade to Intelligence Central 4.3, required modifications to Authentication keys are handled during the upgrade/installation process. See the Toad Intelligence Central Release Notes and Deployment Guide for more information.

Query Development

Cross-Connection Query Optimization. This release of Toad Data Point includes a number of enhancements that optimize cross-connection query execution for improved performance.

 

Toad Data Point - Base and Professional Editions

The Base and the Professional editions of Toad Data Point contain the following new features and enhancements.

Pivot Grid

This release of Toad Data Point includes a redesigned Toad Pivot Grid with more functionality, a simplified workflow, an improved user interface, and an easy-to-use window layout.

New functionality includes exporting to an Excel pivot table, exporting data to Intelligence Central and Local Storage, and creating calculated columns.

Enhanced Pivot Grid Window. The Pivot Grid window is now easier to use.

  • You can now build a pivot grid by dragging fields from the field list to the field Area directly below the field list. This is similar to the workflow and layout found in Excel. You can also drag fields directly to the pivot grid.

  • The field Areas allow you to easily view which fields are applied to the grid, easily apply a filter to field values, and quickly change the field summary type, if necessary.
  • By default, the field list is docked above the field Area for easy navigation. In addition, the layout of the pane is now customizable.
  • Toolbar buttons and links have been added for some commonly-used actions, such as Export, Refresh, and Edit Query.

New Functionality

  • Export to Excel Pivot table. You can now export a pivot grid to Excel as an interactive Excel pivot table that includes the underlying result set. This provides you with a working pivot table in Excel along with the underlying data, allowing you to re-pivot result set data in Excel, if necessary.

  • Export to Excel Grid includes full rows. When exporting the summarized data to Excel as a data set (Excel Grid), the exported file now includes full rows of data wherever the pivot grid grouped data into merged cells.

  • Export to Excel includes customization. You can now specify a number of different options for the exported Excel file. This is similar to the customization available when exporting to Excel through the Export Wizard or the Select to File activity.
  • Create a calculated field. You can now create a calculated field. Use the expression editor to build an expression used to calculate the new field. The calculated field is added to the field list.

  • Add a field multiple times. You can now add the same field to a pivot grid multiple times.
  • Save data to Local Storage. You can now save pivoted data to a new or existing table in Local Storage.
  • Publish data to Intelligence Central. You can now publish pivoted data to Intelligence Central as a Dataset.

  • Enhanced Toad Pivot Grid Automation activity. The Toad Pivot Grid activity includes additional functionality. You can now export the pivot grid to an Excel pivot table. You can now export the pivoted data to Intelligence Central as a dataset. You can now save the pivoted data to Local Storage.
  • The Toad Pivot Grid file now includes the connection. The associated database connection is opened upon opening a saved Toad Pivot Grid file created in 4.3 (or later).
  • Edit the underlying query. You can now edit or execute the underlying query. Click Edit Query in the toolbar to open an editor pane where you can modify the query or execute it to preview data.

  • Customize field names. You can now rename fields to further customize your pivot grid to create meaningful reports when sharing the Pivot Grid or exporting to Excel or other document formats. Right-click a field and select Value Field Settings or Field Settings.

  • Customize Grand Total name. You can now rename the Grand Total fields. Right-click a Grand Total field name and select Rename Grand Total.

Workflow Enhancements. Frequently-used actions are now available through the right-click menu.

  • Easily change the way pivot grid values are summarized. Right-click a grid value or field and select Summarize Values By. For subtotaled fields, select Field Settings.

  • Easily change the way values are displayed. Right-click a grid value and select Show Values As.

  • Easily create and apply conditional formatting. Right-click the grid and select Format Rules | Manage Rules to open the Rules Manager. Create rules from predefined or custom conditions. Easily select cell background color, text appearance, etc.

  • Easily group columns or rows. Right-click a column (or row) header and select Group By.

  • To change number format, right-click a grid value and select Value Field Settings | Number Format.
  • In addition to the right-click menu, the Value Field Settings dialog can be used to specify all settings for a pivot grid (Data Area) field.

    • Right-click a pivot grid value or field and select Value Field Settings.

Backward Compatibility Information

In this release of Toad, the Pivot Grid tool allows you to edit and execute the underlying query. Toad Pivot Grid documents created and saved in this release of Toad include the connection information.

To upgrade a Toad Pivot Grid document created in a previous release of Toad, open the file in 4.3 and select a connection when prompted. Then execute the query (click Edit Query) and save the file.

Automation scripts with the Pivot Grid activity created and saved in a previous release of Toad are supported and should execute as expected when run using Toad Data Point 4.3.

Supported Data Set Size

If your result set contains a large number of rows (one million or more), you may experience a delay or reduced performance when sending data to, or working in, the Pivot Grid. For best results, work with a data set of less than one million rows. For larger data sets, try the following workaround.

Workaround: If your result set contains a large number of rows, build the pivot grid on a sampling of rows. Then use an Automation script to pivot all rows.

  1. Execute a query in the Query Builder or Editor, but do not read all rows.
  2. Send the sampling of rows to the Pivot Grid and create your pivot grid document.
  3. Create an Automation script using the Toad Pivot Grid activity with your pivot grid document as input.
  4. Run the Automation script to read all rows and refresh the pivot grid.

Query Development

Aggregate Field in Calculated Column. In the Query Builder, the Aggregate field is now enabled for Calculated columns in the Criteria (lower) pane.

Note: Although the entire list of Aggregate functions is available, select only a function applicable to the current Calculated column to avoid a database error.

Automation

Set Variable Activity. In the list of available Date functions in the expression editor, the Date function Round() has been replaced with the function RoundDate(). The functionality is the same. The Math function Round() remains unchanged.

Activity Result Variable. Instead of an empty string, the value of the "_ACTIVITY_RESULT" variable is now set to "Succeeded" when an Automation activity does not error.

General

Specify Foreground Execution Timeout. You can now specify a timeout for the execution of a SQL statement on the foreground thread. To set this option, go to Tools | Options | Database | Timeout.

Export to Excel - Consistent Export Options Dialog. When exporting to Excel, Toad allows you to customize file and worksheet options for the exported Excel file. This feature is available when exporting to Excel from a number of different Toad modules, including the Select to File activity in Automation, Transform and Cleanse, the Dimensional Viewer, and now the Pivot Grid. In an effort to make this customization process consistent among modules, Toad now provides a single, easy-to-use Export options dialog.

Toad Security. Beginning with Toad Data Point 4.3, Toad Security is no longer available by default. The option to implement Toad Security (Tools | Administer | Toad Security) is not enabled. To enable Toad Security, see Quest Support.

See Resolved Issues for more enhancements and resolved issues in this release of Toad Data Point.


 

Idea Pond

Got a great idea for a new Toad Data Point feature or enhancement? Share it with the Development Team and the Community by posting it on Idea Pond.

Visit Toad Data Point - Idea Pond where you can submit your ideas. You can also read and vote on the enhancement ideas submitted by other Toad users.

Learn More

Remember, you can find blogs, videos, and forums at the Toad Data Point Community.

  • Learn about new features from product video demos.
  • Find answers to your questions in the forums.
  • Learn tips and tricks from blog posts.
  • Find product documentation

Resolved Issues

Resolved Issues and Enhancements

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

Feature Platform Resolved Issue / Enhancement Defect ID
Automation N/A The drive letter in a network path is now translated to the full UNC name in a scheduled Automation script, as expected. QAT-10197
Automation N/A Enhancement: Instead of an empty string, the value of the "_ACTIVITY_RESULT" variable is now set to "Succeeded" when an Automation activity does not error. QAT-10230
Automation N/A Select to File and Export Wizard: Corrected an issue that was preventing Toad from completely clearing the worksheet before exporting to an existing Excel file when "Clear worksheet data before exporting" was selected. In this case, blank formatted rows remained after row count was reduced in subsequent exports. This correction is also in Toad Data Point 4.2.1. QAT-10778, QAT-10863
Automation N/A Export Wizard activity: If this activity exports to a macro-enabled Excel file, when the script is executed and the file does not exist, Toad now displays a descriptive error message instead of creating a blank .xlsm file. QAT-10688, QAT-10774
Automation N/A Dimensional Viewer activity: Corrected an issue which prevented the export of Calculated columns and Rollup columns when exporting to Excel. QAT-10399
Automation N/A Set Variable activity: Added helpful messages and tooltips hints that display if a date value is entered and requires single quotes. QAT-10547
Automation N/A Refresh Snapshot activity: If snapshot refresh errors when source table does not exist, the error is now reported in the script execution log, there is no error dialog, and the script fails. QAT-10305
Automation N/A Dimensional Viewer activity: Corrected an issue that caused an "Index out of range" error when executing a Dimensional Viewer activity after switching the Dimensional View file. QAT-10295
Automation N/A Set Variable activity: Corrected an issue that caused an error when attempting to execute a script in which a variable was defined using the function, Round(). In the Expression editor, the Date function Round() has been renamed to RoundDate(). QAT-10795
Automation Oracle Select to File activity: If multiple queries are used, each query now exports to a separate worksheet, even when the overwrite and the add suffix options are selected. QAT-10553
Automation N/A Run Automation Script activity: Corrected an issue that caused a "This file was not available at runtime" error when running a script in batch mode that contains a Run Automation Script activity and was created in a previous version of Toad. QAT-10508
Automation Oracle Set Variable activity: Corrected an issue in which the Set Variable activity evaluated a string value that included a date format using the forward slash delimiter (/) as an expression. QAT-11011
Automation N/A Corrected an issue in which an Automation script failed to error even though the connection in the Loop Dataset activity failed to connect. QAT-10298
Automation Oracle Export Wizard activity: If the Export Wizard activity connection does not have a saved password, the Automation script errors as expected, instead of prompting the user by opening a dialog. QAT-10996
Automation N/A Execute Script activity: If you attempt to publish a table that does not exist to Intelligence Central using the Execute Script activity, you now encounter an informative error message. QAT-10984
Automation N/A Execute Script activity: Corrected an issue that caused an error message dialog to open instead of presenting the error message in the log file only, as expected for an Automation script. QAT-10960
Automation N/A Set Variable activity: Using the DateTime Variable type and a single-quoted value is now supported as a bind in the Bind Parameters dialog and when used in a SQL statement. QAT-10962
Automation N/A Toad provides a more helpful error message now when an activity uses a file (such as a Toad document) and the file is missing at run time. QAT-10306
Automation N/A Corrected an issue in which a date value in a string variable was surrounded by single-quotes when expressed in a file name (i.e., filename_#MyVar#.xlsx was expressed as filename_'datevalue'.xlsx). QAT-10709
Automation N/A Pivot Grid activity: You can now export to Excel and append sheets to the same Excel file upon subsequent executions. QAT-10701
Automation N/A Compare Data activity: Corrected an issue that caused a "File in use" error when running two Data Compare scripts simultaneously. QAT-10789
Automation N/A Corrected an issue that caused an FTP connection error to be written to the Windows Event Log upon execution of a script containing an FTP connection. QAT-11234
Automation N/A Select to File activity: Corrected an issue that prevented Toad from notifying the user that there is an undefined variable if the query is originating from a linked SQL file. QAT-11418
Automation N/A Select to File activity: You can once again use the Expression editor to build a file name suffix. QAT-11058
Automation N/A Select to File activity: Corrected an issue involving using a suffix in the file name and the Overwrite option. QAT-11434, QAT-11394
Automation N/A Loop Dataset activity: Corrected an issue that caused an error in the Loop Dataset activity when the SQL included a comment. QAT-11415
Automation N/A Corrected an issue that caused Toad to incorrectly interpret a variable string value that contained a dash (-) or forward slash (/). QAT-11166
Connections Composite ODBC Corrected an issue that resulted in incorrect data values in TINY INT columns when displayed in Toad. QAT-10694
Connections Apache Hive HiveServer2: Improved user experience upon initial connection to a large Hive data source. Toad now maps only the current schema to reduce the delay when presenting objects in the Object Explorer, especially when multiple large databases are involved. QAT-10517, QAT-10557, QAT-10864
Connections SAP ASE In the SAP ASE Connection Properties dialog, you can now specify a default language to use for the connection. This value overrides your Regional Language setting, for this connection only. QAT-10368
Connections SAP HANA This release of Toad Data Point was tested against SAP HANA 2.0. QAT-10605
Connections Oracle This release of Toad Data Point was tested against Oracle 12c R2. QAT-10512
Connections Oracle Corrected an issue in which the user was prompted to commit data after closing a connection even though no data was changed. This issue also occurred when closing Toad or when a connection was idle for an extended time period. QAT-10851
Connections Amazon Redshift ODBC This release of Toad Data Point was tested with Amazon Redshift ODBC driver 1.3.6.1000. QAT-11160
Connections Business Intelligence, NoSQL Added an enhancement to improve mapping objects with very large row size from Business Intelligence and NoSQL data sources. QAT-10847
Connections Amazon Redshift ODBC Enhanced the Redshift ODBC connection to include the same features as a PostgreSQL connection. QAT-11161
Connections PostgreSQL ODBC Added support for PostgreSQL and Oracle non-standard passwords. For PostgreSQL, enclose password in curly brackets. QAT-11185
Connections SAP ASE Corrected an issue that caused "Domain error during conversion of INT value '0' to a BIT field" error in a SAP ASE connection when switching between databases. QAT-11655
Connections Ingres ODBC Corrected an issue that resulted in an error when trying to save changes to date fields through the data grid. QAT-11740
Cross-Connection Query Teradata Corrected an issue that caused an error when attempting to execute a cross-connection query with an LDAP connection to Teradata. QAT-6740
Data Compare N/A Corrected an issue in which cell formatting was not retained when data was exported to Excel. QAT-10194
Data Compare N/A You can now resize the Data Compare Wizard window. QAT-11326
Data Grid N/A Corrected an issue that caused some number columns to be treated as string values, for example when filtering or sorting, and to be displayed left-justified instead of right-justified. QAT-11107
Database Explorer Teradata For Teradata Views, the column type is now displayed in the Columns tab, as expected. QAT-10410
Dimensional Viewer Cross-Connection Corrected an issue that caused an error when refreshing after the underlying query was modified to now include a cross-connection query. QAT-10247
Documentation N/A The Beta Release Notes now include the resolved issues from previous Beta releases. QAT-10949
ER Diagram N/A Corrected an issue that caused an error when attempting to edit a Database Diagram (ER Diagram) file. QAT-11564
Export Wizard N/A Export to macro-enabled Excel: Corrected an issue that changed the order in which macros execute after opening the Export Wizard template. QAT-10903
Export Wizard N/A When opening an existing template which exported multiple objects to separate worksheets, the Export Options page did not show the correct target worksheet for each object. This issue has been corrected. QAT-10122, QAT-11018
Export Wizard N/A Corrected an issue in which exporting to Excel produced a file where CTRL+END moved to an empty row after the last populated row. Now CTRL+END moves to the last populated cell in an Excel export file as expected. QAT-10973
Export Wizard N/A Refined some workflow steps when selecting a Query or Query file from which to export. Refined steps include editing the query and using the Back button. QAT-2075
Export Wizard N/A When exporting multiple objects and you choose to include the SQL statements in the output file, all SQL statements selected are now included in the exported file, as expected. QAT-10976
Export Wizard N/A When exporting a very large SQL statement to Excel, the statement is now exported to multiple cells in order to include the entire statement and comply with Excel's 32,767 character limit. QAT-10977
Export Wizard Microsoft Access You can use a variable (#MyVar#) in the Access table name. QAT-11115
Export Wizard Teradata Corrected an issue that caused export to fail in the Export Wizard when using a bind parameter. The error message includes the following: "A null has been specified as the value for a parameter." QAT-11777
General N/A Toad Security is now disabled by default. To enable Toad Security, contact Quest Support. QAT-9887
General N/A Corrected an issue that caused an error when attempting to view column information for a table when the table name was a MySQL reserved word. QAT-8531
Import Wizard SAP ASE Corrected an issue that caused an error when attempting to import data into an identity column in an existing table. The issue involved the "Identity Inserts" option in the Import Wizard. QAT-10370
Installation N/A Corrected an issue that cause a "Could not load the DLL library ...TempCustomActions.dll" error during installation for some users in a Windows 7 environment. QAT-10707
Job Manager N/A Corrected an issue that caused an error in the Task List pane in the Job Manager window when attempting to use the Job Manager. QAT-10492
Job Manager N/A Corrected an issue that caused an error in the Job Manager. The error occurred after selecting a computer/server in the Windows Tasks tab. QAT-10780
Migration N/A Customized toolbars are now migrated correctly from the previous version when a new version is installed. QAT-10676
Migration SQL Server Customized Editor Highlighting Styles for SQL Server are now migrated correctly from the previous version when a new version is installed. QAT-10621
Migration N/A Corrected an issue that prevented several user settings files from migrating correctly from a previous version when a new version was installed. QAT-10979
Object Explorer SAP IQ Support for Int and Integer for column type in the Create Table editor. QAT-10356
Options N/A Corrected an issue that for some users caused an error after clicking "Restore Defaults" in the Options dialog. QAT-11195
Pivot Grid N/A You can now edit the "Grand Total" label in a pivot grid. QAT-10721
Pivot Grid N/A Enhancement: You can now export to an Excel pivot table from a Toad Pivot Grid. QAT-8334
Pivot Grid Oracle Corrected an issue that prevented values from being displayed for a calculated column which did not have an alias. QAT-9178
Pivot Grid N/A Corrected an issue in which the underlying query was not sent to the Pivot Grid along with the result set from the Query Builder. QAT-11038
Query Builder N/A Corrected an issue where upper/lower case was used inconsistently when applying and referencing the name of a calculated field. QAT-9997
Query Builder Oracle Cross-Connection Corrected an issue that caused an "Invalid data source definition: ORA-01005" error when attempting to view the Venn diagram for a join in an Oracle cross-connection. This issue occurred with an Oracle connection using Windows Authentication. QAT-10695
Query Builder Teradata Corrected an issue that resulted in additional quotes around date values in the WHERE clause for the query generated in the Query tab. QAT-11186
Query Builder N/A User Interface: When the Query Builder Diagram contains multiple joins, attempting to remove a join removes the selected join as expected. QAT-11491
Query Builder N/A Corrected an issue in which Toad removed the "NOT" operator in this special case after the user attempted to Visualize the SQL statement after pasting it into the Query tab of the Query Builder. QAT-10752
Query Builder Netezza Added support for reverse engineering for Netezza connections. QAT-11796
SQL Editor N/A Corrected an issue that prevented some users from successfully opening a .sql file while Toad had an open connection. In this case, Toad would unexpectedly hang. This issue was encountered with a MySQL connection. QAT-10502
SQL Editor N/A Corrected an issue that caused an unexpected delay for some users when attempting to execute SQL in the SQL Editor. This issue was encountered with an Oracle connection. QAT-10850
SQL Editor IBM DB2 LUW Corrected an issue that caused Toad to pause indefinitely after applying the row limit to the Editor in Options | Database | General and then executing a query in the Editor. This issue was encountered only with an IBM DB2 LUW connection. QAT-11250
SQL Editor N/A A SQL Editor custom toolbar is now migrated when you upgrade to a new release of Toad if the bitness is the same. Note: A custom toolbar is not migrated if upgrading to different bitness of Toad, i.e., 32-bit to 64-bit or vice versa. QAT-11377
Toad Intelligence Central N/A Run Automation Script activity: When publishing a script containing a Run Automation Script activity and the child script includes a connection, the connection is now included in the Publishing dialog and the published script as expected. QAT-10427, QAT-10010
Toad Intelligence Central N/A You can no longer publish an Automation script that uses a macro-enable Excel file if the file is stored locally. To successfully publish, the .xlsm file must use a Network path. QAT-10688, QAT-10774
Toad Intelligence Central N/A If an Automation Script running in Intelligence Central executes a macro in an Excel spreadsheet, then Microsoft Excel must be installed on the Intelligence Central host computer. If Excel is not installed, Toad now displays a descriptive error message. QAT-10688, QAT-10774
Toad Intelligence Central N/A Automation - Dimensional Viewer activity: Corrected an issue that caused the connection information in the "Export to Intelligence Central" fields in this activity to be included in the Publishing dialog, even the fields were disabled by the user. QAT-10294
Toad Intelligence Central N/A Automation - Dimensional Viewer activity: Corrected an issue that prevented the user from publishing a script in which the Dimensional Viewer file used a cross-connection query. A message displayed indicating the script contained a Local Storage connection. QAT-10293
Toad Intelligence Central N/A Enhancement: You can now easily edit an object description. In the Object Explorer, right-click an object and select Operations | Edit Description. QAT-7277
Toad Intelligence Central SAP IQ, SAP HANA Corrected an issue that caused an error when attempting to publish a view containing a bind variable to Intelligence Central from an SAP IQ or SAP HANA connection. QAT-10333
Toad Intelligence Central N/A Significantly improved performance when publishing a very large number of rows (in this case, more than one million) as a View to Intelligence Central. QAT-10440
Toad Intelligence Central N/A Corrected an issue that caused a Timeout error when attempting to publish a very large number of rows to Intelligence Central as a dataset or as a snapshot. QAT-10908
Toad Intelligence Central Oracle You now encounter an error if attempting to publish an unsupported data type. Previously this issue resulted in publishing an object with an inaccurate number of rows. This issue was encountered when publishing a View. QAT-10099
Toad Intelligence Central N/A If an Automation Script running in Intelligence Central executes a macro in an Excel spreadsheet and the user account specified to run this script is not configured to execute macros in Excel, Toad now displays a descriptive error message. Instructions to resolve this issue are now included in the Help file. QAT-10993, QAT-10688
Toad Intelligence Central SQL Server You cannot publish from a SQL Server connection that uses Windows Authentication. If you attempt to do so, the Publishing dialog now provides an informative error message. QAT-10066
Toad Intelligence Central SQL Server To successfully publish from a SQL Server connection that uses SQL Server Authentication, the SQL Server user account must have db_datareader privileges and the view permission. QAT-10066
Toad Intelligence Central Oracle You cannot publish from an Oracle connection that uses Windows Authentication. If you attempt to do so, the Publishing dialog now displays an informative message. QAT-10942
Toad Intelligence Central Oracle Corrected an issue which prevented the user's Oracle ODBC driver from displaying in the Oracle drop-down list in the Advanced tab of the Intelligence Central Connection Properties dialog. QAT-11155
Toad Intelligence Central Oracle Corrected an issue that prevented publishing from an Oracle table with a non-standard, lower-case name. QAT-11172
Toad Intelligence Central N/A Corrected an issue that prevented successful publishing for SQL containing a WITH clause. Now a WITH clause can be published, with some restrictions (see the online Help). This issue was encountered when publishing an Oracle WITH clause. QAT-11159
Toad Intelligence Central N/A Corrected an issue that caused only a partial refresh of the Automation scripts window after pressing F5 (Refresh). QAT-11252
Toad Views N/A Creating a new Toad View by right-clicking and selecting "New Toad View" in the Toad View manager pane now works as expected. QAT-10959
Transform and Cleanse N/A Corrected an issue that could cause an error message to display when closing Toad after using the Transform and Cleanse or the Data Profiling tool. QAT-10967
User Interface N/A In the File | Recent Files list and the Recent Documents list, the entire file name is now displayed. QAT-9830
User Interface N/A Dimensional Viewer: The Detail Grid window (right-click | Show Details) now includes a horizontal scroll bar for easier viewing. QAT-8571
User Interface N/A Corrected spelling error in an ODBC message. QAT-10981
User Interface N/A Corrected an issue which for some users caused an inactive SQL Editor window to unexpectedly gain focus even though another window was active at the time. QAT-10419

Note: This list does not include every resolved issue for this release. To inquiry about an issue not listed here, please contact the Toad Data Point Team at the Toad Data Point community Web site.

Toad Intelligence Central: If you are publishing objects to Intelligence Central, review the Toad Intelligence Central - Release Notes.


Known Issues

Known Issues

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, if you open a Toad file in Toad Data Point 3.0 or later that contains a connection to Sybase ASE and was saved in Toad for Data Analysts 2.7 (or earlier) the file opens in an untitled Editor window. Use the following workaround which is for a Query Builder file, but a similar method can be used for any Toad file.

Workaround 1:

  1. If you receive a message stating that the saved file cannot be opened, close the message pop-up. You will see that your Toad Query Builder document is open in an Editor window. Send this document to the Query Builder (Editor | Send to Query Builder).
  2. Save the new Query Builder document as a new Toad file.

Workaround 2:

  1. Open the Toad file in Notepad.
  2. Use Find and Replace to change all instances of "sybase" (all lowercase) to "Sybase" (first character uppercase, with the rest lowercase).
N/A
General 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
General Salesforce

After successfully changing the password or token for a Salesforce connection in Toad, attempting to open a Toad document created in a previous version (3.7 or earlier) using this connection results in a "Could not resolve connection" error.

Workaround: Recreate the Toad document (Import/Export template, Query Builder file, Automation script, etc.) using Toad Data Point 3.8 or later.

N/A

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 Data Point does not support installation paths that contain UNICODE characters.

N/A

Toad Data Point 3.0 or later doesn’t support User IDs that contain Unicode characters. ST90367, ST90372
The Toad Data Point Read Only installation is read-only for all databases, with the exception of MySQL. If you are using a Read Only installation of Toad Data Point, you will be able to modify a MySQL (and only MySQL) database. N/A

Currently, you cannot install Toad Data Point to a path that contains non-English characters. By default, Toad Data Point 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

ST66330
Installation n/a

During installation on Windows 8, some users might encounter a prompt from Windows to install .Net Framework 3.5.

Workaround: In the Windows prompt, click Skip this installation to instruct Windows Not to install .Net Framework 3.5.

N/A

Startup

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 the default installation directory in C:\Program Files\.

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 Data Point 4.3

N/A

Connections

ODBC

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

  • Sybase Advantage

  • Oracle RDB

  • Progress OpenEdge

  • 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 the MySQL ODBC driver to 3.51.27.00 or later to display table columns.

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:

  1. To open a password-protected Access connection, right-click the connection in the Navigation manager and select Properties.
  2. Select the Advanced tab and enter the password.
  3. Select the Save password checkbox and click Connect.

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
Connections Vertica ODBC

When using the Vertica ODBC driver version 6.1.1, data containing UTE-8 characters does not display correctly.

Workaround: Right-click the Vertica ODBC connection in the Connections Manager and select Properties. In the Connection Properties dialog, in the General tab, enter the following in the ConnectionString field:

ColumnsAsChar=0

ST109484
Connections Amazon Redshift You might experience problems after a Redshift connection is unexpectedly dropped. QAT-2194
Connections Amazon Redshift After canceling a Redshift query it might continue to run on the server. QAT-2195
Connections Amazon Redshift

When a Redshift connection in Toad is inactive for a period of time, attempting to access the connection can result in an error.

Workaround: Change the Windows TCP/IP timeout settings as recommended by Redshift. See "To change TCP/IP timeout settings" at http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html.

Caution: Editing your Registry incorrectly can cause serious, system-wide problems. It is advised that you back up your registry before modifying it.

N/A

Connections N/A

Exported connections: A connection file exported from Toad Data Point 3.6 or later cannot be imported into version 3.5 or earlier.

N/A

Connections MongoDB For a MongoDB 3.0 (or later) connection, the user must have Read/Write privileges in the MongoDB database in order to view sub-tables (MongoDB embedded documents).

TIC-5520

Automation   All

If Toad Data Point 4.3 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 Data Point 4.3 not as administrator, or turn UAC off, or close Outlook when adding the Send Email activity in Automation.

  ST80857
Automation All

When Toad runs as an application in a Citrix environment, scheduled scripts might not execute if the user who scheduled the tasks is not logged on. In addition, an "Access Denied" error is logged for the scheduled task in the Windows Scheduler.

Workaround: Install and run Toad as a desktop when using Toad with Citrix.

N/A

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:
Download the latest Ingres 9.3 ODBC driver.

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:
Use the actual execution plan button to generate execution plans for SQL that contains a temp table.

N/A
Export Wizard/ One Click Export 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

 

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 - 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
Library N/A

A UAC setting at the highest level might interfere with the ability to drag a file to the Library window (from Windows Explorer) to add it to the Library.

Workaround: Set UAC to the default level to enable adding a file by dragging it to the Library window.

N/A

Local Storage N/A

Issue: Local Storage is incompatible with previous versions of Toad.

If you upgrade to Toad Data Point 3.6 from a previous version, Local Storage upgrades silently and can no longer be used by the previous version of Toad Data Point (3.5 or earlier).

If you plan to uninstall 3.6 after installing it and then resume using a previous version, backup your Local Storage data prior to installing 3.6.

To backup Local Storage data

  1. Navigate to C:\Users\username\AppData\Local\Quest Software\Toad Data Point Hub Data.
  2. Make a copy of the Toad Data Point Hub Data folder and save it using a new name (such as Toad Data Point Hub Data 3.5 backup). If you uninstall 3.6, just move this copy back and use the original folder name.
QAT-3812
Object Explorer/ Database Explorer Sybase ASE When viewing a table that contains a BIGTIME data type column, attempting to select the Data tab causes Toad to unexpectedly quit.

N/A

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/
Query Builder

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
Query/
Query Builder
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
Toad Intelligence Central All

When data includes high-precision numbers (i.e., those with a large number of decimal places), results from publishing to Intelligence Central may not always be as expected. In some cases, data may be truncated to include not more than 15 significant digits.

N/A
Toad Intelligence Central N/A

Background: In Toad Data Point 3.5 or later, your Intelligence Central user name must be lower-case.

Issue: In Toad Data Point 3.5 (or later), if you attempt to open a previously-saved connection to Intelligence Central 2.2 (or earlier) in which the user name contains upper-case letters, the connection will error.

Solution: Upgrade to Intelligence Central 2.3.

N/A
User Interface N/A

Issue: Toolbar sub-menus and buttons disappear when selected. If you experience this issue, use the following workaround.

Workaround:

  1. In Toad, select Help | About and select the Application Data Directory link to open this directory. Then exit Toad.
  2. In the App Data directory, open the Session sub-directory and delete the Analyst.tss file. Restart Toad.
  3. In Toad, select Tools | Configuration Wizard. Click Finish to close the wizard without selecting an option. The default option will be applied.
QAT-6045

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents