Chat now with support
Chat with Support

Toad for SAP Solutions 4.0 - Release Notes

Toad for SAP Solutions 4.0

Toad for SAP Solutions 4.0.x

Release Notes

Wednesday, August 14, 2019

Contents

About Toad for SAP Solutions

With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management, and develop SQL more efficiently.

Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.

Toad for SAP Solutions 4.0.7 is a patch release with new enhancements and resolved issues.

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

4 GB of RAM minimum, 16 GB recommended

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

212 MB to run Toad

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server® 2008 R2 SP2

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

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

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

Windows® 10, version 1809

.NET Framework

Microsoft® .NET Framework 4.7.1

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 11 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

Database Server

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

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.

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.

Install Toad on Citrix® Systems

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.

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:

  • 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 for SAP Solutions:

Resolved Issues in 4.0.7

Feature Resolved Issue / Enhancement Defect ID
General Support bundle now generates correctly. QAT-14988
Script Generation Generating INSERT statements now works instantly even for tables with large numbers of rows. TSS-1663/4512804
Pivot Grid Pivot Grid column subtotals can now be formatted. QAT-14608
Default subtotal summary type was changed to SUM for string values in Pivot Grid. QAT-14837
There is an new option to show aggregate total values for row categories that only have one value. The default is to not display totals when there is only one value. QAT-14998
It is now possible to display subtotals for single values. Click Set pivot grid properties on Pivot Grid toolbar to enable. QAT-14998

Resolved Issues in 4.0.6

Feature Resolved Issue / Enhancement Defect ID
Automation An issue when Excel spreadsheet exported during Automation was not displayed is now fixed. QAT-14819/4498499
Installation Users should be able to deploy license keys during installation. This was broken in Toad Data Point 5.0 and is now fixed. QAT-14834/

4510329,

4516827,

4516600

Pivot Grid A scroll bar has been added to the row area in Pivot Grid. QAT-14705
Query Builder

Vertical scroll bar is now displayed in Cross-Connection Query Mode of Query Builder.

QAT-14749
Query Builder

A Group By button for aggregated functions has been added to Query Builder.

QAT-14609

 

Resolved Issues in 4.0.5

Feature Resolved Issue / Enhancement Defect ID
Connection Manager

Displaying of database objects on SAP ASE 16 SP03 now works correctly.

QAT-13928
Installation Allow Saving Passwords option in installation wizard now works correctly for 32-bit installer too. QAT-14822

Resolved Issues in 4.0.4

Feature Resolved Issue / Enhancement Defect ID
SQL Editor Users can now select the directory to serialize large results sets. The option is located under Database | Script results QAT-14377

Resolved Issues in 4.0.3

Feature Resolved Issue / Enhancement Defect ID
Automation Usage connection from parent activity has been reworked. A new option From parent has been added which indicates whether the currently used connection should recursively search for parents QAT-13279

Resolved Issues in 4.0.2

Feature Resolved Issue / Enhancement Defect ID
Automation Error when .xlsm file could not be exported using Automation script has been fixed QAT-14201
Object Editor (DOE) An issue in Create like connection feature has been fixed QAT-12420
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field QAT-14074
SQL Editor New option in Tools | Options | Editor | Tools | Auto highlight selected word enables auto highlighting of selected words TSS-1606

Resolved Issues in 4.0.1

Feature Resolved Issue / Enhancement Defect ID
Data Compare & Sync Error when data cannot be filtered has been fixed QAT-14057
Pivot Grid Pivot Grid now supports Top N rows so one can sort and filter for top N values of pivoted data QAT-12434
Query Builder Corrected issue in Query Builder to reverse engineer SQL that contained a UNION and where condition QAT-13812
Query Builder Prior to executing mixed case aliases, the Query Builder would change to upper case causing the execution to fail QAT-13581
SQL Editor Corrected issue where function/procedure could not be executed that had a long parameter name when using SAP ASE connections QAT-13795

Resolved Issues in 4.0

Feature Resolved Issue Defect ID
Automation Execution of procedures in Select to File Activity now works correctly 12124/4175590
Explain Plan Query Plan now checks for user privilege and displays error message 10945/4062923
Display of Query Plan has been optimized 11379/4062923

On ASE it is necessary to enable resource limits on the server to allow Explain Plan to work correctly

12217/4180645
Extract DDL An issue related to encryption of ASE password has been fixed 12512/4221396
Object Editor Toad now handles Login profiles correctly 10838/4059748
Create like login in HANA 2.0 now works correctly 12420/4204361
SAP IQ events are now dropped and created again when altered 12433/4208440
Object Explorer Indexes are now included on table Script Generation 11304/4094561
Time needed for loading some tables on ASE was decreased 11483/4104342
Display of row count in Object Explorer has been enhanced 11696/4130487
Script Generation Set flushmessage on now works correctly on SAP ASE 10364
Schema Compare and Sync Details Report in Schema Compare now works correctly 11645/4118758
SQL Editor Issue caused by a specific SQL statement was fixed in HANA 2.0 SPS01 Revision 12.01 9346
Behavior of query cancelling has been improved 11669/4130482
SQL Editor tab now displays an icon to indicate an error with SQL script instead of changing focus 11695
Filtering data columns in Result Set now works correctly 12339/4193695, 4199384

Known Issues

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

Feature Known Issue Defect ID
Query Builder

In SAP Sybase IQ and SAP Sybase SQL Anywhere, queries with a varchar datatype that contain single quotation marks do not function correctly when generating the query plan.

Workaround:

Replace single quotation marks with double single quotation marks when generating the explain plan.

Note: This fix only affects the explain plan code for IQ and SQL Anywhere.

ST92945
Debugger An ASE exception occurs when stepping into or over a function during procedure debugging.

ST94273

Schema Compare Schema Compare add-in that generates DLL does not currently work from all objects context menus. TSY-524

An error "Object reference not set to an instance of an object" displays when some snapshots are opened directly in Toad.

2305673-1/TSY-236
Monitor The monitor is enabled by default after Tools | Monitor | Process Browser is started but the tooltip still reads ‘Enable Monitor’. TSY-523
SQL Monitor will take several seconds to load in case of large SQL text data. 2289371-1/TSY-160
Object Editor In some cases Toad generates DROP and CREATE OR REPLACE at the same time for functions. TSY-1942

Currently, it is not possible to Grant some of the roles for SAP HANA, incl. sap.hana.admin.roles::Monitoring or sap.hana.admin.roles::Administrator.

Workaround: Assign the roles using the procedure from _SYS_REPO: GRANT_ACTIVATED_ROLE.

TSY-1495
Queries It is not possible to cancel some queries running in the background. TSY-486
QP5 Items are not aligned properly when "Commas in lists" are configured "Leading with space" in Options | Editor | Formatter. TSY-260
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents