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.
Library
Use the new Toad Library to manage all Toad files
Toad Information Central Integration
Store and share any Toad file or a connection profile easily
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
Extended Tooltips for Code Completion
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
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
SAP ASE Enhancements
New Information Tabs for Logins
Review important information about Logins easily
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
*******
Additional information relating to the new features in version 3.1 can be found in the Toad for SAP Solutions 3.1 Release Notes or in the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)
