Toad® Data Point Beta

Version 5.0.0.421 (Beta)

Release Notes

Friday, September 28, 2018


Contents

Welcome to Toad

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Global Operations

General Information

For More Information


Welcome to Toad

Toad Data Point is a multi-platform database tool designed for IT and Business Professionals who need to investigate and analyze their data. It empowers effective decision making by providing insight into business data, enables users to access and understand their data from any source, and streamlines the process of data collection, ensuring the right information is delivered on time.

Welcome to the Toad Data Point 5.0 Beta Program (Previously 4.5)

The Toad Data Point 5.0 Beta includes many new enhancements designed to improve your productivity. We will periodically highlight new features and key enhancements as they become available. Look for details on the Toad Data Point Community page: Toad Data Point Beta Program Community.

Please review the System Requirements section prior to installation.


 

Learn More

Remember, you can find blogs, videos, and forums at the Toad Data Point Community.

Back to Top


Resolved Issues and Enhancements

This list reflects the issues resolved and the enhancements implemented since the previous Beta release.

Fixed VersionCreate DateResolvedToad ModuleNote2SummaryTesterkey
TDP 5.02018-05-292018-06-19NO MODULEColumn comments are now supported for PostgresSQLAdd Column Comments in table structure viewer for postGres 10.3MayQAT-13009
TDP 5.02018-05-172018-05-28SQL EditorFixed issue regarding publishing sql containing WITH statementHive Toad doesn't recognize that "rankichap" is being created by the first partCindyQAT-12973
TDP 5.02018-04-112018-06-12ODBCCross-Connection queries using an excel workbook located on mapped drive no longer produce errors. The mapped drive in Exce connection is now resolved to full network path.XQuery with Excel abends when opening saved fileSandyQAT-12774
TDP 5.02018-03-272018-04-10Connection ManagerFail to connect to MySQL when using SSLFail to connect to MySQL when using SSLCindyQAT-12631
TDP 5.02018-03-262018-04-09SQL EditorFixed using DECLARE statement in SQL Editer when Toad Data Point is installed in Read Only modecannot execute Declare statements when in Read Only mode.CindyQAT-12625
TDP 5.02018-03-142018-04-11AutomationAutomation Replace("#string_date_01#", "-", "_") failed in TDP 4.5 Beta but is now correctedUse of Replace function fails in automation but used to work CindyQAT-12550
TDP 5.02018-03-082018-04-09Project ManagerAdded Default location option for Project ManagerUser wants a default location for Project Manager filesCindyQAT-12503
TDP 5.02018-03-082018-03-27Publishing WizardPublished automation scripts did not work after migrating to a new server. This now works.cant use published automation scripts after migrate to new serverCindyQAT-12502
TDP 5.02018-03-022018-03-23AutomationFixed issue with automation comparing two paths.can't compare paths in TDP automationCindyQAT-12485
TDP 5.02018-02-192018-03-09Automation#ROOT_PATH# in automation is now supported with Run Activity#ROOT_PATH# in automation does not work with Run ActivityCindyQAT-12442
TDP 5.02018-02-162018-03-26ODBCNow Long DSN names do not show up in ODBC drop down listLong DSN names do not show up in ODBC drop down listSandyQAT-12439
TDP 5.02018-02-162018-05-29AutomationWith statements are now supported in the Execute SQL Activity of automationSupport With statements in Execute SQL ActivityCindyQAT-12438
TDP 5.02018-02-162018-06-26Export WizardAdded check for necessary Excel utilities to Quick Export. If you do not have these files you cannot export. This check now tells user how to install Excel utilitiesQuick export does not check or PIAsCindyQAT-12437
TDP 5.02018-02-162018-03-05AutomationRoot element missing xml error when publishing automation script with Runchild scripts activitiesRoot element missing when publishing automation script with Runchild scripts activitiesSandyQAT-12435
TDP 5.02018-02-152018-06-01Pivot GridThe Pivot Grid now supports Top N rows so one can sort and filter for top N values of pivoted dataAdd ability to get Top N rows in pivot grid. CindyQAT-12434
TDP 5.02018-02-142018-03-28BI ConnectorsFixed executing unqualified Hive SQL twice.Can't execute unqualified Hive SQL twice.CindyQAT-12432
TDP 5.02018-02-082018-03-26Import WizardIn Read-Only mode the import wizard was allowing to right to Access tables. This is not disallowed to support full Read-Onlycan write to a table in Read-Only ModeCindyQAT-12402
TDP 5.02018-01-292018-02-05BI ConnectorsSales Force now draws table relationships that are defined in the database.Sales Force no longer draws relationsCindyQAT-12312
TDP 5.02018-01-24NonePublishing WizardWe have provided a work around to support unicode literals in Cross-connection querieschange to publish with utf8CindyQAT-12299
TDP 5.02018-01-122018-03-16ODBCNetezza temp table now persists in same sessionNetezza temp table does not persist in same sessionCindyQAT-12224
TDP 5.02017-12-122018-01-15AutomationExporting to Local Storage or publishing to Toad Intelligence Central is easier to see how to configure in AutomationRemove default export path from T&C and Pivot Grid activiyCindyQAT-12090
TDP 5.02017-11-272018-02-05Publishing WizardAdded snapshot and automation status to Object Explorer. Now user can see failed snapshot refresh and automation script failures easilyAdd snapshot and automation status to OECindyQAT-11979
TDP 5.02017-11-272018-06-29BI ConnectorsWe now support connecting to Office365 SharePoint online AuthenticationSupport SharePoint OnlineQingQAT-11977
TDP 5.02017-11-162018-04-20AutomationA Cross-Connection Query in Automation that used an Excel file did not close the file after executing the query. It now closes after execution. XQuery in Automation does not close connection to Excel fileCindyQAT-11935
TDP 5.02017-11-142017-11-17X-QueryFixed failing to connect when changing the password for oracle proxy user.Fail to connect when changed the password for oracle proxy user.SandyQAT-11926
TDP 5.02017-11-132017-11-29Connection ManagerSAP Hana is not in Base (Also GreenPlum and MariaDB). This has been updated.SAP Hana is not in Base (Also GreenPlum and MariaDB)CindyQAT-11920
TDP 5.02017-11-022017-11-16AutomationPasswords are now being obfuscated in Automation scriptsPassword is not obfuscated in Automation scriptCindyQAT-11865
TDP 5.02017-10-232017-11-20Import WizardCorrected file in use error in Import wizardImport wizard:Issue with Data Import Export when file is in useMayQAT-11823
TDP 5.02017-10-052017-10-13Code CompletionFixed excessive Dictionary calls when using VerticaExcessive Dictionary calls when using VerticaDebbieQAT-11693
TDP 5.02017-09-222017-10-26Data Compare & SyncNow can do data compare on two Firebird databasescant do data compare on two Firebird databasesSandyQAT-11631
TDP 5.02017-09-122017-10-09ER DiagrammerFixed error when saving Database Diagram on MariaDBSaving spesific Database Diagram failsCindyQAT-11564
TDP 5.02017-07-312018-03-08Data GridFixed editing Teradata table in Data Gridcant edit Teradata tableQingQAT-11211
TDP 5.02017-06-272018-04-09Export WizardFixed problems editing templates in export wizard automation activityproblems editing templates in export wizard activityCindyQAT-10948
TDP 5.02017-06-142017-11-10SQL EditorTDP was hour glassing when first pressing execute in SQL EditorTDP hour glasses when first pressing execute in SQL EditorCindyQAT-10850
TDP 5.02017-05-262018-04-25Profiling/ETLAdded Option to set custom default settings for Profiling. Set Profiling OptionsSandyQAT-10759
TDP 5.02017-05-082018-04-23AutomationFixed Wrong validation error in Automation for cross-connection importWrong validation error in Automation for cross-connection importCindyQAT-10622
TDP 5.02017-04-242018-03-28FTPAdded to retry option for Automation FTP activity. Now you can set this activity to retry the operation N times if it failsRetry on FTP Activity if times outCindyQAT-10497
TDP 5.02017-02-072018-06-08Object ExplorerThe PostgresSQL connector cannot support users who do not have privileges to pg_catalog. We have now added a warning when connecting and do not allow accessObject Explorer does not work for our customer's postgreSQLCindyQAT-9855
TDP 5.02017-01-112018-03-05BI ConnectorsMade change in how we map Salesforce objects making it more efficientReduce Salesforce API calls - SF (Part 1)DebbieQAT-9681
TDP 5.02016-02-242018-04-17AutomationThere is a new RUN_MODE variable in automation. This now can be used in conditional coding.run mode bind variable in automationMayQAT-7299
Total:40

 

