Toad for SAP Solutions

loading

Toad for SAP Solutions - Product integration

Toad for SAP Solutions Product Integration

Use integrated toolsets for quick SQL optimization and in-depth monitoring.

Toad for SAP Solutions - HANA Cockpit integration

Toad for SAP Solutions HANA Cockpit integration

Toad integrates SAP’s HANA Cockpit for seamless HANA management.

Toad for SAP Solutions - Object explorer

Toad for SAP Solutions Object Explorer

Manage objects with single-click access to details, data and underlying DDL.

Toad for SAP Solutions - SQL editor

Toad for SAP Solutions SQL Editor

Create, run, modify and save queries; edit data and process DDL commands.

Toad for SAP Solutions - Query builder

Toad for SAP Solutions Query Builder

Use a GUI to construct complex operations without SQL programming.

Toad for SAP Solutions - Database diagram

Toad for SAP Solutions Database Diagram

Visualize tables, dependencies and DB relationships in a data modeling view.

Toad for SAP Solutions - Object search

Toad for SAP Solutions Object Search

Locate objects by name or search for the source of objects across databases.

Data compare

Data Compare

Compare and sync data in a few clicks; generate a SQL script and sync.

Toad for SAP Solutions - Session browser

Toad for SAP Solutions Session Browser

Compare and sync data in a few clicks; generate a SQL script and sync.

Toad for SAP Solutions - Process browser

Toad for SAP Solutions Process Browser

View all server processes. Easily kill processes. Filter and group info.

Toad for SAP Solutions - Automation

Toad for SAP Solutions Automation

Automate frequent and repetitive tasks and effortlessly manage projects.

Simplify SAP database development and administration

  • Minimize the learning curve for administering and developing on SAP HANA
  • Automate routine tasks and increase accuracy
  • Deploy performance enhancements quickly and easily
  • Create and manipulate database objects through intuitive GUIs
  • Compare and synchronize data
  • Identify and resolve performance problems in record time

Overview

Toad for SAP Solutions simplifies the day-to-day tasks of DBA’s.. Whether you are working with SAP ASE or SAP HANA, Toad eliminates performance-tuning challenges, simplifies SQL optimization and automates frequent and repetitive tasks, so you can focus on higher-priority projects. Take advantage of easy-to-use query builders and SQL editors, data-modeling functionality, powerful SAP database tuning, as well as maintenance- and change-management tools. Toad for SAP Solutions is available in various editions for SAP database developers and DBAs and supports SAP ASE, SAP HANA, SAP IQ, and SAP SQL Anywhere

Automate routine tasks to increase accuracy

Use a customizable task-automation wizard to easily automate and schedule frequent and repetitive tasks; this dramatically reduces the risk of errors, allows you to focus on other important projects, and do more work in less time.

Deploy performance enhancements quickly and easily

Debug stored procedures or optimize SQL performance with Toad for SAP Solutions to receive help identifying potential performance problems and making changes. Ensure code correctness and the best-possible performance.

Create and manipulate database objects through intuitive GUIs

Customize Toad’s intuitive user interface to view, create and manipulate database objects with ease.

Compare and synchronize data

See variances in two different data sources, compare results and quickly sync the data through a wizard-driven process that makes it quick and easy to ensure data accuracy.

Identify and resolve performance problems in record time

Identify potential performance issues directly from running SQL statements, T-SQL or other source code. Ensure the best-possible SQL performance through validation, alternative code suggestions and indexing. (Unavailable in the Base Edition. Please review our edition-comparison guide to choose the edition that best suits your needs.)

Features

Support for SAP HANA NEW in Version 3.0
Minimize the learning curve of SAP HANA with the familiar look and feel of Toad. Toad provides deep functional expertise for developing HANA applications and managing HANA database objects and users.
Streamlined user interface NEW in Version 3.0
Speed through your work in record time with an intuitive and customizable interface that makes it easy to navigate from one task to another.
Easy object management
Create and manipulate database objects through intuitive GUIs. Easily view dependency information for an object.
Streamlined compare and synch
Compare and sync servers, schemas and data to easily identify differences.
Improved code performance
Debug stored procedures, format code and optimize SQL performance following best-practices methodology.
Rapid problem identification and resolution
Enables performance tuning with automated SQL scan, optimization and benchmarking; no other tool offers this level of performance tuning.
SQL script recall
Tracks any SQL executed during your Toad session and eliminates the need to retype commonly used SQL, saving time.
Query builder
Access key data quickly; includes built-in report- and pivot functionality, which allows for in-place analysis and single-click export to an Excel instance, so DBAs and analysts can easily export to their favorite tools.
Group execute
Processes scripts and code snippets against multiple servers and instances.
Log reader
Rolls back transactions in the transaction log without the need to restore from a backup.
Security management
Builds and executes security-related scripts against multiple servers to create, manage and even replicate security for all users.
Report generation and documentation
Create customized reports for administration and development and export those reports in flexible formats including .xls, XML, .doc and .pdf.
Object search
Search for text in database objects, e.g., column names and SQL code, and rapidly locate code to quickly assess the impact of renaming or code changes.
Project management
Save and reuse powerful features for object management, SQL and stored-procedure coding.
Powerful task automation
Automate and schedule frequent and repetitive tasks.
Complete suite
Provides a comprehensive, end-to-end toolset, from development through production administration, as well as integration with Spotlight for performance diagnostics.
Consistent toolset across database platforms
Minimizes the learning curve across multiple platforms with a similar look and feel while providing deep functional expertise for the nuances of each platform.
Multi-database SQL queries
Query multiple databases and customize result formatting.
Version control
Use easy, secure, reliable version control that’s compatible with other systems.
MDA-tables dashboard
View data with ease.

Specifications

Client requirements

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
  • 53 MB to run Toad
Operating system
  • Windows Server 2008 (32-bit or 64-bit)
  • Windows Server 2012 (32-bit or 64-bit)
  • Windows Vista (32-bit or 64-bit) Service Pack 2
  • Windows 7 (32-bit or 64-bit)
  • Windows 8 (32-bit or 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.

Server requirements

Database server
  • SAP ASE 12.5.4, 15.0.2, 15.0.3, 15.5, 15.7, 16
  • SAP IQ 15.0, 15.1, 15.2, 15.3, 15.4, 16
  • SAP SQL Anywhere 10, 11, 12
  • SAP HANA SPS08, SPS09

Virtualization Support

Review the following information about using Toad in virtual environments:

Application Virtualization
  • 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.