Toad Data Point

loading

Simplifies SQL queries

Simplifies SQL queries

Write and edit queries without expertise. A customizable UI automates formatting and speeds editing.

Data integration

Data integration

Integrate and join data. Drag-and-drop to run high-performance, cross-platform queries.

Limitless connectivity

Limitless connectivity

Connect to nearly any source: traditional/relational sources, non-database sources and NoSQL systems.

Automation and scheduling

Automation and scheduling

Save time and increase productivity with a library of templates to automate and schedule tasks.

Transform data

Transform data

Transform and cleanse data on your desktop without IT help. Modify large datasets, find dupes and more.

Validate data

Validate data

Compare and synch data sets to improve report accuracy and reduce downstream data manipulation.

Import and export data

Import and export data

Load, unload and move data efficiently. Export and publish data to Excel®, .CSV, .TXT, HTML, PDF, etc.

Improve data quality

Improve data quality

Integrated data profiling reveals data quality issues quickly and easily.

Self-service data access, integration and preparation tool

  • Connect to and integrate all your relational and non-relational data sources.
  • Simplify complex query development and data integration.
  • Profile data to ensure accuracy.
  • Automate routine query and reporting tasks.
  • Validate data quickly and easily.

Overview

Easily access, integrate and work with all your big data sources through Toad Data Point. This powerful, yet easy-to-use, toolset automates routine tasks to save you hours each day. It also makes it simple to share analytics with your team and improve data quality. Find out which edition is right for you.

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.

Find and fix data quality issues quickly and easily

Use powerful data profiling capabilities to visualize and sample database tables and data sets for patterns, unique values, duplicates, missing information, min./max. values and more.

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

Library Module NEW in Version 3.8
Organize your data preparation and query projects better with the new Library module which automatically creates a searchable index of all your work items.
Improved desktop data preparation and cleansing New in Version 3.8
Do more to improve and clean your data with more options to Transform and Cleanse data on your desktop — without IT help. Easily curate a reusable library of single preparation steps or whole preparation routines. Suggestion engine will detect and suggest actions to help with data preparation.
Support for SAP HANA and Hive Server 2 New in Version 3.8
Now Toad Data Point includes native connectivity for SAP HANA and Hive Server 2 including support for Kerberos authentication.
Improved performance for MongoDB New in Version 3.8
Connect to, explore and write queries against your MongoDB instances easier.
Access to all your data
Connect to nearly any data source, from traditional relational sources to non-database sources and NoSQL systems, as well as 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 Salesforce, 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.
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, and synchronize to reconcile discrepancies.
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.
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.
Dimensional viewer
Quickly aggregate and pivot data. Build custom, multi-dimensional views of your data. Apply groupings and calculations and use rollup columns to easily view aggregated data.
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.
Toad Intelligence Central connectivity
Connect to a Toad collaboration environment that allows all Toad users to share common documents such as ER diagrams, visual query files, sql editor files, etc. Also easily publish and schedule automations to run on the Toad Intelligence Central server.
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.

Specifications

System requirements

CPU
  • 2 GHz Processor
Memory
  • 2 GB RAM, 4 GB recommended
Hard disk space
  • 800 MB to install Toad Data Point, 450 MB to run Toad Data Point
Operating system
  • Microsoft Windows Server 2008 (32-bit or 64-bit)
  • Microsoft Windows Server 2012
  • Microsoft Windows Server 2012 R2
  • Microsoft Windows 7 (32-bit or 64-bit)
  • Microsoft Windows 8 (32-bit and 64-bit)
  • Microsoft Windows 8.1 (32-bit and 64-bit)
.NET Framework
  • Microsoft .NET Framework 4.5, 4.0
  • Teradata .NET Provider (13.10 or higher)
Web browser
  • Microsoft Internet Explorer 6.0 or higher

Data sources

 
  • Oracle 9i, 10g, 11g, 11g R2, 12c
  • SQL Server® 2000, 2005, 2008, 2008 R2, 2012, 2014
  • IBM DB2 for LUW 9.1, 9.5, 9.7, 10.1, 10.5, 10.5.0.5
  • IBM DB2 for z/OS 9, 10, 11
  • MySQL 4.1, 5.0, 5.1, 5.5, 5.6
  • MariaDB 5.5.5 (using MySQL provider)
  • SAP ASE 12.5.4, 15.0.2, 15.0.3, 15.5, 15.7, 16
  • SAP IQ 15, 16
  • SAP SQL Anywhere 12
  • SAP HANA SPS08, SPS09
  • Teradata 12.0, 13.0, 13.10, 14, 15
  • Access® 2003, 2007, 2010, 2013
  • Excel® 2003, 2007, 2010, 2013
  • DB2 for i5/OS V5R4 and IBM i 6.1
  • Greenplum® Database
  • Informix Dynamic 10.00, 11.0 (limited testing)
  • Ingres Community Edition 2006 R2 on Windows 32-bit
  • Netezza Data Warehouse Appliance 4.6.6, 6.0, 7.0
  • PostgreSQL® 8.3.4
  • Vertica 4.1, 5.0, 5.1, 6.0, 6.1, 7.0
  • Oracle databases running on Amazon EC2
  • SQL Azure
  • SQL Server databases running on Amazon EC2
  • SAP Business Objects XI 3.0, 3.1, 4.1
  • Oracle Business Intelligence Enterprise Edition 10g, 11g
  • Salesforce.com®
  • Microsoft SQL Server Analysis Services
  • Google Analytics™
  • Azure Data Market
  • OData
  • SharePoint
  • Azure Table Services
  • Apache Cassandra™
  • Amazon DynamoDB
  • Apache HBASE™
  • Apache Hive™
  • MongoDB™

Detailed requirements

To see a full list of system requirements please visit https://support.software.dell.com/toad-data-point/3.8

Videos