What is new in Toad for SAP Solutions 3.1?

Toad for SAP 3.1 is here!  So what’s new?








Database Map

Database Map displays selected DB objects in a well-arranged customizable environment that clearly shows the architecture of the database. The arrows connecting objects reflect the reference relation. The arrows point to the referenced objects. Each object icon shows its icon, name and type.

The central object is indicated by bold text and is used as a pivot point to the map. Drag and drop an object to the map or left-click and hold it to make it central.

The current object is the object under mouse pointer.

The selected object is an object indicated by check icon in its corner. Hold Ctrl and Left-click to select one or more objects.


·         Click the new big button on the toolbar or right-click an object and select Show on Database Map to launch Database Map

·         All Database Map colors and themes can be adjusted in Tools | Options | Database Map with Map Live Preview window
·         A maximum objects count can be set in Options | Database Map | General. If you drag too many objects into the map an information dialog appears
·         Click Options | Tools | Database Map | Types to select types object types that load on the map
·         Click File | Print Preview | File to Export the Database Map into an image file, PDF file or to Print it
·         Click Save to save the Database Map plugin file (*.dbm). These files are automatically associated to open in Toad.

Using mouse to work with the Database Map

·         Drag objects to the Database Map from the Object Explorer or from Database Explorer to view this object with its referenced and dependent objects on the map

·         Use mouse wheel to zoom in and out or use the zoom controls at the left edge of the map

·         Move objects around the map to arrange them

·         When a mouse pointer is over an object, the object becomes the current object and its icon is framed in orange. The objects referenced by the current object are framed in red and those dependent are framed in blue

·         Left-click an object in the Object or Database Explorer and select Show on Database Map... to open a new Tab with a Database Map
·         Left-click an Object on the Database Map and hold to load its dependencies. A small progress bar will show up.
·         Right-click any object on the map to display its context menu or to Load dependencies of the object on the map
·         Right click into an empty space of the map to Clear the map, Refresh its view or Re-Layout
·         Right-click into an empty space of the map and select one of the Layout algorithms to arrange objects automatically
·         Right-click an object and select Remove item to remove an object (and its dependencies from the Map)
·         Ctrl+click more objects to select and the same context menu actions will be available on the Database Map as in the Object or Database Explorer.

Using the GUI to work with the Database Map

·         Use the Quick Search to find objects on the Database Map. The Map zooms on the object

·         Click a new button Generate Database Map on the toolbar for objects in script to send objects directly from SQL Editor or Query Builder to Database Map
·         Enable Include ref. to show the objects referenced by the selected object on the map
·         Enable Include dep. to show the objects dependent on the selected object on the map
·         Enable Multiple levels to show Level visibility filter that allows to show only objects in the desired distance from the selected object


·         Use the new Toad Library to manage all Toad files
·         Click the Library button to access the Library
·         Click Add to Library and then browse to and select one or more files
·         Your file is added to the Library but remains in its original location
·         As the number of files in your Library grows, use filter, group, and search features to easily find the files you need
·         You can add topics and use them to group files. You can add keyword tags to individual files and use these to filter, group, or search
·         You can run Automation scripts from the Library. Right-click the script and select Execute

Toad Information Central Integration

·         Store and share any Toad file or a connection profile easily
·         Click View | Toad Intelligence Central to access this new feature
·         Click Connect, enter IP address into Host field, your Username, and Password

·         Toad Intelligence Central features a full-function Object Manager that enables you to perform basic operations with files stored on the TIC servers

·         Right-click a file and select Send To | Publish File to publish a file to Toad Intelligence Central in Project Manager or click File | Send to | Publish File
·         You can publish all Toad artifacts like SQL files, DDL scripts, connection files, database map plugins and more.

Memory Improvement

·         This release includes an enhancement that improves available memory space
·         This improvement will be most noticeable if you frequently encounter “out of memory” errors

Schema Compare Enhancements

·         Schema Compare was implemented for SAP IQ 16
·         Generate DDL was implemented for all supported Objects right-click menus

SQL Editor Improvements

Data Profiling

·         Data Profiling allows you to inspect your data to assess its content and data quality
·         Use Data Profiling to find duplicates and nulls, to identify anomalies and patterns, and to view statistics about your data
·         Graphs and charts help you visualize data quality
·         Data Profiling can help you identify data quality issues prior to ETL processing
·         View Data Profiling in a tab in Result set window of Editor

Extended Tooltips for Code Completion

·         More detailed tooltips are now displayed in SQL Editor


New Format Script Button

·         You can easily format objects DDL scripts using a new button in a Script Tab


Editor Enhancements

·         Toad now automatically checks syntax when you write in Editor
·         Invalid lines are highlighted in the scroll bar in red color
·         Hover over the red cross icon in the left to see details of the syntax error
·         Select Options | Editor | Tools | Syntax Checks to edit automatic syntax checks



File Version Control

·         Version Control can now be configured for all files that are handled in Toad, e.g. *.sql, *.tsm, *.tas etc.
·         Once Version Control is configured in Toad at level of files any file can be added
·         It is easy to commit new changes or get latest revisions from the repository

Data Compare Enhancements

Various enhancements and bug fixes meant to improve the Data Compare feature were done in this release including:

Compare result variable

·         New Automation setting that allows you to immediately see whether data is equal or different

GUI Enhancements

·         New buttons were added for SAP ASE and SAP HANA Object Details tabs that enable you to perform various functions more easily

SAP HANA Enhancements

New Object Editor for Remote Sources

·         Create and Alter Remote Sources in SAP HANA SP09 and higher easily with new DOEs
·         Select Server Objects in the Object or Database Explorer, right-click and select Create Remote Source or Alter Remote Source


SAP ASE Enhancements

New Information Tabs for Logins

·         Review important information about Logins easily
·         Select Server Security in the Object or Database Explorer, right-click any login and select View Details to display the two new tabs


Support for SAP ASE 15.0.2 Instead of Triggers

·         Use Create/Create Like/Alter Trigger editors to set instead of triggers to override default triggering actions


Change Script Statement Delimiter

·         Toad now allows you to change the statement delimiter
·         Select Tools | Options | Database | ASE | Script statement delimiter to set the delimiter



For a full list and further details about new features, please refer to the Toad for SAP 3.1 Release Notes found in the Support Portal's Technical Documentation page here