ToadDataPoint 6.4 ReleaseNotes
ToadDataPoint 6.4 ReleaseNotes
4
Release Notes
Thursday, January 9, 2025
Contents
Business Oracle Business Intelligence Enterprise Edition (OBIEE), SAP Business Objects™,
Intelligence Salesforce®, Microsoft SQL Server Analysis Services, Google Analytics™, OData, and
SharePoint®
NoSQL Azure Table Services, Cassandra™, Cloudera Impala, DynamoDB, HBASE™, Hive™,
MongoDB™
Toad Data Point 6.4 is a minor release with new features, security enhancements, and resolved issues.
New Features
In Toad Data Point 6.4 the following new features were implemented:
This list of predefined values will be saved in the Query Builder, Query Editor or Workbook file and transferred as a
part of any downstream step available in Toad (Pivot, Transform and Cleanse, Dimensional View…).
Selected values from the list can be changed at any point in time (before and during query execution)
in Toad Data Point/Toad Workbook or Toad Intelligence Central (if the objects are published). Another
novelty introduced with this feature is that you will be able to specify multiple values for a bind variable
when using the IN\NOT IN operator.
The options for creating a list of predefined variable values are available after clicking on the variable name link that
will open the Define variable prompt values window.
• Get values from the SQL script -This option allows you to specify a SQL query that will return a result set for a
single column which will be used to populate the list of predefined variable values.
For more detailed information about the feature, please refer to the Toad Data Point User Guide.
Toad Data Point 6.4 enables you to create a native connection to Databricks:
This type of connection will allow you to query Databricks data by utilizing the Object Explorer, Query Builder, and
SQL Editor in their full capacity. There are two types of authentications that you can use to connect to Databricks:
• Personal access token
• OAuth 2.0 Token
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.
Learn More
Remember, you can find blogs, videos, and forums at the Toad Data Point Community.
l Toad Data Point Videos - Learn about new features from product video demos.
l Toad Data Point Forum - Find answers to your questions in the forums.
l Toad Data Point Blog - Learn tips and tricks from blog posts.
l Toad Data Point - Idea Pond - Submit your idea to the Development Team.
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:
l Applications that are running on your system when using Toad
l Size and complexity of the database
l Amount of database activity
l Number of concurrent users accessing the database
Hard Disk 800 MB to install Toad
Space 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 Windows Server® 2016
System Windows Server® 2019
Windows Server® 2022
Windows® 10
Windows® 11
.NET Microsoft® .NET Framework 4.7.2
Framework 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 Visual C++ Redistributable for Visual Studio 2019. This software is required. It is included
Software 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.
To create a connection to an Amazon Redshift database you must install the Amazon
Redshift ODBC driver 1.3.1.1000 (or later version) on client computers accessing an Amazon
Redshift data warehouse. For each computer where you install the driver, there are the
following minimum requirements that you can find on the Amazon Redshift Web site.
For more information regarding the process of creating Amazon Redshift connections, please
refer to the Installation Guide and User Guide.
To create a native Databricks connection, you need to install Simba Apache Spark ODBC
Connector version 2.8.2 or newer.
Additional Web Browser
Requirements 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.
Network - Toad Data Point Subscription editions require the user to sign in when using the product.
This enables the product to verify the user's identity and to check that they are entitled to use
the subscription. To complete this entitlement check internet access is required to connect to
Quest Software's Licensing Servers.
- Toad Data Point Subscription edition includes Quest Auto Update, a service that periodically
checks for and delivers product updates. Quest Auto Update is configured to run
automatically using the Local Service account after successful installation, Product updates
are automatically downloaded, and a notification window alerts you to pending updates.
Quest Auto Update requires internet access and must be able to reach the cloud service at
https://autoupdate.toadworld.com
Server Requirements
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
Virtualization Support
Requirement Details
Application When deploying Toad in a virtualization environment, for best results ensure the system
Virtualization 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.
See "Install Toad on Citrix Systems" (page 1) for more information.
Server Toad has been tested with the following:
Virtualization l Oracle VM 3.1 running on Red Hat Enterprise Linux 64-bit with Oracle 11gR2
l 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:
l (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.
Query Builder Incorrect syntax error is encountered when using the DATE QAT-18608
function in a query on a Snowflake connection
Workbook Columns from the Diagram tab disappear upon opening a QAT-20150; QAT-
Workbook 20130
Workbook "Specified Cast Is Not Valid" error is encountered when QAT-19719
using a bind variable for a Timestamp column on
PostgreSQL connection
Workbook Binary datatype incorrectly displayed for Timestamp QAT-19718
column in Workbook Variables pop-up on PostgreSQL
connection
Workbook Pivot Grid work step does not reflect updates for field QAT-18609
aliases or unchecked/removed columns made in the query
step
Workbook Columns disappear from Transform, Pivot, and QAT-18559
Dimensional View steps after adding or modifying column
aliases in the query step
Known Issues
The following is a list of issues known to exist at the time of this release.
General n/a Highlighting style options in Editor settings cannot be migrated QAT-19434
or applied
General SAP ASE Using SAP ADO.NET client and SAP ODBC driver it is not TMB-1850
possible to convert any character set to all other character
sets.
General Sybase ASE Currently, if you open a Toad file in Toad Data Point 3.0 or N/A
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
General Salesforce After successfully changing the password or token for a N/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.
Installation/ All (MSI installs on Windows 7) If you are using MSI to install
Upgrade Toad on Windows 7 with UAC enabled, you can install a file N/A
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
Toad Data Point does not support installation paths that N/A
contain UNICODE characters.
Toad Data Point 3.0 or later doesn’t support User IDs that ST90367,
contain Unicode characters. ST90372
The Toad Data Point Read Only installation is read-only for all N/A
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.
Currently, you cannot install Toad Data Point to a path that ST66330
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
Installation n/a Previous installations cannot be uninstalled using TDP 6.2 QAT-19245
Base & Professional Installer (for 32-bit or 64-bit)
Workaround: Removing Toad Data Point using the Control
Panel
Installation n/a During installation on Windows 8, some users might encounter N/A
a prompt from Windows to install .Net Framework 3.5.
Workaround:
Upgrade the MySQL ODBC driver to 3.51.27.00 or
later to display table columns.
Connections Azure SQL You need to install Microsoft Active Directory Authentication QAT-14556
Database Library (adalsql.msi) to connect to Azure SQL Database using
Active Directory Password Authentication.
Connections Access Currently, for a password-protected Access database, ST94125
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.
Connections Vertica When using the Vertica ODBC driver version 6.1.1, data ST109484
ODBC 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
Connections Amazon You might experience problems after a Redshift connection is QAT-2194
Redshift unexpectedly dropped.
Connections Amazon After canceling a Redshift query it might continue to run on the QAT-2195
Redshift server.
Connections Amazon When a Redshift connection in Toad is inactive for a period of N/A
Redshift 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.
Export Pivot CSV Title: When exporting a Pivot Grid, if the "Always quote QAT-18981
Grid strings/char" option is checked, it is applied to all data types in
the exported CSV file
Export Pivot Excel/CSV When exporting a Pivot to an Excel or CSV file without any QAT-18990
Grid suffix and without overwriting the existing file, three
successive messages about file existence appear
Export CSV SQL code is not included in the exported CSV file if the QAT-19033
Dimensional "Include SQL statement in output file" option is checked when
View exporting Dimensional View
Import Wizard Excel Attempting to import data that was exported to an Excel N/A
instance where the fractional seconds were truncated results
in an error.
Attempting to import data from a template that contains ST77978
multiple worksheets results in an error.
ODBC - DB2 Currently, the Truncate table checkbox is disabled on the ST77986
iSeries, Select Target page when using an ODBC connection to a DB2
Netezza iSeries or Netezza database.
Oracle, DB2 When importing data using the Add Query feature, BLOB data ST77255
is not imported even though the dialog and log indicate that the
import was successful.
Library N/A A UAC setting at the highest level might interfere with the N/A
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.
Local Storage N/A Issue: Local Storage is incompatible with previous versions of QAT-3812
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.
Connect to DB2 If you are using the DB2 Client version 9.5, 9.7, or 10.1 in a N/A
Database Windows 8 or Windows Server 2012 environment, follow the
instructions in IBM DB2 Technote 1618434: http://www-
01.ibm.com/support/docview.wss?uid=swg21618434.
Connect to Excel The following error is encountered when attempting to create a N/A
Database connection to an extremely large Excel file (for example, 20 MB or
larger): "Microsoft. ODBC Excel Driver. System resource
exceeded."
For more information, see
http://www.toadworld.com/products/toad-data-
point/f/36/p/20201/40998.aspx.
Workaround: Convert the Excel file to a CSV file.
Connect to Oracle (Oracle 10.2.0.1 client only) Attempting to connect to an Oracle N/A
Database database From Toad using the 10.2.0.1 Oracle client results in the
following error: “ORA-24909: call in progress. Current operation
canceled”. This is a known issue with this Oracle client
(http://www.dbmotive.com/oracle_error_
codes.php?errcode=24909).
Workaround: Upgrade your Oracle client to a later version and
connect to the Oracle database.
Connect to Oracle 11 When connecting to Oracle 11, you must enter the password in the N/A
Database only proper case because passwords are case-sensitive.
Toad Data All Automation in Toad Data Point 3.3 or later requires .NET N/A
Point Framework 4.5 (or later). If you are using .NET Framework 4.0
Automation without .NET Framework 4.5 (such as in Windows XP), you may
encounter the following:
l After running a scheduled Automation script, Toad
generates an error message even though the script
executes successfully.
l In a Toad Intelligence Central environment, after running
any published Automation script (scheduled or un-
scheduled), Toad generates an error message even
though the script executes successfully.
Workaround: Upgrade your Windows OS to Windows 7 and install
.NET Framework 4.5 or later.
Data ODBC- DB2 In compatibility mode, the ODBC driver does not return enough N/A
z/OS information for the CommandBuilder to correctly generate update
or insert statements.
Editor Teradata If you experience performance issues using a Teradata N/A
connection, especially when using code completion in the Editor,
use the Teradata Non-X views (instead of the X views).
To use Teradata Non-X views
Query Cassandra Cross-connection query: A query between Cassandra and either N/A
Builder and Excel 2010 or Access 2010 might fail to execute and display a lost-
Excel/Access connection error.
Workaround: Upgrade to Excel 2013 or Access 2013 (or later).
Getting Started
Contents of the Release Package
The Toad release package contains the following products:
1. Toad Data Point 6.4
2. Product Documentation, including:
l Installation Guide
l Online Help
l Release Notes
l User Guide
l Getting Started Guide
Installation Instructions
See the Toad Data Point Installation Guide for more information.
Product Licensing
Toad Data Point with offline license keys
To activate a trial:
1. Go to the trial download web page, accessed through the product page.
2. Select Download Free Trial.
NOTE: You can view your licenses from within Toad by selecting Help | About
Globalization
This section contains information about installing and operating this product in non-English configurations, such as
those needed by customers outside of North America. This section does not replace the materials about supported
platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. It supports simultaneous operation with
multilingual data. This release is targeted to support operations in the following regions: North America, Western
Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.
This release has the following known capabilities or limitations: If the user overrides the default installation path
during installation, the new path specification cannot contain Unicode characters.
About Us
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT
landscape. From database and systems management, to Active Directory and Office 365 management, and cyber
security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000
companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the
next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat.
Quest Software. Where next meets now. For more information, visit www.quest.com.
Copyright
© 2025 Quest Software Inc.
ALL RIGHTS RESERVED.
This guide contains proprietary information protected by copyright. The software described in this guide is furnished
under a software license or nondisclosure agreement. This software may be used or copied only in accordance with
the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any
means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s
personal use without the written permission of Quest Software Inc.
The information in this document is provided in connection with Quest Software products. No license, express or
implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with
the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS
SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO
LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY
RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT
SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE,
SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF
PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR
INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the
accuracy or completeness of the contents of this document and reserves the right to make changes to specifications
and product descriptions at any time without notice. Quest Software does not make any commitment to update the
information contained in this document.
If you have any questions regarding your potential use of this material, contact:
Quest Software Inc.
Attn: LEGAL Dept
4 Polaris Way
Aliso Viejo, CA 92656
Refer to our web site (www.quest.com) for regional and international office information.
Patents
Quest Software is proud of our advanced technology. Patents and pending patents may apply to this product. For
the most current information about applicable patents for this product, please visit our website at
www.quest.com/legal.
This product includes patent pending technology. For the most current information about applicable patents for this
product, please visit our website at www.quest.com/legal.
Trademarks
Quest, Quest Software, Benchmark Factory, Spotlight, LiteSpeed, SQL Navigator, vWorkspace, Toad, and the
Quest logo are trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest
Software trademarks, please visit our website at www.quest.com/legal. Microsoft, Windows, Windows Server,