Chat now with support
Chat with Support

Toad Data Point 5.0 - Release Notes

Toad Data Point 5.0

Toad Data Point 5.0.x

Release Notes

Thursday, July 25, 2019

Contents

About Toad Data Point

With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management, and develop SQL more efficiently.

Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.

Toad 5.0.7 is a patch release with new enhancements and resolved issues.

New Features

New Features

Toad Data Point - Professional Edition

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

Toad Workbook

Toad Workbook is a completely new user environment of Toad. Use Workbook to dramatically simplify your report building process.

Every Workbook is made up of one or more workflows. A workflow is a sequence of steps, in which you create your database query and refine the result set. The result steps that you create using SQL Editor or Query Builder is used by all steps of the workflow. Once you are happy with your result you can output it to several locations at once or create reports in various formats.

Workflow Query Builder

In Workbook you can build multiple workflows and run them all using a single button. Save your workflows to work with them later and share reports easily using email.

You start by building your result set in Query Builder or Editor. Modify and refine your results using great Toad features like Transformation & Cleanse, Pivot Grid or Dimensional View. Output your results easily with a click to your local storage, TIC or present them as a PDF report or Excel or CSV spreadsheet.

You can easily use your result sets from Query Builder again. When you drag-and-drop the Query item from your workflow you will be asked to save your result set. After the result set is saved, it can be dragged into another Query Builder to join the two result sets.

  1. Start dragging the Query Builder item using your mouse from your workflow

  2. Select one of the following:
    • Save local - to save the result set into local storage
    • Toad View - to save the result set as a Toad view
    • Publish - to publish the result set to your TIC
  3. After having saved the item, you can drag it into another Query Builder and reuse it

Share your Workbook reports with multiple recipients. Click Create new email item to add a new email item and then right-click to send email immediately, remove or edit the email item.

Toad Intelligence Central

Support for New Toad Intelligence Central 5.0 Features

This release of Toad Data Point includes support for the following new features in Toad Intelligence Central 5.0.

Folders in Intelligence Central

Beginning in Toad Intelligence Central 5.0, a new type of folder is available for storing objects: the secured folder. Secured folders have visibility (sharing), manage, and publish privileges assigned to them. Non-secured folders do not. An Intelligence Central server can have one or both types of folders.

  • Non-secured folders are visible to all users.
  • Secured folders are special folders in Intelligence Central and are visible only to users with which the folder has been shared. A secured folder can be managed by users with manage privileges to the folder. Users with publishing privileges can publish to the folder.

Secured Folders

Review the following important features of Secured Folders:

  • When an object is published to a secured folder, the object automatically inherits the sharing (visibility) and manage privileges applied to the secured folder. The object’s privileges are defined by the folder's privileges.
  • Users with manage privileges to a secured folder can specify which users are allowed to publish to the folder.
  • In non-secured folders, privileges are granted and managed for objects individually, as before.
  • For an Intelligence Central server, an Administrator configures which user role/roles are allowed to create secured folders and which types of folders can be created.
  • A secured folder is created at the time an object is published or at any time through the Object Explorer.

  • A secured folder can be created at the root level or within another secured folder. A secured folder cannot be created within (or moved into) a non-secured folder.
  • After a secured folder is created, users with manage privileges to the folder can modify its sharing and manage settings.

  • Changes made to the sharing or manage settings of a secured folder are automatically applied to all objects and files in the folder.

Additional New Features

Icons Display Status for Snapshots and Scripts

You can now easily determine the status of published snapshots and Automation scripts based on the icon that is displayed in the Object Explorer.

The following new icons are used to indicate an object’s current status.

  • Snapshot pending refresh
  • Snapshot currently refreshing
  • Snapshot with error
  • Automation script currently running
  • Automation script that failed with error

PostgreSQL ODBC Connection Enhancements

This release includes a number of enhancements to the PostgreSQL ODBC connection, including additional functionality designed specifically for PostgreSQL users.

You can now create a PostgreSQL ODBC connection without defining a data source name (DSN).

To create a PostgreSQL connection, select Connect | New Connection. Select PostgreSQL from the list.

  • To create a connection without using a data source, clear the Use data source name check box to display driver names. Select a driver and enter a server name, port number, and database.
  • To create a connection using a data source, select Use data source name and then select one of your predefined data source names from the list. For convenience, only PostgreSQL data source names are displayed.

Materialized Views

  • Materialized views are included as an object type in the Object Explorer for a PostgreSQL connection.

  • Materialized views are supported in code completion in the SQL Editor and Query Builder for PostgreSQL connections.

Indexes

  • Indexes are displayed as an object type in the Object Explorer for PostgreSQL connections.
  • Enhancements to the Create Index dialog allow you to easily specify index properties.

Sequences

  • Sequences are now displayed as an object type in the Object Explorer for a PostgreSQL connection.

Database Diagram and Database Explorer (Viewer)

For PostgreSQL connections, the following enhancements have been implemented:

  • Existing relationships between tables are automatically displayed in the Database Diagram, Query Builder and Database Explorer | Relationships tab.
  • Existing relationships to tables in other schemas can be displayed in the Database Diagram.
  • For Tables, Indexes, Materialized Views, and Sequences, a Properties tab displays object information in the Database Explorer (Viewer).

  • For Tables, the following tabs are included in the Database Explorer (Viewer): Unique Constraints, Check Constraints, and Relationships .

    In addition, the Index tab provides concise, organized information about a table’s indexes.

PostgreSQL DateTime Formats

  • Toad now provides several pre-defined DateTime custom formats for PostgreSQL ODBC connections. To view these formats, go to Tools | Options | Environment | Grid and select the Custom tab in the Data Type Formatting section. Do not change the format name.

Additional Enhancements

  • Row count. For PostgreSQL connections, in the Object Explorer you can display the estimated number of rows for tables. To display the row count, click the Options icon in the Object Explorer toolbar and select Extra Columns | Number of rows.
  • Truncate table. The Truncate Table operation is now available for PostgreSQL connections in the Object Explorer (Operations | Truncate Table) and the Import Wizard.
  • Alter table. The Alter Table operation is now available for PostgreSQL connections in the Object Explorer (Operations | Alter Table).
  • The PostgreSQL Serial data type columns are identified as such in Toad where applicable.

Important: To use a PostgreSQL ODBC connection in Toad, the connecting user must have the SELECT privilege in the pg_catalog schema.

Connections

Microsoft SQL Azure. The following enhancements were added for SQL Azure connections.

  • Object Explorer—For SQL Azure connections, the table description can be displayed in the Object Explorer. Right-click a table and select Options | Extra Columns | MS Description.
  • Database Explorer (Viewer)—For SQL Azure connections, there is an Extended Properties tab in the Database Explorer. In addition, column descriptions are displayed in the Columns tab.

Microsoft Azure SQL Data Warehouse. You can now connect and build queries with Azure SQL Data Warehouse. You can use either the SQL Azure or the SQL Server connection type. An Azure SQL Data Warehouse connection is supported in the Object Explorer, Query builder, and in execution. Advanced features are not supported.

SAP HANA. In addition to the Professional Edition of Toad Data Point, the Base Edition now also provides the ability to create a connection to SAP HANA.

SharePoint Online. Toad Data Point now allows you to create a connection to SharePoint Online. To create the connection, use the SharePoint Create New Connection dialog to enter connection information and then select the SharePoint Online option.

Toad Data Point - Base and Professional Editions

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

Query Development

Easily Specify the Number of Rows to Fetch

You can now specify the number of rows to initially retrieve when executing a query in the SQL Editor or the Query Builder. The query retrieves the specified number of records and then pauses (Oracle) or stops (other platforms). When you scroll through the Results grid, additional records are retrieved on demand (Oracle) or through re-execution (other platforms).

  • In the Editor or Query Builder toolbar, click Fetch n rows and specify a value.

  • You can also set a default value for this option in Tools | Options | Database | General. The default value is overridden by the value specified in the Editor or Query Builder window.

Data Management

Data Profiling

You can now specify default values for some options used in the Data Profiling tool. The default values are used in new Data Profiling sessions. You can override the default values at the session level.

  • To specify default values, select Tools | Options | Environment | Profiling and then specify options to use in new Data Profiling sessions.

Automation

New Run Mode Variable

A new variable has been added to Automation: the Run mode variable. This string variable is created by the script and can be found in the script Settings. The value assigned to this variable is either Test or Production, depending on the environment selected in the script Settings at the time the script is executed.

FTP Activity

You can now instruct the FTP activity to retry the FTP connection if it fails. Specify the number of retries and a wait time.

Copy File Activity

You can now instruct the Copy File activity to retry the copy action if an error or timeout occurs. Specify the number of retries and a wait time.

Run Program Activity

You can now use the Root path variable (ROOT_PATH) in the Program and Run directory fields in the Run Program activity. You can specify a value for the Root path variable in the script Settings.

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.

System Requirements

System Requirements

Client Requirements

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

Requirement Details

Platform

2 GHz processor (recommended minimum)

Memory

8 GB of RAM minimum, 16 GB recommended

Additional RAM Requirements: Using Local Storage, Cross-Connection Query, Business Intelligence connections, or NoSQL connections can require an additional 500 MB of RAM. These features start processes (mysqld.exe, hubproxy.exe) which persist for the Toad session.

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

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

800 MB to install Toad

450 MB to run Toad

Additional Recommendations: For retrieving large queries, allow 10 GB free disk space (or more, depending on the size of the data being retrieved). After retrieving 2500 rows, Toad saves data in a TMP (.tmp) file in the user's Temp directory. These TMP files are deleted when Toad closes.

Operating System

Windows Server® 2008 R2 SP2

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

Windows® 7 SP1 (32-bit or 64-bit)

Windows® 8.1 (32-bit or 64-bit)

Windows® 10, version 1809

.NET Framework

Microsoft® .NET Framework 4.7.1

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.

Additional Software

Visual C++ Redistributable for Visual Studio 2015. This software is required. It is included in installation using the .exe installer. If using the .msi installer, ensure that this software is installed prior to installation. See Visual C++ Redistributable for VS 2015.

For 64-bit Toad Data Point, both 32-bit and 64-bit Visual C++ packages are required.

