Datasheet

Learn more about how Toad for Cloud Databases makes it simpler than ever to access complex data stores and manage them with ease.

Read now »

Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »

Toad for Cloud Databases

Toad™ for Cloud Databases provides a SQL-based interface that makes it simple for you to generate queries, migrate, browse, and edit data, as well as create reports and tables in a familiar SQL view. With Toad for Cloud Databases, it’s easy to load and export data from cloud databases to a variety of external data sources, including RDBMS.

Toad for Cloud Databases:

  • Puts ‘NoSQL’ databases within your reach — even if you’re an RDBMS developer or DBA
  • Supports business decision making with fast access to cloud data
  • Supports ANSI-standard SQL issued against cloud datasets
  • Speeds accurate query generation through the query builder
  • Lets you browse data and edit in-place
  • Helps you create “tables” or their logical equivalent
  • Supports DML SQL (UPDATE, INSERT, DELETE statements)
  • Loads data from and exports data to a variety of external data sources, including RDBMS
  • Provides assistance for deploying and managing Amazon EC2 instances

Features

There are two key components of Toad for Cloud Databases: the first is the Toad client, and the second is the Toad data hub.

Toad Client – Contains the intuitive user interface through which remote cloud database access is easily configured and SQL statements are written and executed. It provides all of the standard Toad features and includes:

  • SQL Editor – for creating, executing, modifying and saving queries as well as viewing and editing data and processing DDL commands.
  • Query Builder – for using a graphical interface to construct complex operations without the need for SQL programming. This includes selecting tables and views, selecting and joining columns, and adding conditions; it also allows you to query and join data across multiple database platforms.
  • Report Generator – for producing business-quality reports of either data or database structure. Reports can show the structure and source code for database objects or display data as tables, pivots and charts.
  • Import/Export Utility - for exporting data to Excel with just one click and supporting a variety of other file formats, including .CSV, .TXT, .HTML, and PDF.
  • Database Browser – for displaying and managing all database objects graphically, with single-click access to object details, data, and underlying DDL.

Toad Data Hub – Receives the SQL statements submitted by the user through Toad, translates them into the appropriate API calls to fetch or update data in the designated cloud database, and returns the results in the familiar tabular format of rows and columns.

This server is installed with the Toad client and can be run on the local PC or deployed out in the Amazon cloud.

Sys Reqs

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Platform1 GHz processor.
Memory512 MB of RAM minimum, 1 GB recommended
Hard Disk Space550 MB 
Operating System
  • Windows XP (32-bit)
  • Windows Vista (32-bit)
  • Windows 7 (32-bit and 64-bit)
.NET Framework

Microsoft .NET Framework 3.5 (Service Pack 1)

Note - The following conditions apply:

  • The .NET Framework Client Profile is not supported.
  • To run Toad, the .NET security policy must be set to unrestricted. See "User Requirements and Restrictions for Running Toad" (page 8) for more information.

 

Web BrowserMicrosoft Internet Explorer 6.0 or later
Supported Platforms
  • Amazon SimpleDB
  • Microsoft Azure Table services
  • Apache HBase
  • Microsoft SQL Azure
  • Any ODBC-enabled relational database
  • Apache Cassandra
  • MongoDB

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user--a Power User, Restricted User, Vista standard user--on the computer.

Language Supported:

  • US English

Screenshots

Toad for Cloud Databases

Toad for Cloud Databases

Mapping a SimpleDB table to a SQL table.

Toad for Cloud Databases

Toad for Cloud Databases

Selecting SimpleDB columns to be included in a mapped table.

Toad for Cloud Databases

Toad for Cloud Databases

Selecting SimpleDB columns to be included in a mapped table.

Toad for Cloud Databases

Toad for Cloud Databases

Creating a database diagram for some simpleDB tables.

Toad for Cloud Databases

Toad for Cloud Databases

Selecting HBase columns to be included in a mapped table.

Toad for Cloud Databases

Toad for Cloud Databases

Creating a SQL sub-table for a HBase column family.

Toad for Cloud Databases

Toad for Cloud Databases

Sending a Hbase table to the database diagrammer.

Toad for Cloud Databases

Toad for Cloud Databases

HBase table with column family shown in the database diagrammer.

Toad for Cloud Databases

Toad for Cloud Databases

Sending HBase tables to the query builder.

Toad for Cloud Databases

Toad for Cloud Databases

Mapping a HBase table without a column family.

Toad for Cloud Databases

Toad for Cloud Databases

Building a WHERE condition for a query in the query builder.

Toad for Cloud Databases

Toad for Cloud Databases

Three way join on HBase tables in the query builder.

Toad for Cloud Databases

Toad for Cloud Databases

SQL Statement generated by the query builder.