Simplify the day-to-day tasks of DBAs and spend more time on innovation. Toad for SAP Solutions automates frequent and repetitive tasks, eliminates performance-tuning challenges and streamlines SQL optimization so you can focus on higher-priority projects. Take advantage of simple-to-use query builders and SQL editors, data-modeling functionality, powerful SAP database tuning, maintenance- and change-management tools, easy collaboration through Toad Intelligence Central, visual database maps and more. Toad for SAP Solutions supports SAP ASE, SAP HANA, SAP IQ, and SAP SQL Anywhere.
Minimize the learning curve of SAP HANA with the familiar look and feel of Toad. Plus, benefit from deep functional expertise for developing HANA applications, and managing HANA database objects and users.
Quickly and easily build SQL with minimal keystrokes or use the visual query builder and never touch your keyboard. Generate queries and reports and perform SQL development and optimization faster.
Automate and schedule frequent and repetitive tasks.
Create and manipulate database objects through intuitive GUIs, and easily view dependency information for an object.
Rapidly find the root cause of system, database or application performance issues and make necessary corrections with our Spotlight on SAP ASE component.
Enable application performance tuning with automated SQL scanning, optimization and index impact analysis.
Mitigate the risk of making changes by seeing which objects will be impacted by this action.
Share Toad artifacts through Toad Intelligence Central for improved collaboration with colleagues.
Access and manage all your Toad files using Toad’s intuitive new library feature.
Compare and sync servers, schemas and data to easily identify differences.
Track any SQL executed during your Toad session, and save time by eliminating the need to retype commonly used SQL.
Process scripts and code snippets against multiple servers and instances.
Roll back transactions in the transaction log without restoring from a backup.
Build and execute security-related scripts against multiple servers to create, manage and even replicate security for all users.
1 GHz minimum
512 MB of RAM minimum, 1 GB recommended
Note: The memory required may vary based on the following:
162 MB to run Toad
Web browser- Microsoft Internet Explorer 8.0 or later
Note: Toad may support other internet browsers but note that no testing was performed on it.
Review the following information about using Toad in virtual environments:
Note: Toad may work in virtualization environments other than the ones in which it was tested.
This technical brief provides a detailed technical view into the SQL Optimizer and how it provides a solution for improving SQL statement performance that an internal database management system's SQL optimizer cannot provide. We also see how the SQL Optim