Prerequisites for the 2015 Redistributable—If you encounter a "Microsoft Visual C++ 2015 Redistributable is not installed correctly" error during Toad installation, do the following:

  1. Uninstall the Microsoft Visual C++ 2015 Redistributable using the Control Panel.
  2. Install the missing prerequisite software. See Universal C Runtime Update Prerequisites or use one of the following links:
  3. Run the ToadInstaller.exe again.
Database Client

DB2® Client

Toad no longer installs a DB2 Client along with the Toad application. When connecting to a DB2 database, ensure that you have a DB2 Client or IBM Data Server Driver installed. Toad supports DB2 Client versions 9.7.6 through 11.1.

Oracle® Client

Toad can connect to Oracle using Direct Connect (no Oracle Client required) or 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:

  • You cannot use Oracle Direct Connection in a cross-connection query.
  • To use an Oracle connection in a cross-connection query, you must install an Oracle Client (full install) or you must install the Oracle Instant Client plus the Oracle ODBC driver.

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 11 or later

Screen

Toad supports screen resolutions up to 3200 x 1800 and display DPI settings up to 150%

Server Requirements

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

Requirement Details

Native Database Server

Toad supports the following databases:

Oracle 10g R2, 11g, 11g R2, 12c, 12c R2, 18c

Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2016

SQL Server 2017

Notes: 

  • SQL Server Compact Edition is not supported.
  • Storage Management is not available on SQL Server Express.

IBM DB2 for LUW 9.5, 9.7, 10.1, 10.5, 10.5.0.5, 11.1

IBM DB2 for z/OS 10, 11, 12

Note: Toad may support IBM DB2 Express and SWE in addition to listed above servers but note that no testing was performed on it.

Note: Windows 8, 10 and Windows Server 2012 require the following Fix Pack in order to ensure registration of DLLs in Global Assembly Cache:

IBM DB2 LUW 10.5 Fix Pack 4
IBM DB2 LUW 10.1 Fix Pack 4
IBM DB2 LUW 9.7 Fix Pack 10

MySQL 4.1, 5.0, 5.1, 5.5, 5.6, 5.7

MariaDB 5.5.5, 10.2.8, 10.3.2 (using MySQL provider)

SAP ASE 15.5, 15.7, 16 SP03

SAP IQ 15, 16

SAP SQL Anywhere 10, 11, 12, 16

SAP HANA SPS 08, SPS 09, SPS 10, SPS 11, SPS 12, SAP HANA 2.0, SAP HANA 2.0 SPS 02

Teradata 12.0, 13.0, 13.10, 14, 15, 16

Access® 2007, 2010, 2013, 2016

Note: To use Access 2016 64-bit to connect to an Access database in Toad, the Microsoft Access Database Engine is required and might not be included in the Access installation. The engine must match the architecture (bitness) of Toad.

Excel® 2003, 2007, 2010, 2013, 2016

Note: To use Excel 2016 64-bit to connect to an Excel or .csv file in Toad, the Microsoft Access Database Engine is required and might not be included in the Excel installation. The engine must match the architecture (bitness) of Toad.

ODBC Database Server

Toad Data Point 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:

  • DB2 for i5/OS V5R4 and IBM i 6.1, 7.3
  • EDB Postgres Advanced Server 10
  • Greenplum® Database
  • Informix Dynamic 10.00, 11.0 (limited testing)
  • Ingres Community Edition 2006 R2 on Windows 32-bit (limited testing)
  • Netezza Data Warehouse Appliance 4.6.6, 6.0, 7.0, 7.2.1
  • PostgreSQL® 9.5, 9.6.3, 10
  • Vertica 4.1, 5.0, 5.1 (with 4.0, 4.1 ODBC driver), 6.0 (with 6.0 ODBC driver), 6.1, 7.0, 8.1, 9.0

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 and Azure SQL Data Warehouse

Note:  To be able to utilize a majority of Toad functionality, please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

SQL Server databases running on Amazon EC2

Toad can manage Amazon RDS and any other cloud or service offering compatible with MySQL.

Business Intelligence Connections

Toad has been tested with, and supports, the following Business Intelligence platforms:

SAP Business Objects XI 3.1, 4.1

Oracle Business Intelligence Enterprise Edition 12.2

Salesforce.com®

Microsoft SQL Server Analysis Services 2016

Google Analytics™

OData version 4

SharePoint® Server 2013

NoSQL Connections

Toad has been tested with, and supports, the following NoSQL platforms:

Azure Table Services

Apache Cassandra™ 3.11.0

Amazon DynamoDB

Apache HBASE™ 1.2.6

Apache Hive™ 2.1.0

Cloudera Impala 2.2.0, 2.2.1, 2.9.0. Toad Data Point has been certified by Cloudera.

MongoDB™ 3.4.6, 3.4.9, 4.0

Toad Intelligence Central

This release of Toad Data Point has been tested with Toad Intelligence Central 4.3 and 5.0.

Note: Some publishing features in this release of Toad might not be supported in earlier versions of Intelligence Central. For more information about compatibility between Intelligence Central versions and Toad Data Point 5.0 features, see the New Features section of the Toad Data Point Release Notes.

VM and Cloud Platform Environments In general, the databases and data sources listed in this table are also supported when installed on a virtual machine (VM) or cloud platform. See the database or data source documentation for more specific information.
Additional Testing

Data Set Size

