Chat now with support
지원 담당자와 채팅

Toad Data Point 5.1 - Release Notes

Toad Data Point 5.1

Toad Data Point 5.1.x

Release Notes

Monday, February 24, 2020

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

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

Click here to view a video of this feature.

Toad Data Point 5.1.4 is a patch release with new features, security enhancements, and resolved issues.

New Features

Workbook Enhancements

We redesigned Workbook!

Toad Workbook gets a new sleek design. Click the arrows to display actions available for each of the steps.

Toad now supports Drag and Drop in Workbook

Left-click and drag and drop any workflow exactly where you want it.

Right-click any workflow step such as Pivot Grid or Transformation and Cleanse and select Copy step and then right-click the place where you want to insert a copy of your step and select Paste step.

You cannot copy and paste Query Builder or Editor query steps but you can clone them into a new workflow. Right-click a workflow query step and select Clone to a new workflow and a new workflow that begins with the duplicated query step will be created

Improved performance

We optimized performance of Workbook especially when working with large workflows with many steps.

Run Workbook silently

Use the following parameter to run Workbook silently from a command line:

--batch=true "Filepath"

e.g. "C:\Program Files\Quest Software\Toad Data Point 5.1\toad.exe" --batch=true "C:\Workbook\MyWorkbook.twf"

Pivot Grid

We added new options for Group By functions. Right-click a column header and Select from the available Group By options according to your data.

Now you can also summarize by ListAgg function.

Dimensional View

We improved selection of aggregate values of columns. By default there is no aggregate value set anymore.

Display all available aggregate values when you expand the selection in the field list.

Improvements with ODBC

You can set a custom character if you use modified ODBC drivers for connection to your database,

Set it in Tools | Options | Database | ODBC.

Security and Installation Enhancements

For this release of Toad Data Point we have provided internal security adjustments. We have revised a list of third party components in use according to their known and potential vulnerabilities. Toad uses only reliable and safe components by third party vendors. See the list of third party components in Toad Data Pointthe help file, section About Us | Third Party Components.

Our Toad installers are now based on the Wix Toolset , which improves user experience and performance of the installation process.


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

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® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

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

Recommended maximum DPI settings for Toad are 125%. It is possible to use Toad up to 150% 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

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.1 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

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

Resolved Issues in 5.1.4

Feature Resolved Issue / Enhancement Defect ID
Query Builder An issue with WHERE clauses has been fixed 1653/15456/4555521
Data Compare We have implemented a new performance option for exporting to Excel. Enable it in Tools | Options | Data Compare | General 15514/1713
Object Explorer Toad now shows key columns correctly on MongoDB 12218/15468/4590621

Resolved Issues in 5.1.3

Feature Resolved Issue / Enhancement Defect ID
ODBC You now can set a custom WildCard character for ODBC connections QAT-15471/4593041
Automation Publishing wizard now sets permissions of objects correctly in Automation script QAT-15458/4603555
Options Up and Down arrows now work correctly in Tools | Options | Explorer | Objects QAT-15457/2221/2175
Import Wizard Importing data from a SQL Server table to another is now much quicker QAT-15450/4563945
Job Management An issue with migration of a Task Manager item using a password has been fixed QAT-15368/4524397
Cross Query Toad has improved functions in Cross-connection query when Unicode characters are used QAT-7230/3246575
Pivot Grid We have added options for Date Grouping and Formatting in Pivot Grid QAT-15414/4556962

Resolved Issues in 5.1.2

Feature Resolved Issue / Enhancement Defect ID
Dimensional Viewer

We have improved work with calculated fields and aggregate values in Dimensional Viewer

QAT-15139
General

Collation property while importing data using Automation script has been modified to improve performance with certain JOINS on Tables

QAT-15314/4572415
Object Explorer

Issue with a public login has been resolved

TSS-1660/4473466
SQL Editor

AutoCommit on IBM DB2 connections now works as designed

TDB-3950/ 4576728
Team Server

Publishing a script with different schemas from the same database now works correctly

QAT-15319/4534571
Workflow We improved performance and saving of large workbooks TMB-1938, 1937/4577972, 4581459, 4581459, 4577972
Workflow Issues with Cross-Connection Query have been fixed TMB-1988/4531126
Workflow

Issues with Transformation & Cleanse in Workbook have been fixed

TMB-1964/ 4585090
Workflow

Toad now logs all progress within Workbook to help troubleshoot if needed

TMB-2047
Workflow

Now you can close Object Explorer to enlarge your workspace in Workbook

TMB-1993/4556959
Workflow

Now you can run Workbook silently from a command line

QAT-15347
Workflow

Erroneous message about a saved TSM file is not displayed anymore

TMB-1725/4558129

Resolved Issues in 5.1

Feature Resolved Issue / Enhancement Defect ID
Code Completion Dragging and dropping column names from Object Explorer to Editor now works correctly. QAT-15117
Object Details (DOV) We fixed an issue in the DB2 z/OS Subsystem - Right-Hand-Side Dynamic Statement Cache tab where a DB2 error was being thrown when a DSC table was selected if that table creator began with an @. TDB-3943/454799
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field. QAT-14558/4415769
Query Builder You now can select LAG and LEAD in the list of functions for calculated fields in Query Builder. QAT-14252/4438857
SQL Editor Highlighting keyboard shortcuts now work correctly in Editor. QAT-15111/4542078,   4555409,  4559368,   4564671  
Workflow Now you can drag'n'drop workflows in Workbook. QAT-15108
셀프 서비스 도구
지식 기반
공지 및 알림
제품 지원
소프트웨어 다운로드
기술 설명서
사용자 포럼
비디오 자습서
What's New
문의처
라이센싱 지원가져오기
기술 지원
모두 보기
관련 문서