For the best web experience, please use IE11+, Chrome, Firefox, or Safari

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.

Introduction to Toad for SAP Solutions 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
HANA Cockpit integration
Object explorer
SQL editor
Query builder
Database diagram
Object search
Data compare
Product integration

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.

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.