The following Toad Data Point functionality has been tested with data sets of up to 5 million rows: SQL Editor, Data Compare, Import Wizard, Export Wizard, Publishing Data to Intelligence Central.

For the following Toad Data Point modules, working with very large data sets can impact performance. For best results in these areas, work with data sets of less than 1 million rows: Dimensional Viewer, Pivot Grid, manually sorting a result grid, performing more than one Data Compare at a time (such as running multiple Data Compare Automation scripts simultaneously).

Notes:

  • Performance can vary based on available disk space and memory, CPU speed, and the bitness of Toad, as well as the type and number of columns.
  • It is recommended to use Toad Data Point 64-bit when working with large data sets.
  • Import and export functionality was tested with .csv files.
  • Performance testing was conducted using Toad Data Point 64-bit.

Virtualization Support

Requirement Details
Application Virtualization

When deploying Toad in a virtualization environment, for best results ensure the system accurately reflects the applicable client hardware and software requirements listed in this document.

Toad has been developed using Microsoft guidelines (see Remote Desktop Services programming guidelines) and can be deployed and operated in virtualization environments such as Citrix XenApp, Microsoft App-V, and VirtualBox.

Server Virtualization

Toad has been tested with the following:

  • Oracle VM 3.1 running on Red Hat Enterprise Linux 64-bit with Oracle 11gR2
  • Oracle VM 2.2 running on Windows 2008 32-bit with Oracle 11gR2

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

Note: The following exceptions exist for Power Users:

  • (DB2 only) A Power User can install Toad as long as this user belongs to the DB2ADMNS or DBUSERS group.

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

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

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

User Requirements and Restrictions for Running Toad

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

  • (DB2 only) A Windows Power User or Restricted User must belong to the DB2ADMNS or DB2USERS group. To add the user to one of these groups, select Start | Control Panel | Administrative Tools | Computer Management | System Tools | Local Users and Groups | Groups | DB2ADMNS or DB2USERS.
  • (DB2 only) A Windows Power User or Restricted User does not have the authority to add or remove DB2 catalog entries using the Toad Client Configuration wizard. However, these users can use the Import Profile function in the Toad Client Configuration wizard to import catalog entries to Toad.
  • (DB2 only) To take full advantage of Toad for DB2 LUW functionality, the user ID specified in the Toad connection profile for each DB2 for LUW database connection requires the authorizations listed in the following document:

    ToadDB2LUWAuthorizations.xls

  • (DB2 only) As a minimum requirement to manage a DB2 for z/OS subsystem in Toad, the user ID defined in the Toad connection profile for the subsystem must either have SYSADM privileges or SELECT privileges on the DB2 catalog tables. For a complete list of authorizations (and corresponding GRANT statements) a user requires to take full advantage of Toad for DB2 z/OS functionality, refer to the following document:

    ToadDB2zOSAuthorizations.doc

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

Resolved Issues and Enhancements

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 5.0.7

Feature Resolved Issue / Enhancement Defect ID
BI Connectors Sales Force now draws table relationships that are defined in the database. QAT-12312
General Support bundle now generates correctly. QAT-14988
Script Generation Generating INSERT statements now works instantly even for tables with large numbers of rows. TSS-1663/4512804
Pivot Grid Pivot Grid column subtotals can now be formatted. QAT-14608
Default subtotal summary type was changed to SUM for string values in Pivot Grid. QAT-14837
There is an new option to show aggregate total values for row categories that only have one value. The default is to not display totals when there is only one value. QAT-14998
It is now possible to display subtotals for single values. Click Set pivot grid properties on Pivot Grid toolbar to enable. QAT-14998
Query Builder Visualizing a customer Query in the Query builder corrupted the SQL. This has been fixed for the SQL statement provided for in the support case. QAT-14816
Visualizing a SQL provided by user was being corrupted and is now fixed. QAT-14427

Resolved Issues in 5.0.6

Feature Resolved Issue / Enhancement Defect ID
Automation An issue when Excel spreadsheet exported during Automation was not displayed is now fixed. QAT-14819/4498499
BI Connectors Sales Force now draws table relationships that are defined in the database. QAT-12312/4191253
BI Connectors MongoDB - An issue when relationship lines were not shown automatically has been fixed. QAT-14215
Connection Manager Cross-Connection queries on SAP ASE now work correctly with encryption. EncryptPassword=1 has been added to connection strings. QAT-14575
Installation Users should be able to deploy license keys during installation. This was broken in Toad Data Point 5.0 and is now fixed. QAT-14834/

4510329,

4516827,

4516600

Pivot Grid A scroll bar has been added to the row area in Pivot Grid. QAT-14705
Query Builder

Vertical scroll bar is now displayed in Cross-Connection Query Mode of Query Builder.

QAT-14749
Query Builder

A Group By button for aggregated functions has been added to Query Builder.

QAT-14609
Workflow Sometimes a workbook would not close and the user would see red X's. Usually this was seen with use of the SQL Editor. This has now been resolved. QAT-14833/4507486
Workflow When opening a Toad Workbook with pivot grids that had a lot of distinct rows (500k+) the UI would lock up. This has been fixed. QAT-14844
Workflow SQL used in workbooks that contained 50+ columns would prevent workbooks from opening. This is fixed and tested using 150 columns. QAT-14813

 

