Toad Data Point 4.2 - Release Notes

Release Notes

Toad® Data Point 4.2.1

Release Notes

Friday, June 23, 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 4.2.1

Toad Data Point 4.2.1 is a maintenance release and includes resolved issues and minor enhancements. See Resolved Issues and Enhancements for more information.

Toad Data Point 4.2 - Professional Edition

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

Toad Intelligence Central

Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.

Publish View with Variable in SQL

You can now publish a view that contains a variable. This new feature allows data providers to include variables in a published view so data consumers can change the value prior to viewing the result set.

Note: This new feature is supported in Intelligence Central 3.3 or later.

  1. To use this new feature, create a query containing a variable.

  2. Then publish the query as a View. The Publishing dialog allows the publisher to specify a default value for each variable in the SQL at the time of publishing.

  3. After publishing, the View owner or users with Manage privileges can modify the default value. In this way users can enter their own variable values prior to viewing the result set.

    To edit the variable default value, in the Object Explorer right-click the View and select View Details. Select the Variables tab and click the Edit default variables button .

  4. In the Web interface for Toad Intelligence Central 3.3 (or later), a similar feature allows users to enter a value for each variable in the SQL prior to Downloading the view. See the Toad Intelligence Central Quick Start Guide for more information.

Prompt for Variable Value when Running Published Automation Scripts

Note: This new feature is supported in Intelligence Central 3.3 or later.

This release includes a new feature for Automation scripts that allows you to instruct Toad to prompt for a variable value at run time (for manually-executed scripts). This feature is supported for an Automation script executed locally or for a published script executed in Intelligence Central.

This feature applies to the following types of scripts:

  • An Automation script containing a Set Variable activity. The Prompt during run option must be selected.

  • An Automation script containing a Send Email activity. The Prompt option must be selected.

Review the following feature details:

  1. To use this feature, create an Automation script containing either a Set Variable activity or a Send Email activity.
  2. In the Set Variable activity, select the Prompt during run option. In the Send Email activity, select the Prompt option.

  3. Publish and specify default value. Publish the script. The Publishing dialog allows the publisher to specify a default value for each variable in the script.

  4. Prompt for run-time value. When a user manually executes the published script, Toad prompts for a run-time value for each variable in the script. The new value is used in this execution only and the default remains unchanged.

  5. Edit default value. After publishing, the script owner or any user with Manage privileges can modify the default value. To modify the default value, select the script in the Object Explorer and click the Edit script default variables button . If the script is scheduled, the default value is used in the scheduled execution.

  6. In the Web interface for Toad Intelligence Central 3.3 (or later), a similar feature prompts the user for a variable value when the user attempts to manually run an Automation script. See the Toad Intelligence Central Quick Start Guide for more information.

Publish Data from Dimensional Viewer Using Automation

This release includes a new Automation activity which allows you to export or publish data from a Dimensional View. Use this new activity in Automation workflows such as the following:

  • Publish Dimensional Viewer data to Intelligence Central as a dataset. You can publish each view (container) in the Dimensional Viewer document to a separate dataset.
  • Publish Dimensional Viewer data to an Excel file. Then add a Publish File activity to your script to publish the Excel file to Intelligence Central.

Improved Error Messaging. For scheduled scripts running on Intelligence Central, Toad provides improved error logging and more meaningful error messages.

Data Management

Dimensional Viewer

This release includes several new enhancements to the Dimensional Viewer. You can now export all views to a file or location, publish data to Intelligence Central, and edit the underlying query.

  • Export All Views to Excel or Local Storage. You can now export all views (containers). Multiple views can be exported to multiple worksheets in an Excel file or to multiple tables in Local Storage.
    • To export to Excel, click Export All in the Wizard bar.
    • To save to Local Storage, click Local Storage in the Wizard bar.

  • Publish Data to Toad Intelligence Central. You can now publish view data to Intelligence Central as a dataset. Publish either a single view or publish multiple (or all) views. Each view is published as an individual dataset.
    • To publish a single view, right-click within the view and select Send To | Publish Container.
    • To publish multiple (or all) views, click Publish Data in the Wizard bar. Then in the Publishing dialog, click Publish Detail to select which views to publish. You can also give each dataset (container) a unique name.

    Note: Publishing to Intelligence Central requires access to a Toad Intelligence Central server.

  • Edit Query. You can now edit the underlying query for the Dimensional View document. Click Edit Query in the Dimensional View window.

Connections