Known Issues

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

Feature

Platform

Known Issue

Defect ID

General Sybase ASE

Currently, if you open a Toad file in Toad Data Point 3.0 or 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 see that your Toad Query Builder document is open in an Editor window. Send this document to the Query Builder (Editor | Send to Query Builder).
  2. Save the new Query Builder document as a new Toad file.

Workaround 2:

  1. Open the Toad file in Notepad.
  2. Use Find and Replace to change all instances of "sybase" (all lowercase) to "Sybase" (first character uppercase, with the rest lowercase).
N/A
General Excel If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662. ST42486
General Salesforce

After successfully changing the password or token for 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.

N/A

Installation/

Upgrade

All

(MSI installs on Windows 7) If you are using MSI to install Toad on Windows 7 with UAC enabled, you can install a file 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

 

N/A

Toad Data Point does not support installation paths that contain UNICODE characters.

N/A

Toad Data Point 3.0 or later doesn’t support User IDs that contain Unicode characters. ST90367, ST90372
The Toad Data Point Read Only installation is read-only for all 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. N/A

Currently, you cannot install Toad Data Point to a path that 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

ST66330
Installation n/a

During installation on Windows 8, some users might encounter a prompt from Windows to install .Net Framework 3.5.

Workaround: In the Windows prompt, click Skip this installation to instruct Windows Not to install .Net Framework 3.5.