Resolved Issues in 5.0.5

Feature Resolved Issue / Enhancement Defect ID
Connection Manager

Displaying of database objects on SAP ASE 16 SP03 now works correctly.

QAT-13928
Data Cleansing In Transformation and Cleanse some rules use distinct values such as Find and Replace. The initial list of distinct values would display but upon subsequent occurrences of adding this rule the distinct list would be removed. This has been fixed. QAT-14728
General Oracle Business Intelligence 12.2.1.4.0 is now supported. TIC-11520
Local Storage Performance when using local storage table with (100K rows) in joins has been improved. TIC-11403
TIC Query Builder 2nd nested Subquery now shows correctly in Diagram Model. TIC-11405
Toad now works correctly with Hive object names that contain double underscore ('__'). QAT-14704
Workflow Users can now open Toad Data Point Professional and Toad Data Point Workbook at the same time. Running this side by side is allowed and functional. QAT-14710
You now can close and open Workbook windows during its loading. The background processes window is now left open during all of the loading and you can close it when you want to. QAT-14754
Performance when using data of 2M rows in Transformation and Cleance has been optimized. QAT-14481

Resolved Issues in 5.0.4

Feature Resolved Issue / Enhancement Defect ID
Connection Manager If there are Oracle client registry settings from uninstalled versions or paths that do not contain the OCI.dll, we will now continue and validate the rest of the homes in the registry. QAT-14672
SQL Editor Users can now select the directory to serialize large results sets. The option is located under Database | Script results QAT-14377
Workflow File | Close now closes workbook and all associated files QAT-14602
When loading workbooks or refreshing child steps with result sets, the icon has been changed from red execute to wait icon. The communicates that the child step is not re-executing the SQL but simply refreshing the data. QAT-14601
Loading a workbook will show the background processes and messages on what is occurring. When done the background processes will be closed. The background processes window and be opened at any time from the View menu or double click on running process bar. QAT-14599
When there are many columns to a result set the grid auto-sizes the column width to the data for easier reading. QAT-14596
Workbook was optimized so users can add new workflows during loading. The file size of workbooks has been reduced and the load time greatly optimized. QAT-14203
Saving workbooks now shows progress in the back ground progress window. This communicates when it is done. QAT-14195
Pivot Grid A pivot summary is saved to workbooks. When loading a workbook with a pivot the user can see his last pivoted results while the pivot is loading any saved data. QAT-14468

Resolved Issues in 5.0.3

Feature Resolved Issue / Enhancement Defect ID
Automation Fixed an Object reference error when using two Excel connections with Loop Connection activity in automation QAT-13670
Automation Usage connection from parent activity has been reworked. A new option From parent has been added which indicates whether the currently used connection should recursively search for parents QAT-13279
Data Compare & Sync 'Conversion Overflows' error when doing a data compare on a Microsoft Dynamics table has been fixed TSS-1628
General Views can now be displayed when connected to Hive using Native connector QAT-14069
Object Editor (DOE) Toad added support for the BOOLEAN column datatype which was introduced in DB2 LUW 11.1.3 TDB-3889
Workbook An issue when a user could not open Workbook has been fixed QAT-14239
Workbook

A new option in Tools | Options | Toad Workbook to control prompting behavior of Toad Data Point when embedding data with Workbook file has been added. If the number of rows exceed the threshold set, data will not be saved with a workbook or you will be promted. Saving more than 50,000 rows might have negative effect on performance.

QAT-14470

Resolved Issues in 5.0.2

Feature Resolved Issue / Enhancement Defect ID
Automation In an Automation script, if a Data Compare activity included a detail report in an email that used a suffix, the report would not be attached and throw an error. This has been resolved TSS-1633
Automation Error when .xlsm file could not be exported using Automation script has been fixed QAT-14201
Connection Manager SQL Server Connection error now displayed to the user is now formatted correctly TSS-1491
Object Editor (DOE) An issue in Create like connection feature has been fixed QAT-12420
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field QAT-14074
Publishing Wizard Publishing and running automation scripts using Impala connections now works correctly QAT-14224
Publishing Wizard An error when a calculated column would be mapped as BIGINT when publishing to TIC has been fixed QAT-14060
SQL Editor New option in Tools | Options | Editor | Tools | Auto highlight selected word enables auto highlighting of selected words TSS-1606

Resolved Issues in 5.0.1

Feature Resolved Issue / Enhancement Defect ID
Connection Manager Import Connections now supports import/browse connections from SSMS 18.0 TSS-1607
Connection Manager Contained user could not connect and display objects to SQL Azure database. This has been fixed TSS-1483
Data Compare & Sync Error when data cannot be filtered has been fixed QAT-14057
Installation Command line argument has been added to install 32 or 64 bit silently from Toad Data Point multi-bit exe installer QAT-12486
Pivot Grid Pivot Grid now supports Top N rows so one can sort and filter for top N values of pivoted data QAT-12434
Publishing Performance is now improved when retrieving values that are stored in blobs on Toad Intelligence Central QAT-14062
Query Builder When reverse engineering in the Query Builder on an Oracle connection using non-ANSI joins, columns would be duplicated and group bys lost. These are now fixed QAT-14075
Query Builder The Query Builder now supports INT 8 when connected to RedShift QAT-14071
Query Builder Corrected issue in Query Builder to reverse engineer SQL that contained a UNION and where condition QAT-13812
Query Builder Prior to executing mixed case aliases, the Query Builder would change to upper case causing the execution to fail QAT-13581
SQL Editor Executing of functions from Object Explorer for MySQL and subsequent executions with different parameters is now fixed QAT-14135
SQL Editor Corrected issue where function/procedure could not be executed that had a long parameter name when using SAP ASE connections QAT-13795