ODBC Connections - Enable Disk Caching to Improve Performance

  • For ODBC connections, you can now instruct Toad to cache object metadata and retain it between Toad sessions. Using this option can improve performance in future requests. To specify this option, select Tools | Options | Database | ODBC.

OData. This release includes support for OData version 4.

IBM iSeries ODBC. A Functions tab now displays in the Object Explorer for iSeries connections, as expected.

Azure DataMarket. In this release of Toad Data Point, the option to create a connection to Azure DataMarket is no longer available. See https://datamarket.azure.com/browse/data for more information about Microsoft's announcement to retire DataMarket.

Automation

Dimensional View Activity

This release includes a new Automation activity for exporting data from a Dimensional View. This new activity allows you to open an existing Dimensional View file, execute the query, and export the data to Excel, Local Storage, or Intelligence Central.

  • To use the Dimensional Viewer activity, drag it from the Automation toolbox to the script design area. Select an existing Dimensional Viewer file. Then select an export method and specify export options.

  • If the underlying query for your Dimensional View uses a variable or bind parameter, you can use the Set Variable activity to instruct Toad to prompt for a variable value during each script execution. See a description of this new feature in the Toad Data Point - Base and Professional Editions | Automation section.
  • Several other new enhancements are included in the Dimensional Viewer in this release. See the Toad Data Point - Professional Edition | Data Management | Dimensional Viewer section for more information.

 

Toad Data Point 4.2 - Base and Professional Editions

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

Query Development

SQL Recall

Oracle Connections. For Oracle connections, when you use F5 to execute all statements or click Run Script in the Wizard bar, all executed statements are now saved to SQL Recall.

Automation

Set Variable Activity

Prompt for Variable Value at Run Time. In the Set Variable activity, you can now instruct Toad to prompt for a variable value each time you manually execute the Automation script.

  1. To use this feature, specify a named variable and variable value using the Set Variable activity.
  2. In the Set Variable activity, select Prompt during run.

  3. Execute the script manually. Toad prompts you for a variable value by opening the Bind Variables dialog. Use the default value or enter a new value. The new value is used in this execution only and the default remains unchanged.

    If you schedule the script, scheduled execution uses the default value you specified through the Set Variable activity.

  4. When you build a script that uses the Set Variable activity to set the value of a bind parameter or variable for SQL located in another activity, this feature allows you to easily modify that value at run time without modifying the script.

    This feature also applies when scripts are published to and manually executed in Intelligence Central. See the Toad Data Point - Professional Edition | Toad Intelligence Central section to learn how this feature is used in published Automation scripts.

Send Email Activity

Prompt for Recipient Address at Run Time. In the Send Email activity, you can now easily instruct Toad to prompt for a recipient email address each time the Automation script is manually executed.

  1. To use this feature, add a Send Email activity to your Automation script. Specify a default value in the To field.
  2. Then select the Prompt check box. This instructs Toad to treat this field as a variable field and to prompt for a value.

  3. Execute the script manually. Toad prompts you for a variable value by opening the Bind Variables dialog. Use the default value or enter a new value. The new value is used in this execution only and the default remains unchanged.

    If you schedule the script, scheduled execution uses the default value you specified in the To field.

    This feature also applies when scripts are published to and manually executed in Intelligence Central. See the Toad Data Point - Professional Edition | Toad Intelligence Central section to learn how this feature is used in published Automation scripts.

Set Variable and Set Variable Value Activities

  • Reorder Variable List. In the Set Variable and the Set Variable Value Automation activities, you can now reorder the list of variables.

Email Server Settings

  • You can now select between SSL or TLS when specifying a secure email connection. You can specify email server settings in the Send Email activity or in script Settings | Compose Email.

Select to File Activity

  • Export File Name Suffix. When appending a suffix to the export file name, you can now only select a date or datetime suffix. To include a variable or expression in the suffix, use the Set Variable activity to define a variable or build an expression. Then use the variable as a suffix in the export file name by entering the hash symbol before and after the variable name (#VariableName#).
  • This change also applies to the Clean Data activity.

Connections

Support for SQL Server 2016

  • Toad Data Point has been tested with SQL Server 2016. In addition to this release, Toad Data Point 4.1 has been tested with SQL Server 2016.

IBM DB2 Connection String

  • You can now use a connection string to define a DB2 connection. To use this method, select the Connection string option in the Create New Connection dialog. Then enter connection information in the fields. The connection string is displayed in the Connection String text box.

Improve Oracle Query Performance

  • This release includes a new option that allows you to improve query performance for Oracle connections by fine-tuning the batch size for your query. To use this feature, go to Tools | Options | Database | Oracle. In the Number of rows to fetch in all queries field, specify the number of rows to fetch.
  • As an alternative option, select the Default check box to allow batch size to be adjusted automatically.

Installation

Microsoft .NET Framework Requirement

This release of Toad requires Microsoft .NET Framework version 4.5.1 where .NET 4.5 was previously required. See the System Requirement in the Toad Data Point Release Notes for .NET requirements for your operating system. During installation, if .NET 4.5.1 is required and not detected, installation stops, Toad provides a link, and you are prompted to download .NET 4.5.1.

Start Menu and Application Directory

  • By default, you will now find Toad Data Point under Quest Software in the Start menu.
  • The default location for the Toad Data Point application directory (fresh install) is now under Quest Software.

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.

Resolved Issues in 4.2.1

Feature Platform Resolved Issue / Enhancement Defect ID
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. QAT-10778, QAT-10863
Automation N/A

Select to File: When specifying the export file, you can now select to use a macro-enabled Excel file type (.xlsm).

Note: The Select to File activity does not execute macros. To execute macros, continue to use the Export Wizard activity.

QAT-10781
Automation N/A Select to File: Corrected an issue that prevented successful generation of the file name date suffix in a script created in a previous version of Toad and run in batch mode. The date suffix format created in a previous version is now supported, as expected. QAT-10859
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 Apache Hive You now have the option to manually refresh only one schema at a time. In the Object Explorer, right-click an object and select Refresh Schema. This enhancement applies to Hive and ODBC connections. QAT-10869
Connections Hive ODBC Corrected an issue that prevented objects and schemas from displaying correctly in the Object Explorer. This issue also caused an error when attempting to execute unqualified SQL. QAT-10870, QAT-10720
Connections Apache Hive When mapping objects upon initial connection or refresh, the schema name is now displayed along with the object name in the Background Process pane. QAT-10871
Connections Apache Hive Corrected an issue that caused a "Value cannot be null" error when the schema name is uppercase. QAT-10866, QAT-10717
Connections Apache Hive Cached metadata is no longer cleared periodically. This gives the user the option to refresh object metadata only when necessary. QAT-10867, QAT-10764
Database Explorer (Viewer) Salesforce Enhancement: For Salesforce connections, you can now right-click the data grid in the Columns tab and copy cells/rows or export to Excel. This enhancement also applies to other (non-dimensional) Business Intelligence and NoSQL data sources. QAT-10849

Resolved Issues in 4.2

Feature Platform Resolved Issue / Enhancement Defect ID
Automation N/A Select to File activity: Corrected an issue that caused an error when attempting to execute SQL containing a comment in the Preview SQL dialog. QAT-9380
Automation N/A When defining Email Server Settings for a script or in the Send Email activity, you can now specify to use either the SSL or the TLS protocol for a secure connection. QAT-8902
Automation N/A Corrected an issue that caused Toad to delete the log file for a previously scheduled and executed Automation script when the script was subsequently opened in Toad. QAT-9427
Automation N/A Execute Script activity: An error is no longer encountered when the SQL query contains valid SQL, but not a SELECT statement. QAT-9428
Automation N/A If Condition activity. Corrected an issue that caused a "'False', cannot be converted to boolean" error when executing a script containing an If Condition activity. QAT-9543
Automation N/A The Set Variable activity now retains leading zero in variable value, as expected. This issue was discovered when the variable value was set from data collected and stored in the dataset variable in the Loop Dataset activity. QAT-8917
Automation N/A Corrected an issue that prevented dynamically generated hyperlinks in the html version of a Toad Data Report from working correctly when this file is used as the body of the email in the Send Email activity. QAT-7165
Automation N/A Enhancement: When the Set Variable activity contains multiple variables, you can now easily reorder variables in the list using Up and Down buttons. QAT-9505
Automation N/A Corrected an issue that caused Toad to close unexpectedly when executing a scheduled Automation script. The script was one of several closely-scheduled scripts. QAT-9854
Automation N/A Corrected an issue that caused an error ("Unable to parse any SELECT statements from the SQL query") when running Select to File activity in an Automation script created in a previous version of Toad. QAT-10021
Automation N/A Corrected an issue in which a variable value containing a decimal separator was not handled correctly in a Windows environment with Region and Language set to German. This issue was encountered with the Execute_1_SQL result set variable. QAT-9819
Automation N/A Enhancement: In the Set Variable activity, you can instruct Toad to prompt for a variable value each time the script is manually executed. QAT-7672
Automation N/A Enhancement: In the Send Email activity, you can instruct Toad to prompt for the Recipient email address each time the script is manually executed. QAT-7672
Automation N/A Send Email activity: Corrected an issue that prevented a datatime variable from displaying correctly when inserted in the Subject line of an email. QAT-3599
Connections Cisco Information Server (Composite) ODBC Corrected an issue that caused Toad to hang when retrieving tables. This issue was encountered when the Cisco 7.0 driver was used. QAT-9656
Connections SAP IQ Added support for Russian characters for SAP IQ connection. QAT-9506
Connections Apache Hive Added support for Hive split() function. QAT-8867
Connections Oracle Added support for "=" character in Oracle user account password. QAT-9757
Connections OData Tested Toad Data Point with OData version 4. QAT-9114, TIC-6377
Connections IBM iSeries ODBC Functions are now displayed in the Functions tab in the Object Explorer for iSeries connections, as expected. QAT-9726
Cross-Connection Query Oracle The Oracle DECODE() function is not supported in a cross-connection query. If used, an informative message displays instructing the user to use the CASE expression instead. QAT-9683
Cross-Connection Query Oracle If the TRUNC() function, which is unsupported, is used in a cross-connection query, an informative message now instructs the user how to use an equivalent function instead. QAT-9679, TIC-6772
Data Compare and Sync Oracle Corrected an issue that prevented the millisecond component of the Oracle Timestamp field from converting correctly leading to inaccurate comparison results. QAT-9411
Data Compare and Sync N/A Corrected an issue that caused an "Unknown type found during storing data" error when result sets containing a GUID where compared using the Data Diff Viewer in the SQL Editor. QAT-9540
Data Compare and Sync N/A When exporting data comparison results to an .xls file, if the number of exported rows is larger than Excel limit, remaining rows are exported to additional worksheet/worksheets. This does not apply to .xlxs files. QAT-9254
Data Compare and Sync MySQL Corrected an issue that caused a "Query execution was interrupted" error when two or more tables are selected for comparison. QAT-9332
Data Visualization N/A Corrected an issue that did not correctly plot data points on the graph when dimensional grouping "Second" was used. QAT-8529
Database Explorer Apache Hive HiveServer2: Corrected an issue that caused an error when attempting to view data in the Database Explorer (Viewer) for a HiveServer2 connection. This issue occurred only when viewing the Data tab of the Database Explorer, not when executing/retrieving data in other Toad modules. QAT-8862
Database Explorer Apache Hive Data in Array data type columns now displays as expected in the Toad Data Point Database Explorer (Viewer), Data tab. TIC-6417
Database Explorer IBM DB2 Corrected an issue in which Toad in Read-Only mode was attempting to access SYS<xyz>Auth tables for a user account that did not have permissions. This resulted in a Security error and a suspended user account. QAT-10206
Dimensional Viewer N/A You can now create a dimensional view from SQL containing a bind parameter or variable. QAT-8494
Dimensional Viewer N/A Null values for a Time column now display correctly. QAT-9434
Dimensional Viewer N/A Null is now treated correctly when creating and using a Rollup field defined using the "Create N equal rollup" option. QAT-8191
Dimensional Viewer N/A If you input invalid values when defining a Rollup field, Toad now displays an informative warning message. QAT-8188
Dimensional Viewer N/A Corrected an issue that caused the view (container) to close after the "Second" component of a Date column was added to it. QAT-9279
Dimensional Viewer N/A If a Date column has a Null value, the date component columns now also have the Null value, as expected. QAT-9269
Dimensional Viewer N/A In a Rollup for a Date column, if Null values exist, Null is correctly displayed as the min value and can be included in one of the ranges. QAT-9259
Export Wizard N/A Corrected an issue that prevented Toad from detecting and listing the macros when exporting to a macro-enable Excel file using the Export Wizard. QAT-8550
Export Wizard N/A Corrected an issue that caused an error when executing a macro in a macro-enabled Excel file from the Export Wizard. This issue was encountered with Office 2013. QAT-9722
Export Wizard N/A Corrected an issue that caused Toad to hang after selecting a very large table or a query with a large result set on the Select Objects page of the Export Wizard. QAT-8401
Export Wizard N/A Corrected an issue that caused an error (The process cannot access the file <file name> because it is being used by another process) in an Automation script using the Export Wizard activity to export to a macro-enabled Excel file. QAT-10013
Export Wizard N/A Corrected an issue that prevented export to the correct cell (specified in the "Start export at" export option) when using an Export template created in a previous version of Toad. This issue was encountered when using the Export template in an Automation script. QAT-9893
Import Wizard Oracle Corrected an issue which caused the import of data into a CLOB column to fail. QAT-9800
Import Wizard N/A When the Import Wizard is loading preview data for a long-running query, a progress bar is displayed and the Next button is disabled until the process is finished and import can proceed. QAT-10076
Import Wizard N/A Corrected an issue in which a long-running query timed out before preview data was loaded. This prevented the import process from proceeding. This issue was encountered with a Teradata connection. QAT-9539
Local Storage N/A Corrected an issue that caused Toad to pause indefinitely with the log message "writing to local storage" during a long Automation script execution. QAT-9772
Object Explorer SQL Server Corrected an issue that caused a table's creation date to be displayed as a number instead of a date in the Object Explorer. This issue was encountered in the 64-bit version of Toad. QAT-9098
ODBC Connections ODBC Enhancement: You can now instruct Toad to retain object metadata between Toad sessions for ODBC connections (Tools | Options | Database | ODBC). This can improve performance in future requests. This issue was encountered in a Vertica ODBC connection. QAT-9727
Query Builder N/A When adding an IN clause using the Where Condition editor, values are no longer trimmed. QAT-9410
SQL Editor Oracle For Oracle connections, if you use F5 to execute all statements, all executed statements are now saved to SQL Recall. QAT-9312
SQL Editor Oracle Corrected an issue that resulted in an "ORA-25408: cannot safely replay call" error when attempting to connect to an Oracle database. QAT-9347
SQL Editor N/A Corrected an issue that caused Toad to hang when attempting to open or execute a sql file if the "Show information pop-ups for Objects" option is selected (Options | Editor | Tools). QAT-9826
SQL Editor Oracle Corrected an issue that intermittently caused a "You have uncommitted transactions…" message when no data update statements had been executed. QAT-9835
SQL Editor N/A Enhancement: You can now select text vertically in the Editor using ALT+click. This feature can be found in Toad Data Point 4.1, as well as 4.2. TDB-2343
SQL Editor N/A When executing a query, if there is not sufficient free space in the user's temporary drive, Toad displays an informative message and terminates execution. These temp files are deleted when Toad closes. QAT-10009
Toad Data Reports N/A The default format for decimal data types is now number instead of currency. QAT-9836
Toad Intelligence Central N/A Corrected an issue that prevented snapshot refresh status from displaying correctly for a Windows Authentication account. In this case, "Fetching status failed" was displayed for the refresh status when snapshot details were viewed (View Details | Information). QAT-9512
Toad Intelligence Central N/A Automation script: When publishing an Automation script containing a Loop Dataset activity with a linked SQL file, you are now prompted to embed the linked SQL prior to publishing to Toad Intelligence Central. QAT-9551
Toad Intelligence Central N/A Corrected an issue that caused an error when attempting to download a .sql file published from Toad for Oracle to Intelligence Central. QAT-9515
Toad Intelligence Central N/A Enhancement: For a script running in Intelligence Central, you can now cancel the script during a Pause activity. QAT-9821
Toad Intelligence Central N/A Automation scripts: For scheduled scripts running on Intelligence Central, Toad provides improved error logging and more meaningful error messages. QAT-8871, QAT-8872
Toad Intelligence Central N/A Automation script: Corrected an issue in which changes to the child script in a Run Automation Script activity where not successfully saved for a script running in Intelligence Central. QAT-9425
Toad Intelligence Central SAP ASE Corrected an issue that caused an error when publishing to an Intelligence Central server containing a version of Toad that is different than the version used to publish. QAT-9662
Toad Intelligence Central Redshift Corrected an issue that caused an error when attempting to publish data to Intelligence Central from a Redshift connection. QAT-9262
Toad Intelligence Central N/A Corrected an issue in which the user's edits to the Scheduler's configuration file (InitService.xml) were ignored. QAT-10060
Transform and Cleanse Data N/A Corrected an issue that caused Toad to close unexpectedly if an incorrect data type error was encountered when attempting to create a calculated column. QAT-9784
Transform and Cleanse Data N/A If you select Tools | Transform and Cleanse and then select Current Window, Toad now samples the first 1000 rows (or the specified sample size) instead of retrieving all rows. QAT-10036
User Interface N/A In the Save As dialog, Toad now provides a file extension (selected) in the File Name field to help the user provide a file name. QAT-8966

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 Resolved Issues: If you are publishing objects to Intelligence Central, you can 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.2.1

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.2.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 Data Point 4.2.1 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