Thursday, October 1, 2020
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.2.1 is a patch release with new enhancements, and resolved issues.
In Toad for SAP Solutions 4.2 the following new features were implemented:
Now you can connect to your SAP HANA and SAP IQ databases using SSL certificates
See Resolved Issues for more enhancements and resolved issues in this release of Toad for SAP Solutions.
Get the latest product information, find helpful resources, and join a discussion with the Toad for SAP Solutions team and other community members. Join the Toad for SAP Solutions community at
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
2 GHz processor (recommended minimum)
8 GB of RAM minimum, 16 GB recommended
Note: The memory required may vary based on the following:
Hard Disk Space
800 MB to install Toad
Note: The disk space required may vary based on the edition of Toad selected for installation.
Windows Server® 2012
Windows Server® 2012 R2
Windows Server® 2016
Windows Server® 2019
Windows® 8.1 (32-bit or 64-bit)
Microsoft® .NET Framework 4.7.1
Microsoft® Internet Explorer® 11 or later
Recommended maximum DPI settings for Toad are 125%. It is possible to use Toad up to 200% but some dialog windows will not be completely usable anymore.
Maximum tested resolution for Toad is 3800 x 2160 px.
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
SAP ASE 15.5, 15.7, 16 SP03
SAP IQ 15, 16
SAP SQL Anywhere 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.
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.
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:
The following describes the requirements and restrictions for users who launch and run Toad:
The following is a list of issues addressed and enhancements implemented in this release of Toad for SAP Solutions:
Resolved Issues in 4.2.1
|Feature||Resolved Issue / Enhancement||Defect ID|
You now can use SSL when you connect to SAP IQ
|Data Compare & Sync||
Data Compare can also use SSL when connecting to SAP IQ
We have enhanced behavior of Toad at higher DPIs on larger resolution displays
Query Builder now interprets IN conditions correctly
Query Buider now correctly visualizes scripts with IN statements
Resolved Issues in 4.2
|Automation||Publishing wizard now sets permissions of objects correctly in Automation script||QAT-15458/4603555|
|Code Completion||Dragging and dropping column names from Object Explorer to Editor now works correctly.||QAT-15117|
|Data Compare & Sync||We have implemented a new performance option for exporting to Excel. Enable it in Tools | Options | Data Compare | General||15514/1713|
|Data Compare & Sync||An issue when Data Compare displayed incorrect results has been fixed||15603|
|Data Compare & Sync||Error during Data Compare with a Local Storage table has been fixed||15602|
|Data Compare & Sync||An error when not all data rows were returned in Data Compare has been fixed||1663/4556801|
|General||An error when parsing a TIC query with group_concat() function has been fixed||2593/4666051|
|General||Users that execute Automation script are not added to OS Admin group on server anymore||2509/4197716|
|General||Behavior of Toad at high resolutions since patch version 5.1.2 has been improved||2320/4620661, 4623009, 4685386, 4685115|
Collation property while importing data using Automation script has been modified to improve performance with certain JOINS on Tables
|Import Wizard||Save Log option is now saved in Import Templates||2281/4628189|
|Import Wizard||It is now possible to import blank values||2293/4587201|
|Installation||Opening associated files with SQL extension now works correctly with Toad|
You now can deploy user settings during silent installation of Toad. Enter a full path to the Options Template that you generated in Tools | Options | General for a silent installation.
|Job Management||An issue with migration of a Task Manager item using a password has been fixed||QAT-15368/4524397|
|Options||Up and Down arrows now work correctly in Tools | Options | Explorer | Objects||QAT-15457/2221/2175|
|Pivot Grid||We have added options for Date Grouping and Formatting in Pivot Grid||QAT-15414/4556962|
|Pivot Grid||We improved backward compatibility of Pivot Grid||2688/4593313|
|Pivot Grid||Pivot Grid now allows you to use Aggregated data values in a calculated field.||QAT-14558/4415769|
|Query Builder||We improved attachment of Calculated fields in Query Builder to correct columns||2627/4650476|
|Query Builder||Several issues when using Where clause in Query Builder have been fixed||2292/4602617|
|Query Builder||An issue with WHERE clauses has been fixed||1653/15456/4555521|
|Query Builder||Adding additional AND clause in query tab and then visualizing does not create a Global Where clause||1371|
|Query Builder||You now can select LAG and LEAD in the list of functions for calculated fields in Query Builder||QAT-14252/4438857|
|Schema Compare||Now you can ignore differences in constraint names when one of the names is system generated||TSS-1525/4198363|
|SQL Editor||Highlighting keyboard shortcuts now work correctly in Editor.||QAT-15111/4542078, 4555409, 4559368, 4564671|
Publishing a script with different schemas from the same database now works correctly