N/A

Connections

ODBC

Currently, Toad does not support ODBC connections to the following databases:

  • Sybase Advantage

  • Oracle RDB

  • Progress OpenEdge

  • MySQL ODBC (The ODBC 3.51.17.0 driver is not supported, and attempting to connect using this driver results in columns not displaying for tables.)

    Workaround:

    Upgrade the MySQL ODBC driver to 3.51.27.00 or later to display table columns.

ST69744

Connections Access

Currently, for a password-protected Access database, 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.

ST94125
Connections Vertica ODBC

When using the Vertica ODBC driver version 6.1.1, data 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

ST109484
Connections Amazon Redshift You might experience problems after a Redshift connection is unexpectedly dropped. QAT-2194
Connections Amazon Redshift After canceling a Redshift query it might continue to run on the server. QAT-2195
Connections Amazon Redshift

When a Redshift connection in Toad is inactive for a period of 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.

Caution: Editing your Registry incorrectly can cause serious, system-wide problems. It is advised that you back up your registry before modifying it.

N/A

Connections N/A

Exported connections: A connection file exported from Toad Data Point 3.6 or later cannot be imported into version 3.5 or earlier.

N/A

Connections MongoDB For a MongoDB 3.0 (or later) connection, the user must have Read/Write privileges in the MongoDB database in order to view sub-tables (MongoDB embedded documents).

TIC-5520

Automation   All

If Toad Data Point 3.7 is launched as administrator on Windows 7 systems with UAC turned on and Outlook running, the auto-populate SMTP server info and contact list in Automation Email and Error Emails does not function properly.

Workaround:

Submit this information manually. Another option is to either run Toad Data Point 3.7 not as administrator, or turn UAC off, or close Outlook when adding the Send Email activity in Automation.

  ST80857
Automation All

When Toad runs as an application in a Citrix environment, scheduled scripts might not execute if the user who scheduled the tasks is not logged on. In addition, an "Access Denied" error is logged for the scheduled task in the Windows Scheduler.

Workaround: Install and run Toad as a desktop when using Toad with Citrix.

N/A

Data

ODBC - Ingress

In some cases, earlier Ingress ODBC drivers display an "Invalid number of columns or parameters specified" error message when displaying data that has Unicode characters.

Workaround:
Download the latest Ingres 9.3 ODBC driver.

N/A

Execution Plan SQL Server

You cannot generate an estimated execution plan for a local temporary table because the execution plan uses a different connection to generate the plan and does not know about the temp table.

Workaround:
Use the actual execution plan button to generate execution plans for SQL that contains a temp table.

N/A
Export Wizard/ One Click Export Access, Excel

 

Limitations when exporting fractional seconds:

  • When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.

  • When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.

N/A

 

Import Wizard

Excel

Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error.

N/A

Attempting to import data from a template that contains multiple worksheets results in an error.

 

ST77978

ODBC - DB2 iSeries, Netezza

Currently, the Truncate table checkbox is disabled on the Select Target page when using an ODBC connection to a DB2 iSeries or Netezza database.

ST77986

Oracle, DB2 When importing data using the Add Query feature, BLOB data is not imported even though the dialog and log indicate that the import was successful. ST77255
Library N/A

A UAC setting at the highest level might interfere with the 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.

N/A

Local Storage N/A

Issue: Local Storage is incompatible with previous versions of 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.
  2. Make a copy of the Toad Data Point Hub Data folder and save it using a new name (such as Toad Data Point Hub Data 3.5 backup). If you uninstall 3.6, just move this copy back and use the original folder name.
QAT-3812
Object Explorer/ Database Explorer Sybase ASE When viewing a table that contains a BIGTIME data type column, attempting to select the Data tab causes Toad to unexpectedly quit.

N/A

Object Explorer/ Database Explorer Sybase ASE Currently, only foreign key constraints can be added or modified for existing Sybase ASE tables. ST55111
Oracle 11g

On the Create/Alter User window, if you are modifying a password, you must enter the password in the proper case. You do not need to surround the password with double quotes.

If you enter the password in lowercase on the Create/Alter User window, and the generated script has a SQL command containing the password in lowercase, you will need to type the password in lowercase to login.

If you enter the password in uppercase on the Create/Alter User window, and the generated script has a SQL command containing the uppercase in lowercase, then you will need to type the password in uppercase to login.

ST66705

Query/
Query Builder

All

The Query Builder currently uses a 24-hour format for timestamps. Attempting to run a query with a date range that includes a 12-hour timestamp format results in incorrect formatting of the timestamp. ST78729
Query/
Query Builder
Local Storage Currently, in a cross-connection query using Local Storage, Toad does not support quoted table alias names (example, the table alias "foo bar"). Quoted column names are supported. ST86483

Save As Dialog

(Library)

 

For some users who enabled the Automatically add files to library on open feature, the Save and Cancel buttons in the "Save As" dialog are disabled. This issue was encountered in a Windows 10 environment. See knowledge base article KB235265.

Workaround 1: Press Enter when the Save As dialog is open to save your file.

Workaround 2: Select Tools | Options | Environment | General and clear the Automatically add files to library on open check box. If you use this workaround, newly-saved files and opened files are no longer automatically added to the Library.

N/A

Toad Intelligence Central All

When data includes high-precision numbers (i.e., those with a large number of decimal places), results from publishing to Intelligence Central may not always be as expected. In some cases, data may be truncated to include not more than 15 significant digits.

N/A
Toad Intelligence Central N/A

Background: In Toad Data Point 3.5 or later, your Intelligence Central user name must be lower-case.

Issue: In Toad Data Point 3.5 (or later), if you attempt to open a previously-saved connection to Intelligence Central 2.2 (or earlier) in which the user name contains upper-case letters, the connection will error.

Solution: Upgrade to Intelligence Central 2.3.

N/A
User Interface N/A

Issue: Toolbar sub-menus and buttons disappear when selected. If you experience this issue, use the following workaround.

Workaround:

  1. In Toad, select Help | About and select the Application Data Directory link to open this directory. Then exit Toad.
  2. In the App Data directory, open the Session sub-directory and delete the Analyst.tss file. Restart Toad.
  3. In Toad, select Tools | Configuration Wizard. Click Finish to close the wizard without selecting an option. The default option will be applied.
QAT-6045

Third Party Known Issues

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

Feature Platform Known Issue 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 (or later). 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 or later.

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 R2 Service Pack 1 (64-bit)

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

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

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

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

Windows® 10

.NET Framework

Microsoft® .NET Framework 4.5.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.

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

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

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

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 (using MySQL provider)

SAP ASE 15.5, 15.7, 16

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

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 11g

Salesforce.com®

Microsoft SQL Server Analysis Services 2014 SP2

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. Toad Data Point has been certified by Cloudera.

MongoDB™ 3.4.6

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 3.7 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 Data Point in a virtualization environment, for best results ensure the system accurately reflects the applicable client hardware and software requirements listed in this document.

Toad Data Point 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:

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:

User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:


Global Operations

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: During installation, if the user overrides the default installation directory location, the directory path cannot contain Unicode characters.


General Information

Platform specific help is not available for this Beta. Information on Toad features can be found in the Toad Data Point Beta Help file available from the Toad Data Point Help menu (Help | Toad Help).


For More Information

Commercial and Trial versions of this release are not available at this time. Support for this Beta release is provided only through the Toad Data Point Beta Forum at: Toad Data Point Beta Forum.

Yahoo Group (Beta Support)

You can join the Toad Data Point discussion group by sending an email to: ToadforDataAnalysts-subscribe@yahoogroups.com

Contact Quest

For sales or other inquiries, visit www.quest.com/contact.


© 2018 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

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, 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, Windows Vista, Visual Studio, SQL Server, SharePoint, Access and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates in the United States and other countries. Citrix® and XenApp™ are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. SAP is the registered trademark of SAP AG in Germany and in several other countries. IBM and DB2 are registered trademarks of International Business Machines Corporation. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Google and Google Analytics are registered trademarks of Google Inc. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. Subversion is a trademark of the Apache Software Foundation. All other trademarks, servicemarks, registered trademarks, and registered servicemarks are property of their respective owners.