Toad Data Point
Visit shop.quest.com to buy this product online.
Buy Online »
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 Data Point

The Right Data Analysis Tool to Access, Integrate, and Provision Data

Toad™ Data Point is a cross-platform query and data integration tool that simplifies data access, analysis, and provisioning for data management professionals. This data analysis tool provides nearly limitless data connectivity, desktop data integration, visual query building, and workflow automation.

Features

Limitless Connectivity Connect to nearly any data source, from traditional relational sources (including Oracle, SQL Server, Sybase, DB2, Teradata, Access, and any ODBC-compliant platform) to non-database sources (including Excel and SharePoint) to non-SQL systems (including Salesforce.com, Business Objects, and Oracle Business Intelligence platforms). Run SQL queries against any of these sources.

Data Integration – Simplify data integration through cross-platform SQL queries.

Automation Engine – Automate and schedule routine tasks to increase your productivity; develop sophisticated workflows to support advanced projects.

Local Data Store – Capitalize on the embedded database to become more flexible and agile with your data sets.

SQL IDE – Write SQL statements in a robust, customizable editor that provides SQL Complete, automatic formatting, instant SQL recall, as well as a variety of other features that make writing SQL easy.  

Visual Query Builder – Develop advanced single-platform and cross-platform SQL queries through an easy-to-use drag and drop interface.

Advanced Analytics Library – Access advanced mathematical and statistical functions through SQL.

Data Visualization – Navigate interactive data visualizations to better understand your result sets.

Compare and Sync – Compare and synchronize data between different data sources to ensure consistency and validity.

Data Cleansing Area – Transform and cleanse your result sets (add calculations, columns, and groupings, find duplicates, and more) with a straightforward interface.

ER Diagrammer and Data Browsers – Visualize and annotate table relationships to create your own relationship templates; view master-detail relationships; browse database tables and objects. 

Charts and Reports – Design professional charts and graphs to share your data results.

Import/Export Utility Wizard – Load and unload data efficiently. Easily export and publish data to Excel, .CSV, .TXT, HTML, PDF, and a variety of other file formats.

Sys Reqs

System Requirements

Client Requirements

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

Platform

