Chat now with support
Chat with Support

Toad Data Point 4.2 - Release Notes

Third Party Known Issues

The following is a list of third party issues known to exist at the time of this release.

Feature Platform Known Issue Defect ID

Connections –

 

 DB2 If you are using the DB2 Client version 9.5, 9.7, or 10.1 in a 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. N/A
Connections  Excel

The following error is encountered when attempting to create a 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.

N/A

Connections

Oracle

(Oracle 10.2.0.1 client only) Attempting to connect to an Oracle 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.

N/A

Oracle 11 only

When connecting to Oracle 11, you must enter the password in the proper case because passwords are case-sensitive.

N/A

Automation All

Automation in Toad Data Point 3.3 or later requires .NET Framework 4.5. If you are using .NET Framework 4.0 without .NET Framework 4.5 (such as in Windows XP), you may encounter the following:

  • After running a scheduled Automation script, Toad generates an error message even though the script executes successfully.
  • 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.

N/A

Data

ODBC- DB2 z/OS

In compatibility mode, the ODBC driver does not return enough information for the CommandBuilder to correctly generate update or insert statements.

N/A

Editor Teradata

If you experience performance issues using a Teradata 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

  • Select Tools | Options | Database | Teradata and select the Use Non-X views in Object Explorer option.
N/A

Export Wizard/
One Click Export

All

To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:  

2003 PIAs:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en  

2007 PIAs:

http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en  

N/A

Excel Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit. N/A
Import Wizard DB2 When importing data using the Add Query feature and selecting a Single new table, TIMESTAMP data types are mapped to DATETIME data types. N/A
Object Explorer Cloudera Impala

A view is represented as a table in Impala, so views display as tables in Toad. For more information, see https://issues.cloudera.org/browse/IMPALA-1697.

 N/A
Object Explorer/ Database Explorer Teradata

You may experience issues if you attempt to view object details and your Teradata .Net Data Provider version does not correspond to the Teradata database version to which you are connecting. Issues include:

  • Object details for a View containing a DATE data type column do not display.
  • Object details for a Table containing a NUMBER data type column do not display.

Workaround: Install the Teradata .Net Data Provider version that corresponds with the Teradata database version to which you are connecting. For example, if connecting to Teradata database version 14, use Teradata .Net Data Provider 14.11.

N/A

Object Explorer/ Database Explorer DB2 iSeries The primary Key column of an iSeries table displays as Nullable in the Database Explorer even though the Not Null checkbox was not selected when creating the table. N/A

Query Builder

 Sybase ASE

Cross-connection query: Sybase has difficulty dealing with numeric literals in queries. You may encounter the following error:

Implicit conversion from datatype 'CHAR' to 'INT' is not allowed. Use the CONVERT function to run this query.

when attempting to execute a cross-connection query such as:

Select * from table where numeric_column = 50

Work-around: Change the query to something similar to the following using the cast function:

Select * from table where numeric_column = CAST(50 AS SIGNED)

 ST96868
Query Builder Cassandra and Excel/Access–

Cross-connection query: A query between Cassandra and either Excel 2010 or Access 2010 might fail to execute and display a lost-connection error.

Workaround: Upgrade to Excel 2013 or Access 2013 (or later).

N/A

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 Service Pack 2 (32-bit or 64-bit)

Windows Server® 2008 R2 Service Pack 1 (64-bit)

Windows Server® 2012

Windows Server® 2012 R2

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

Windows® 8 (32-bit and 64-bit)

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

Windows® 10

.NET Framework

The Microsoft® .NET Framework is required. The version is dependent on the operating system.

.NET 4.5.1 or later Windows 10
.NET 4.5.1

Windows Vista SP2, Windows 7, Windows 8, Windows Server 2008 (SP2 or earlier), Windows Server 2008 R2, Windows Server 2012

.NET 4.0

Windows XP, Windows Vista (SP1 or earlier), Windows Server 2003

Notes:

  • This information is provided to aid installation. Toad is not tested on Windows XP. Windows Vista (SP1 or earlier), and Windows Server 2003.
  • The .NET Framework 4 Client Profile is not supported.

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.

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® 6.0 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 9i, 10g, 11g, 11g R2, 12c

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

Limited support of SQL Server® 2000 (Service Pack 3 or later)

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express

SQL Server 2008 and SQL Server 2008 Express

SQL Server 2008 R2 and SQL Server 2008 R2 Express

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2016

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 9, 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

MariaDB 5.5.5 (using MySQL provider)

SAP ASE 12.5.4, 15.0.2, 15.0.3, 15.5, 15.7, 16

SAP IQ 15, 16

SAP SQL Anywhere 10, 11, 12

SAP HANA SPS 08, SPS 09, SPS 10, SPS 11

Teradata 12.0, 13.0, 13.10, 14, 15

Access® 2003, 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
  • 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
  • PostgreSQL® 8.3.4

  • 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

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

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.0, 3.1, 4.1

Oracle Business Intelligence Enterprise Edition 10g, 11g

Salesforce.com®

Microsoft SQL Server Analysis Services

Google Analytics™

OData

SharePoint®

NoSQL Connections

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

Azure Table Services

Apache Cassandra™

Amazon DynamoDB

Apache HBASE™

Apache Hive™

Cloudera Impala—Toad Data Point has been certified by Cloudera.

MongoDB™

Toad Intelligence Central

This release of Toad Data Point has been tested with Toad Intelligence Central 3.2 and 3.3.

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 4.2.1 features, see the New Features section of the Toad Data Point Release Notes.

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.

Notes: 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.

Virtualization Support

Requirement Details
Application Virtualization

Limited testing has been performed for Citrix® XenApp™ 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Desktop Virtualization (VDI)

Toad has been tested with vWorkspace™ 7.0 running on Windows XP Professional 32-bit (Service Pack 2).

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

Note: Toad may work in virtualization environments other than the ones in which it was tested.

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

Note: The following exceptions exist for Power Users:

  •  A Power User cannot install Toad on a computer running Windows Vista Enterprise. This is a Windows limitation because Vista does not support Power User mode.
  • (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, Vista standard 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 Vista user must be either an administrator or a standard user that belongs to an Vista Administrators group. Additionally, to enable full functionality in Toad when Vista’s User Access Control security feature is turned on, the standard user must run Toad as an administrator. (Right-click the Toad icon on the Vista desktop and select Run as administrator.)

  • (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.

Product Licensing

Product Licensing

To activate a trial license

  1. In the Licensing dialog, enter your license (Authorization) key.
  2. Enter the site message included with the license key.

To activate a purchased commercial license

  1. In the Licensing dialog, enter your license (Authorization) key.
  2. Enter the site message included with the license key.

Getting Started with Toad Data Point

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad Data Point 4.2.1
  2. Product Documentation, including:
    • Installation Guide
    • Online Help
    • Release Notes

Installation Instructions

See the Toad Data Point Installation Guide for more information.

Related Documents