Toad for SAP Solutions
Introduction to 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.
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.
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
HANA Cockpit integration
Object explorer
SQL editor
Query builder
Database diagram
Object search
Data compare
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
Create high-quality data models and easily deploy accurate changes to data structures
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 statement performance that an internal database management system's SQL optimizer cannot provide. We also see how the SQL Optim
Upgrading Quest Toad for Greater Security
This Technical Brief details Quest’s adherence to software security standards for continually testing and delivering versions of Toad products that you can safely install and run.
Quest Partner Webcast FY21 Q2 EMEA
Quest has the technology solutions your customers need to connect, manage and secure a remote workforce.
Need for Speed? My Top Five Oracle Performance Tuning Tips
Performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this on demand presentation, Janis Griffin, System Consultant at Quest Software, will detail 5 steps to quickly identify performance issues and resolve them.
- More Resources
- Communities
- Events & Demos
- Research Docs
- Videos
Take the next step
Related Products
Toad Data Point
Simplify data access, preparation and provisioning.
Toad Data Modeler
Create high-quality data models and easily deploy accurate changes to data structures
Support & Services
Product Support
Self-service tools will help you to install, configure and troubleshoot your product.
Support Offerings
Find the right level of support to accommodate the unique needs of your organization.