-
Resources
- Forums
-
Toad for SAP Solutions
Improve SAP database development, administration and performance. 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.
01:20
Features
Support for SAP HANA
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.
SQL Editor
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.
Powerful task automation
Automate and schedule frequent and repetitive tasks.
Easy object management
Create and manipulate database objects through intuitive GUIs, and easily view dependency information for an object.
Performance bottlenecks detection, diagnosis and resolution
Rapidly find the root cause of system, database or application performance issues and make necessary corrections with our Spotlight on SAP ASE component.
SQL Optimizer for SAP ASE
Enable application performance tuning with automated SQL scanning, optimization and index impact analysis.
Visual database map
Mitigate the risk of making changes by seeing which objects will be impacted by this action.
Collaboration via Toad Intelligence Central
Share Toad artifacts through Toad Intelligence Central for improved collaboration with colleagues.
Enhanced Toad library
Access and manage all your Toad files using Toad’s intuitive new library feature.
Streamlined compare and sync
Compare and sync servers, schemas and data to easily identify differences.
SQL script recall
Track any SQL executed during your Toad session, and save time by eliminating the need to retype commonly used SQL.
Group execute
Process scripts and code snippets against multiple servers and instances.
Log reader
Roll back transactions in the transaction log without restoring from a backup.
Security management
Build and execute security-related scripts against multiple servers to create, manage and even replicate security for all users.
Tour
Product integration
Use integrated toolsets for quick SQL optimization and in-depth monitoring.
Specifications
- Platform
1 GHz minimum
- Memory
512 MB of RAM minimum, 1 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
162 MB to run Toad
- Operating system
- Windows Server 2008 Service Pack 2 (32-bit or 64-bit)
- Windows Server 2012
- Windows Vista (32-bit or 64-bit)
- Windows 7 (32-bit or 64-bit)
- Windows 8 (32-bit or 64-bit)
- Windows 8.1 (32-bit and 64-bit)
- .NET Framework
.NET 4.5
- Additional software
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.
- Database server
- SAP ASE 12.5.4, 15.0.2, 15.0.3, 15.5, 15.7, 16
- SAP IQ 15, 16
- SAP SQL Anywhere 10, 11, 12
- SAP HANA SPS08, SPS09
- Virtualization support- Application virtualization
Review the following information about using Toad in virtual environments:
- Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.
- Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.
Note: Toad may work in virtualization environments other than the ones in which it was tested.
Resources
Toad for SAP Solutions
Streamline SAP development and administration.
Spotlight on SAP ASE
Streamline SAP development and administration.
SQL Optimizer for SAP ASE
Streamline SAP development and administration.
Toad Data Modeler
Stay Updated on Quest® Toad® to Stay Secure
This Technical Brief details Quest’s adherence to software security standards for continually testing and delivering versions o...
Solving the SQL Tuning Problem: Secrets of Quest SQL Optimizer
This technical brief provides a detailed technical view into the SQL Optimizer and how it provides a solution for improving SQL...
Database Training Days 101: Top Five Oracle Performance Tuning Tips with Janis Griffin
Performance tuning can be complex, often leaving developers and DBAs uncertain about which adjustments will yield the most sign...
Identity-Driven Zero Trust Enhancing Cybersecurity
Identity-Driven Zero Trust Enhancing Cybersecurity