Toad Data Point 6.0
Toad Data Point 6.0
Release Notes
Monday, June 27, 2022
Contents
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
- Snowflake®
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 |
SAP Business Objects™ | Google Analytics™ | OData | Oracle BI Enterprise | Salesforce® | SharePoint® | SQL Server Analysis Services |
| NoSQL |
Azure Table Service | Cassandra™ | Cloudera Impala | DynamoDB | HBASE™ | Hive™ | MongoDB™ |
Toad Data Point 6.0 is a minor release with new features, security enhancements, and resolved issues.
New Features
In Toad Data Point 6.0 the following new features were implemented:
Azure AD Universal with Multi-factor authentication (MFA) support for Microsoft SQL Azure
-
The 6.0 release enables you to create a more secure type of connection to Microsoft SQL Azure by using Azure AD Universal with Multi-factor authentication. It adds another layer of security in the form of an additional verification step.
Azure AD Universal with Multi-factor authentication (MFA) support for SharePoint
-
Another novelty offered by the latest release is the implementation of Azure AD Universal with Multi-factor authentication for SharePoint connections. It allows for stronger authentication via an independent confirmation of access and along with SQL Azure connections, it enables you to go through the authentication steps inside of the application, that is, without the need to use an external browser and having to switch windows.
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.
- Toad Data Point Videos - Learn about new features from product video demos.
- Toad Data Point Forum - Find answers to your questions in the forums.
- Toad Data Point Blog - Learn tips and tricks from blog posts.
- Toad Data Point - Idea Pond - Submit your idea to the Development Team.
Learn More
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:
|
|
Hard Disk Space |
800 MB to install 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® 2012 Windows Server® 2012 R2 Windows Server® 2016 Windows Server® 2019 Windows® 8.1 (32-bit or 64-bit) Windows® 10 |
| .NET Framework | Microsoft® .NET Framework 4.7.2 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 2019. 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 2019. For 64-bit Toad Data Point, both 32-bit and 64-bit Visual C++ packages are required. |
| 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:
|
| ODBC Driver |
In order to create a native Snowflake connection, you must install the ODBC Driver 2.24.2 (or later) provided by Snowflake. Upon installing and configuring the driver, Toad Data Point will be set for this type of connection. Note: New versions of the Snowflake ODBC Driver are backward-compatible, but there is no guarantee that earlier versions are forward-compatible. Active monitoring and maintaining of installed versions is advised. For more information regarding the process of creating Snowflake connections, please refer to the Installation Guide and User Guide. |
|
Additional Requirements |
Web Browser Microsoft® Internet Explorer® 11 or later Screen Recommended maximum DPI settings for Toad are 125%. It is possible to use Toad up to 200% but some dialog windows will not be completely usable anymore. Maximum tested resolution for Toad is 3800 x 2160 px. |
Server Requirements
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
| Requirement | Details | ||||||
|---|---|---|---|---|---|---|---|
|
|
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 SQL Server 2019 Notes:
IBM DB2 for LUW 9.7, 10.1, 10.5, 10.5.0.5, 11.1, 11.5
IBM DB2 for z/OS 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:
MySQL 5.0, 5.1, 5.5, 5.6, 5.7 MariaDB 5.5.5, 10.2.8, 10.3.2 SAP ASE 15.5, 15.7, 16 SP03 SAP IQ 15, 16 SAP SQL Anywhere 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:
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.9.0, 3.2.0 with CDH 6.3.2. 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 5.6. 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 6.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:
| ||||||
| Security |
|
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:
|
User Requirements
User Requirements to Install Toad
Only Windows Administrators and Power Users can install Toad.
Note: The following exceptions exist for Power Users:
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User—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:
-
-
- 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
The following is a list of issues addressed and enhancements implemented in this release of Toad Data Point:
Resolved Issues in 6.0
| Feature | Resolved Issue / Enhancement | Defect ID |
|---|---|---|
| Automation | TDP becomes unresponsive after the Add attachment button under the Send Email step is clicked when there are more than 9 If_Condition steps in the Automation script | QAT-16957 |
| Compare Object | Data Compare Wizard does not shows the equal records row count the same as in the Data Compare tab when this option is switched off from mapping, as well as Data Compare automation process report | QAT-17100 |
| Connection Manager | Establishing a connection using the previously renamed connection will rename it to "True" in the Navigation Manager panel | QAT-17257 |
| Data Compare & Sync | The initial connection used in the data comparison file (.dcp) as part of the Automation script will not be updated after being changed | QAT-17058 |
| Data Visualization | The TO_DATE function is shown under apostrophes after the Visualize Query option in the Query Builder tab is clicked | QAT-17332 |
| Data Visualization | “BLOB/TEXT column (column name) used in key specification without a key length” error is encountered when the user tries to visualize a MySQL table with TEXT data type | QAT-17085 |
| Data Grid | The Duration and Executed options are not displayed in the Query Builder and SQL Editor after the query is run | QAT-17320 |
| Import Wizard | The number of committed rows from the report doesn't match the actual number of rows committed to the database when importing data (Excel) to an existing table with a SQL Azure connection | QAT-16550 |
| Object Explorer | Databases disappear from Object Explorer after refreshing cached metadata for objects | QAT-17086 |
| Project Manager | The Publish to Intelligence Central window is not shown when the Publish File right-click context menu option in the Project Manager panel is clicked | QAT-17245 |
| Publishing wizard | “You have an error in your SQL syntax; check the manual that corresponds to your Data Service server version for the right syntax...” error is encountered when publishing a data as a result of a query that contains a variable on the Teradata connection | QAT-17391 |
| Publishing Wizard | “ODBC data source returned an error: ORA-00907: missing right parenthesis” error is encountered when publishing complex view to TIC | QAT-17278 |
| Publishing Wizard | “ODBC data source returned an error: ORA-00909: invalid number of arguments” error is encountered when publishing complex view to TIC | QAT-17277 |
| Publishing Wizard | “Access denied for user <user connection to 'Secure Folder'> Please enter a new name or drop the old artifact manually, if possible” message is encountered when a user with publish permissions tries to publish a file in a secured folder | QAT-17196 |
| Publishing Wizard | “ODBC data source returned an error: ORA-00905: missing keyword” error is encountered when publishing complex view to TIC | QAT-17191 |
|
Publishing Wizard |
The Publish to Intelligence Central window is not shown when the Publish File main menu option is used |
QAT-17345 |
|
Publishing Wizard |
The Publish to Intelligence Central window is not shown when the Publish File right-click context menu option in the Library tab is clicked |
QAT-17251 |
|
Query Builder |
The Left Outer Join clause is changed to the Right Outer Join after the Visualize Query option in the Query Builder tab is clicked |
QAT-17247 |
|
Query Builder |
"Oracle Database Error: ORA-01843: not a valid month" error is encountered in the Query Builder when executing a query that contains a date type column with added IN clause as a constant |
QAT-16406 |
|
Query Builder |
The additional apostrophes are added to data specified in the Where clause if the IN and NOT IN operators are used in the Query Builder tab |
QAT-16663 |
|
Query Builder |
The Description field in the Bind Variable dialog cannot be modified |
QAT-17091 |
|
Script Results |
The time is added to the Date data type columns in the Result Sets tab for the Snowflake database |
QAT-17059 |
|
Script Results |
"Value cannot be an empty collection. Parameter name: columnReaders " error is encountered when an Oracle query containing the standard_hash function is run |
QAT-16598 |
|
Script Results |
“Object reference not set to an instance of an object” error is encountered when running a script containing non-existent database object (table or view) |
QAT-17165 |
|
Script Generation |
The script will not be generated under the SQL Script tab in the Create index window for SQL Server |
QAT-17203 |
|
SQL Editor |
Connection does not change in the SQL Query Editor status bar when using the Editor as Script command from Object Explorer for second data source connection |
QAT-16594 |
|
SQL Editor |
The cursor does not follow the error line in the query for Oracle Client connection |
QAT-16592 |
|
SQL Editor |
SQL code is improperly formatted on a SQL Server connection when using the "Format SQL" option on a sql file which contains misaligned columns and lowercase keywords |
QAT-17229 |
|
Workbook |
The old name of the renamed bind variable is shown in the Variables dialog of the Toad Workbook |
QAT-17090 |
|
Workbook |
"Invalid column name 'calendar__gregorian__last_month__'" error is encountered when a workbook with a Toad View that contains the Data range variables is run |
QAT-17026 |
| Workbook | The calendar is not offered for picking variable value for date or datetime datatype in a workbook which was previously saved and reopened | QAT-17099 |
|
X-Query |
"Optional feature not implemented" error is encountered when doing a cross query between MySQL and MS Access with a WHERE condition which contains a column with "double" data type |
QAT-17159 |
Enhancements in 6.0
-
The embedded MySQL has been upgraded from 5.7.25 to 5.7.37.
-
MySQL Connector has been upgraded from version 8.0.24 to 8.0.29.