1 GHz Processor (recommended 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

1.33 GB to install Toad
475 MB to run Toad Professional edition, 350 MB to run Toad Base edition
Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server 2003
Windows XP Professional (32-bit or 64-bit)
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows 7 (32-bit or 64-bit)
Windows Server 2012
Windows 8 (32-bit and 64-bit)

.NET Framework

Microsoft .NET Framework 4.0
Note: The .NET Framework Client Profile is not supported.
Teradata .NET Data Provider
You must install the Teradata .NET Data Provider (13.10 or later) to use a Teradata native connection in Toad.
Note: To use a Teradata connection in a cross-connection query, you must also install a Teradata (13.10 or later) ODBC driver.

Database Client

Existing DB2 Client Support (DB2 native provider only)
Toad installs a DB2 9.7 (fix pack 6) client as part of the installation process. The DB2 9.7 client can co-exist with an existing DB2 8 client, but is incompatible with a DB2 7 client. If a DB2 7 client already exists on your computer, the Toad installation stops and cannot complete. To resolve, first upgrade to the DB2 8 client. Then restart the Toad installation to avoid losing functionality in some DB2 native tools.
Existing 64-bit DB2 Client (DB2 native provider only)
If you have a 64-bit DB2 client installed, you must install Toad using the ToadDataPoint_64bit_Client.exe.
Oracle Client
Toad can connect to Oracle using Direct Connect (no need for an Oracle Client) or can connect using an Oracle Client or Oracle Instant Client. However, if you want to use LDAP, you must install an Oracle Client. Toad supports 9i or later Oracle Clients and Oracle Instant Clients.
Notes:

  • You cannot use Oracle Direct Connection in a cross-connection query.
  • To use an Oracle connection in a cross-connection query, you must install an Oracle Client (full install) or you must install the Oracle Instant Client plus the Oracle ODBC driver.

Additional Requirements

Web Browser
Microsoft Internet Explorer 6.0 or later

Server Requirements

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

Operating System

Oracle Native Database Provider
IBM AIX 5.1, 5.2, 5.3
HP-UX 11i 1.5, 2 (32-bit or 64-bit)
Red Hat Enterprise Linux AS release 3 and 4 (32-bit or 64-bit)
Solaris 7, 8, 9, 10 (32-bit or 64-bit)
SuSE 7, 8, 9
Windows 2003 (32-bit or 64-bit)
Windows XP
SQL Server Native Database Provider
Windows Server 2000 Service Pack 4 or later
Windows 2000 Professional Edition Service Pack 4 or later
Windows XP (32-bit with Service Pack 2 or later and 64-bit)
Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows Server 2008 R2 (64-bit)
Windows 7 (32-bit or 64-bit)
DB2 for z/OS Native Database Provider
z/OS (V1R6 Base Services [5694-A01] or later)
DB2 for LUW Native Database Provider
IBM AIX 5.1, 5.2, 5.3, 6.1
HP-UX 11i 1.5, 2 (32-bit or 64-bit)
Red Hat Enterprise Linux AS release 3 and 4 (32-bit or 64-bit)
Solaris 7, 8, 9, 10 (32-bit or 64-bit)
SuSE 7, 8, 9
Windows 2000, 2003 (including 64-bit), 2008, XP, Vista, Windows 7
MySQL Native Database Provider
Windows 2003
Windows Server 2000 Service Pack 4 or later
Windows 2000 Professional Edition Service Pack 4 or later
Windows XP (32-bit with Service Pack 2 or later and 64-bit)
Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows Server 2008 R2 (32-bit or 64-bit)
Windows 7 (32-bit or 64-bit)
Sybase Native Database Provider
Windows XP (32-bit with Service Pack 2 or later and 64-bit)
Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows Server 2008 R2 (64-bit)
Windows 7 (32-bit or 64-bit)

Native Database Server

Toad supports the following databases:
Oracle 9i, 10g, 11g, 11g R2
Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.
Limited support of SQL Server 2000 (Service Pack 3 or later)
Note: The following features are not available:

  • Index Defragmentation
  • Storage Management
  • Performance Monitor
  • Project Lucy Performance Analytics
  • Altering procedures, functions, views in the Editor
  • Version Control

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express
SQL Server 2008 and SQL Server 2008 Express
SQL Server 2008 R2 and SQL Server 2008 R2 Express
SQL Server 2012 and SQL Server 2012 Express
Note: SQL Server Compact Edition is not supported.
IBM DB2 for LUW 8.1.5, 8.2, 9.1, 9.5, 9.7, 10.1
IBM DB2 for z/OS 8, 9, 10
Notes:

  • To run RUNSTATS and the native REORG utility on tablespaces and indexes in DB2 for LUW, Toad supports DB2 for LUW 8.2.2 or later.
  • Toad may support IBM DB2 Express and SWE in addition to listed above servers, but note that no testing was performed on it.
  • Toad supports DB2 8 for z/OS running in Full Function mode, but does not support DB2 8 for z/OS running in Compatibility mode.

MySQL 4.1, 5.0, 5.1, 5.6
Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5
Sybase IQ 15
Sybase SQL Anywhere 12
Teradata 12.0, 13.0, 13.10
Access 2003, 2007, 2010
Excel 2003, 2007, 2010

ODBC Database Server

Toad Data Point allows you to create a connection to a database that supports an ODBC 3.0 or later driver. ODBC connectivity provides basic querying capability, but may not be as full-featured as a native connection in Toad. Toad has been tested on the following databases, using an ODBC connection:

  • DB2 for i5/OS V5R4 and IBM i 6.1
  • Informix Dynamic 10.00, 11.0 (limited testing)
  • Ingres Community Edition 2006 R2 on Windows 32-bit (limited testing)
  • Netezza Data Warehouse Appliance 4.6.6, 6.0
  • PostgreSQL 8.3.4
  • Vertica 4.1, 5.0, 5.1 (with 4.0, 4.1 ODBC driver), 6.0 (with 6.0 ODBC driver)

Note: For a list of databases that are not supported, see Known Issues in the Release Notes.

Cloud Database Service

Oracle databases running on Amazon EC2
SQL Azure
Note: To connect to SQL Azure, you must have read access to the master database and VIEW DEFINITION grant on the databases you want to work with.
SQL Server databases running on Amazon EC2
Amazon Redshift
Toad can manage Amazon RDS and any other cloud or service offering compatible with MySQL.

Quest Data Services -
Premium Connections

Toad has been tested with, and supports, the following Business Intelligence / Cloud platforms:

  • Business Objects XI 3.0, 3.1
  • Hive
  • Oracle Business Intelligence Enterprise Edition 11g
  • Salesforce.com
  • Microsoft SQL Server Analysis Services

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix XenApp 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Desktop Virtualization (VDI)

Toad has been tested with Quest vWorkspace 7.0 running on Windows XP Professional 32-bit (Service Pack 2).

Server Virtualization

Toad has been tested with the following:

  • Oracle VM 3.1 running on Red Hat Enterprise Linux 64-bit with Oracle 11gR2
  • Oracle VM 2.2 running on Windows 2008 32-bit with Oracle 11gR2

Language Supported:

  • US English

 

Videos

Toad for Data Analysts is now Toad Data Point.

Screenshots

Toad Data Point – Write and edit SQL queries without being an expert

Toad Data Point

Toad Data Point makes it easy to write SQL statements in a robust, customizable editor that provides SQL Complete, automatic formatting, instant SQL recall, as well as a variety of other features that make writing SQL simple. Toad provides a familiar, fully configurable interface that can be customized to look like Toad for Oracle and offers intuitive, drag-and-drop wizards to speed SQL editing

Toad Data Point – Data integration

Toad Data Point

Simplify self-service data integration with drag-and-drop, high-performance, cross-platform queries. Easily run SQL queries to access Excel, RDBMS, NoSQL, Cloud, BI, and Big Data, then quickly join your data—all from a single tool, without being a SQL expert.

Toad Data Point – Limitless connectivity

Toad Data Point

- Connect to nearly any data source, from traditional relational sources (including Oracle, SQL Server, Sybase, DB2, Teradata, Access, and any ODBC-compliant platform) to non-database sources (including Excel and SharePoint) to NoSQL systems (including Hadoop/Hive, Salesforce.com, Business Objects, and Oracle Business Intelligence platforms). Utilize the power of SQL to run queries against any of these sources.

Toad Data Point – Automate and schedule frequent workflows and tasks

Toad Data Point

Eliminate manual, repetitive workflow tasks by scheduling them within Toad Data Point’s automated scripts. Improve productivity and efficiency with flexible and extensible scripts and customize them to your business needs or for different audiences. Toad Data Point provides a library of automated templates, including those for exporting and emailing data, executing scripts, and more.

Toad Data Point – Easily transform and cleanse data

Toad Data Point

Easily transform and cleanse data right from your desktop without help from IT. With Toad, you can easily modify large datasets, find duplicates, and transform data by adding calculations, formatting columns and adding groupings locally from your desktop.

Toad Data Point – Ensure and validate data with compare and sync

Toad Data Point

Improve the accuracy of your reports and reduce downstream data manipulation by comparing and synchronizing the data after creating your data set. Only Toad allows you to analyze data from disparate platforms, verify the accuracy of the schemas, and synchronize that data when there are discrepancies.

Toad Data Point – Visualize and display data in meaningful ways.

Toad Data Point

Design professional charts and graphs to share your data results to users in more meaningful ways. Toad makes it easy to generate your own charts, graphs and reports without exporting the data to Excel. You can also create visualizations and navigate the data interactively.

Toad Data Point – ER diagrammer and data browsers

Toad Data Point

Visualize and annotate table relationships to create your own relationship templates, view master-detail relationships, and browse database tables and objects. This enables you to quickly profile data models from heterogeneous- and disparate data sources without exporting data to another tool.

Toad Data Point – Access advanced mathematical and statistical functions through SQL

Toad Data Point

Improve the profitability and efficiency of your organization by moving beyond historical reporting to predictive analytics. With a library of more than 170 mathematical and statistical functions available from your desktop, you can perform advanced analytics for things like predicting customer behavior, scoring customers, predictive modeling, statistical analysis and more.

Toad Data Point – Import and export to Excel and other applications with ease

Toad Data Point

Load and unload data efficiently. Easily export and publish data to Excel, .CSV, .TXT, HTML, PDF, and a variety of other file formats.