Toad Data Point

loading

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

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

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 Data integration

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 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 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 Automate and schedule frequent workflows and tasks

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

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 Ensure and validate data with compare and sync.

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 Visualize and display data in meaningful ways

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 ER diagrammer and data browsers

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 Access advanced mathematical and statistical functions through SQL

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

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

Data analysis tools that simplify data access, integration and reporting

  • Connect to and integrate all your relational and non-relational data sources.
  • Simplify complex query development and data integration.
  • Transform and cleanse data with ease.
  • Automate routine query and reporting tasks.
  • Validate data quickly and easily.

Overview

Easily access, integrate and work with all your data through Toad™ Data Point. This powerful, yet easy-to-use, toolset automates reporting to save you hours each day. It also makes it simple to share analytics with your team.

Access and join all your data with one tool.

Connect to and join data from all your heterogeneous data sources.

Drag and drop to create queries.

Build queries visually across diverse data sources — without SQL expertise.

Transform data from your desktop.

Perform complex data manipulation tasks quickly; easily transform, cleanse and format data from your desktop.

Automate and schedule frequent workflows and tasks.

Improve productivity with a library of customizable scripts that automate data exporting and emailing, script execution, and more.

Validate data with compare-and-sync functionality.

Analyze data from disparate platforms, verify schema accuracy, and synchronize data to reconcile discrepancies.

Features

Access to all your data
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). Use the power of SQL to run queries against any of these sources.
Drag-and-drop query creation
Build high-performance cross-platform SQL queries and quickly join data from any source, including Excel, RDBMS, NoSQL, Cloud, BI, and Big Data sources, with Toad’s easy-to-use drag-and-drop interface. This powerful tool eliminates the need for SQL expertise.
Desktop data transformation and cleansing
Transform and cleanse data on your desktop—without IT help. Easily modify large datasets, find duplicates, and more by inserting calculations, formatting columns and adding groupings locally from your desktop.
Workflow and task automation
Improve productivity with a library of customizable scripts for automating data exporting and emailing, script execution, and more.
Compare and sync functionality
Improve report accuracy and reduce downstream data manipulation by comparing and synchronizing data sets. Only Toad allows you to analyze data from disparate platforms, verify schema accuracy, and synchronize to reconcile discrepancies.
Desktop data provisioning
Capitalize on the embedded database for more flexible and agile data provisioning. Use the local data store as a sandbox to pre-analyze, manipulate, and profile data prior to analysis. This allows you to work with data offline, without impacting a production system.
SQL editor
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 simplify SQL. The familiar, fully customized interface, which can be configured to look like Toad for Oracle, provides intuitive, drag-and-drop wizards to speed SQL editing.
Robust data display
Share your data results with users in more meaningful ways by designing professional charts, graphs and reports—without exporting data to Excel. You can also create visualizations and navigate the data interactively.
ER diagrammer and data browsers
Visualize and annotate table relationships to create your own 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.
Advanced mathematical and statistical functions
Improve profitability and efficiency by moving beyond historical reporting to predictive analytics. With a library of more than 170 mathematical and statistical functions on your desktop, you can perform advanced analytics to predict customer behavior, score customers, perform predictive modeling, statistical analysis and more.
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.

Specifications

System requirements

CPU
  • 1 GHz
Memory
  • 512 MB
Hard disk space
  • 2 GB
Operating system
  • Microsoft® Windows Server® 2003
  • Windows® XP
  • Windows Vista®
  • Windows Server 2008
  • Windows 7 and 8 (32-Bit or 64-Bit)
  • Windows Server 2012
.NET Framework
  • Microsoft® .NET Framework 4.0
  • Teradata® .NET Data Provider (13.10 or higher)
Web browser
  • Internet Explorer® 6.0 or higher

Data sources

 
  • Amazon® Redshift®
  • Amazon SimpleDB®
  • Amazon DynamoDB®
  • Apache® Hbase®
  • Apache Hive®
  • Apache Cassandra®
  • Google Analytics®
  • IBM® DB2® for i5/OS v5R4 and IBM® i6.1
  • IBM Informix® Dynamic 10.00, 11.0
  • IBM DB2 for Linux®, UNIX® and Windows® 8.1.5, 8.2, 9.1, 9.5, 9.7, 10.1
  • IBM DB2 for z/OS® 8, 9, 10
  • IBM Netezza® 4.6.6, 6.0
  • Ingres® Community Edition 2006 R2 on Windows 32-Bit
  • Microsoft® Access® 2003, 2007, 2010
  • Microsoft Excel® 2003, 2007, 2010
  • Microsoft OData®
  • Microsoft SQL Server® 2000, 2005, 2008 (R2), 2012
  • Microsoft SQL Server Analysis Services
  • Microsoft SQL Server databases running on Amazon EC2®
  • Microsoft SharePoint®
  • Microsoft® Windows Azure® Table Storage Service
  • Microsoft Windows Azure Marketplace DataMarket
  • Microsoft Windows Azure SQL Database
  • MongoDB®
  • MySQL® 4.1, 5.0, 5.1, 5.6
  • ODBC generic
  • Oracle® databases running on Amazon EC2
  • Oracle® Business Intelligence Enterprise Edition 11g
  • Oracle® 9i, 10g, 11g, 11g R2 (tested on Oracle® Exadata 2.0)
  • PostgreSQL® 8.3.4
  • salesforce®
  • SAP® Business Objects® XI 3.0, 3.1
  • 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
  • Vertica® 4.1, 5.0, 5.1 (with 4.0, 4.1 ODBC driver), 6.0 (with 6.0 ODBC driver)

Detailed requirements

Download free trial to see the full list of system requirements.

What's New

Version 3.5

  • Additional BI and NoSQL connectivity, including Google Analytics®, Azure® DataMarket, Azure Table Storage Service, Cassandra®, OData®, DynamoDB®, SimpleDB®, Apache® HBase®, MongoDB®, and Microsoft® SharePoint®
  • Toad™ Intelligence Central connectivity for sharing Toad documents with other users; includes query builder, data compare, transform and cleanse, data visualizations, Toad data reports, ER diagrams and more
  • Single sign-on with your corporate credentials when connecting to salesforce®

Version 3.4

  • Ability to publish objects and automation scripts to Toad™ Intelligence Central
  • Support for Oracle® 64–bit
  • Improved database administration, data management, query development, import/export and automation features