Resolved Issues in 5.0

Feature Platform Resolved Issue / Enhancement Defect ID
Automation N/A Dimensional Viewer Activity: The hint "Unsupported output format. Only XLS and XLSX formats are supported when exporting multiple tables" no longer displays when exporting multiple views to Local Storage or Intelligence Central. QAT-11822
Automation N/A Dimensional Viewer Activity: Corrected an issue that caused an error when attempting to run a script that exports multiple views to Intelligence Central and in which the Dimensional View query contains a bind variable. QAT-11834
Automation N/A Increased security in Automation scripts. QAT-11865
Automation N/A The error stack is now included in the log when the logging level is set to Verbose for an Automation script. QAT-11884
Automation N/A Clean Data activity: In a new activity, the Export File field is now clear, which allows you to select the Export to Local Storage and Export to Intelligence Central options. QAT-12090
Automation N/A Toad Pivot Grid activity: Corrected an issue that caused the following error when attempting to export pivot grid data to Intelligence Central when the query includes a variable: "Unable to export to Intelligence Central. Script contains undefined parameters." QAT-12078
Automation N/A Run Program activity: You can now use the built-in variable "ROOT_PATH" in the Program and Run Directory fields in the Run Program activity. QAT-12442
Automation N/A Corrected an issue that caused an error when attempting to evaluate the "_ACTIVITY_RESULT" variable value in an IF statement. In this case, the variable value contained the error message and this included the back slash character (\). This issue is related to QAT-12485. QAT-10207
Automation N/A Corrected an issue that caused an error when attempting to evaluate an expression in a variable and the expression contained the back slash (\) character (such as in a file path). This issue was encountered when attempting to compare the ROOT_PATH variable in an IF statement. QAT-12485, QAT-12493
Automation N/A FTP activity. Enhancement: You can now instruct the FTP activity to retry the FTP connection if it fails. Specify the number of retries and a wait time. QAT-10497
Automation N/A An Automation script now includes a new built-in variable: RUN_MODE. This variable contains a value based on which environment is selected in script Settings: Test or Production. QAT-7299
Automation N/A Corrected an issue which displayed a validation error in the Import Wizard activity when an Import template containing a cross-connection query was used, even though the script executed successfully. QAT-10622
Automation N/A Set Variable activity: Corrected an issue which caused an error when a DateTime variable was being referenced as an argument in the Concat() function. QAT-12550, QAT-12591
Automation Excel Corrected an issue in which the Excel connection failed to close after successful completion of a manually-executed script. The script executed a cross-connection query which included the Excel connection. QAT-11935
Automation N/A Execute Script activity: Corrected an issue in which clicking within the editor field and then selecting the Database field caused Toad to remove the query when the linked SQL file is a Query Builder file (.tsm). QAT-9297
Automation N/A Copy File activity. Enhancement: You can now instruct the Copy File activity to retry the copy action if it fails. Specify the number of retries and a wait time. QAT-12672
Automation N/A Corrected an issue in which the cursor repeatedly moved to the beginning of the user's text entry while entering text in the Description field of an Automation activity. QAT-12999
Automation N/A Corrected an issue that caused an error when attempting to send an email to a recipient in which the email address included an apostrophe ('). QAT-2491
Automation N/A Data Compare activity: You now have the option to generate a report that includes either all rows or different rows only. QAT-13016
Automation / General N/A Corrected an issue that prevented successful execution of SQL containing a WITH clause. This issue was encountered when attempting to publish using the Execute Script activity in Automation. QAT-12438
Connections Oracle Cross-Connection Corrected an issue that resulted in an ORA-01017 error when attempting to execute a cross-connection query after changing the password for the proxy user account used in the Oracle connection. QAT-11926
Connections SAP HANA The Base Edition of Toad Data Point now provides the ability to create a connection to SAP HANA. QAT-11920
Connections Toad Intelligence Central Corrected an issue that intermittently caused an error when attempting to create an Intelligence Central connection. This issue was encountered randomly during Automation script execution. QAT-11878
Connections HIVE When the user attempts to access a recently-created or recently-deleted table prior to manually refreshing the metadata (F5), Toad now displays a more-helpful error message. Previously, the user might encounter a "Value cannot be null" error message. QAT-12031
Connections Salesforce Corrected an issue in which existing relationships between Salesforce tables (objects) were not displayed in the Query Builder Diagram pane. QAT-12312
Connections ODBC Corrected an issue that prevented "Data source names" with very long DSN or host names from displaying in the "Data source name" drop-down list in the New Connection dialog for ODBC type connections. QAT-12439
Connections MySQL Corrected an issue that prevented a successful connection when using the SSL connection type in the Connection Properties dialog and the Native MySQL provider. In this case, the instance was on a Google Cloud platform. QAT-12631
Connections MongoDB Corrected an issue that caused the following error when attempting to connect: "The service is currently not responding. Please check your credentials and connectivity." QAT-12730
Connections SharePoint Online Enhancement: Toad Data Point now allows you to create a connection to SharePoint Online. Use the SharePoint Create New Connection dialog and select the "SharePoint Online" option. QAT-11977
Connections SQL Azure OS authentication is now supported for SQL Azure. QAT-10092
Connections Azure SQL Data Warehouse You can now connect and build queries with Azure SQL Data Warehouse. You can use either the SQL Azure or the SQL Server connection type. An Azure SQL Data Warehouse connection is supported in the Object Explorer, Query builder, and in execution. Advanced features are not supported. QAT-12804, QAT-13048
Connections PostgreSQL ODBC Added a warning message to inform users that do not have privileges to pg_catalog that it is required for a PostgreSQL connection. QAT-9855
Connections PostgreSQL ODBC Column comments are now supported in a PostgresSQL connection. QAT-13009
Connections MongoDB Corrected an issue that caused an error when attempting to connect to a database that contained no tables or only system tables. QAT-12730
Connections SQL Azure Corrected an issue that prevented successful connection using "contained users." QAT-11916
Cross-Connection Query N/A Corrected an issue that caused a "Cross Query Database SQL syntax error" when the Select list contains multiple columns with the same name. TIC-8359
Cross-Connection Query Excel Cross-Connection queries using an excel workbook located on mapped drive no longer produce errors. The mapped drive in the Excel connection is now resolved to full network path. QAT-12774
Cross-Connection Query N/A After changing the database user password, a cross-connection query uses the new password, as expected. QAT-13094
Cross-Connection Query N/A You can now reopen a report previously created through Tools | Reports | Data Reports that includes a cross-connection query. QAT-12395
Data Compare Firebird ODBC Corrected an issue that caused an error when attempting to compare two Firebird databases. QAT-11631
Data Compare N/A Corrected an issue that caused an "ORA-01756: quoted string not properly terminated" error when running the synchronization script for CLOB data. QAT-13164
Data Grid Teradata Corrected an issue that caused an error when attempting to edit data in the data grid for a Teradata connection. QAT-11211
Data Grid PostgreSQL ODBC Toad provides several pre-defined datetime custom formats to be used with the new enhanced PostgreSQL ODBC connection. To view these formats, go to Tools | Options | Environment | Grid and select the Custom tab for Data Type Formatting. QAT-10874
Data Profiling N/A You can now specify default values for the profiling options used in the Data Profiling tool. Go to Tools | Options | Environment | Profiling to set default values. The default values are applied when you open a new Data Profiling window. QAT-10759
Database Explorer SQL Azure Enhancement: For SQL Azure connections, there is an Extended Properties tab in the Database Explorer (Viewer). In addition, column descriptions are displayed in the Columns tab. QAT-10287, TSS-1418
Database Explorer PostgreSQL ODBC Corrected an issue that resulted in incorrect values when updating data through the Data tab of the Database Explorer. Use the new enhanced PostgreSQL ODBC connection by selecting PostgreSQL in the Create New Connection dialog. QAT-11687
Explain Plan SAP ASE Corrected an issue that prevented display of the Data Table format of the Explain Plan (View Plan | As Data Table). QAT-11379
Export Wizard N/A Corrected an issue that prevented Excel Slicers from functioning correctly in the Excel export file. This issue was encountered when exporting using the Select to File activity in an Automation script. QAT-9329
Export Wizard N/A Export Wizard and Export Wizard activity: Corrected an issue in which an edited Export template file failed to save changes after selecting a different linked Query file. In this case, the file contents were identical and the issue was discovered in the Export Wizard Automation activity. QAT-10948
Export Wizard N/A Corrected an issue that caused an error when attempting to export to Named Ranges in Excel. QAT-9844
Import Wizard Teradata Corrected an issue that caused an error when attempting to import a file with a large number of columns to a Teradata table. QAT-2436
Import Wizard SQL Server When importing data from Excel to SQL Server, cells containing "#NA" are imported as NULL, as expected. QAT-12488
Import/Export N/A When using the Import/Export dialog to import from an Excel file that is currently open, Toad displays an informative error message and then opens the Import Wizard to the Import Source page instead of the SharePoint List page, as expected. QAT-11823
Installation SQL Server You can now execute a DECLARE statement when Toad Data Point is installed in Read-Only mode. QAT-12625
Job Manager N/A Windows 10: Corrected an issue that caused an error after opening the Job Manager when Toad is installed in Windows 10. QAT-12593
Object Explorer Cross-Connection Corrected the source of an intermittent error found upon closing Toad after executing a cross-connection query. QAT-11939
Object Explorer SQL Azure Enhancement: For SQL Azure connections, the table description can be displayed in the Object Explorer. QAT-10287, TSS-1418
Object Explorer SQL Server Corrected an issue that caused slow performance when switching between object tabs (e.g., Tables and Views) in the Object Explorer. QAT-12327
Object Explorer SQL Server Corrected an issue that caused an error when attempting to create a stored procedure by selecting a stored procedure in the Programmability tab and then clicking the "Create a stored procedure" button or using the right-click menu. QAT-12113
Options N/A Selecting "Open Document" in Desktop Configuration Settings in Options | Environment | Desktop now works as expected. QAT-12878
Pivot Grid N/A Corrected an issue which caused in the following error when attempting to modify the Prefilter: "An error occurred in the Prefilter criteria." This issue also prevented an accurate list of available columns displayed in the Prefilter. QAT-11758
Pivot Grid N/A Corrected an issue that added a few extraneous rows to the exported grid when exporting to an Excel Pivot Table. QAT-11923
Pivot Grid N/A For aggregate values, enhanced legibility by reducing the number of decimal places in the default number format. QAT-11924
Pivot Grid N/A Corrected an issue that caused an error when selecting Value Field Settings from the right-click menu from a blank cell in the pivot grid. QAT-11925
Pivot Grid N/A Corrected an issue in which data values were prefixed with the "$" character after exporting to HTML, CSV, or PDF. QAT-12141
Pivot Grid N/A Enhancement: You now have the ability to find the "Top N" items in a field based on values in an aggregated column in the Pivot Grid. After sorting values in a column, right-click the field you want to filter and select Top N. Enter a value for N. QAT-12434
Project Manager N/A Enhancement: You can now specify a location to store the Project Manager file in Tools | Options | Environment | Network Share. QAT-12503
Query Builder N/A Corrected an issue encountered when removing joins in the Query Builder Diagram pane. QAT-9921
Query Builder N/A To ensure Toad retains the correct case in your custom Calculated Column name in the Query Builder, you can now enclose the column name in quotes. QAT-13581
Query Builder Toad Intelligence Central You can now edit or reverse engineer SQL that queries objects on Toad Intelligence Central. QAT-13178
SQL Editor N/A Corrected an issue which prevented Toad from indicating syntax errors when "Show Information pop-ups" is disabled in Options | Editor | Tools. QAT-10850
SQL Editor Cassandra Corrected an issue that caused an error when attempting to execute a query against a Cassandra database. TIC-8930
SQL Editor N/A Enhancement: In the Editor and Query Builder, you can now specify the number of rows to fetch. In the Options dialog (Tools | Options | Database | General) you can specify a default value for the number of rows to initially fetch in the Editor and the Query Builder. QAT-11677
SQL Editor IBM DB2 Added support for Nicknames in code completion. QAT-11921
SQL Editor Netezza ODBC Corrected an issue that prevented successfully executing against a temp table previously created in the same Editor window when the two statements were executed separately. QAT-12224
SQL Editor HIVE Corrected an issue that unexpectedly cleared the "schema" selection after the SQL was initially executed. QAT-12432
SQL Editor HIVE Corrected an issue that prevented successful execution of a SQL Select statement containing a WITH clause. QAT-12973
SQL Editor SAP ASE Corrected an issue in which Toad truncated the parameter name. QAT-13795
SQL Editor - Explain Plan SAP ASE Corrected an issue that prevented the display of the Explain Plan and correct Query Cost statistics in an SAP ASE connection. QAT-12217
Syntax support Apache Hive Corrected an issue in which SQL containing "union all" with "select count * " resulted in an error. QAT-13724
Toad Intelligence Central N/A Enhancement: For snapshots and Automation scripts in Intelligence Central, status is now indicated by the object's icon in the Object Explorer. For a description, see the New Features section of the Release Notes. QAT-11979
Toad Intelligence Central n/a Corrected an issue in which the status of "Running" was displayed for a script that was cancelled abnormally, such as when stopping a process. This issue resolution requires Toad Data Point 5.0 (or later) and Intelligence Central 5.0 (or later). QAT-12123
Toad Intelligence Central N/A Corrected an issue that caused an error when attempting to publish an Automation script that includes child scripts. QAT-12435
Toad Intelligence Central N/A Corrected an issue in which Automation scripts did not run successfully after migrating Intelligence Central data files to a new server. This resolution requires Toad Data Point 5.0 (or later) and Toad Intelligence Central 5.0 (or later). QAT-12502
Toad Intelligence Central N/A Run Automation Script activity: When publishing an Automation script in which the child script contains a variable and "prompt during run" is enable, the Publishing dialog now finds and displays the default value from the child script and allows the publisher to change the default value, as expected. QAT-12635
Toad Intelligence Central Oracle Corrected an issue that prevented successfully publishing SQL containing a Toad View to Intelligence Central as a view. QAT-10787
Toad Intelligence Central N/A Corrected an issue in which the drive letter in a network path was not replaced with the full UNC name during publishing. This issue was encountered when publishing a script containing an Import or Export template that used a non-SQL (Excel, CSV) file stored in a network location. QAT-11401
Toad Intelligence Central N/A Corrected an issue in which the corresponding schedule was not deleted when a scheduled snapshot was deleted in Intelligence Central. This issue resolution requires Toad Data Point 5.0 (or later) and Intelligence Central 5.0 (or later). QAT-12288
Toad Intelligence Central N/A We have provided a work around to support unicode literals in cross-connection queries. QAT-12299
User Interface N/A Dimensional Viewer: The helpful quick start graphic now displays after opening a new Dimensional Viewer window. QAT-11710

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.

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