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:
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
|
N/A |
Export Wizard/ |
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: 2007 PIAs: |
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:
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 |
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 |
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 Windows Server® 2008 R2 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.
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:
| ||||||
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:
| ||||||
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%. |
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
Requirement | Details | ||||||
---|---|---|---|---|---|---|---|
|
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:
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:
MySQL 4.1, 5.0, 5.1, 5.5, 5.6 MariaDB 5.5.5 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:
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. |
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:
|
Note: Toad may work in virtualization environments other than the ones in which it was tested. |
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, Vista standard user—on the computer.
If a Power User installs Toad, a Restricted User cannot do the following:
The following describes the requirements and restrictions for users who launch and run Toad:
To activate a trial license
To activate a purchased commercial license
The Toad release package contains the following products:
See the Toad Data Point Installation Guide for more information.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy