|

Toad Data Point

Celebrate Small Business Week.
Save 35% on PCs and select servers built for business with coupon code: ​RLN61MGR5CDBVH
Shop Now

Accelerate querying, data integration, and reporting.

Simplify data access, analysis, and provisioning with Toad™ Data Point.


 

 

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.

Data profiling
Visually profile 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.
Connect to all your relational and non-relational data sources
Access nearly any data source, from traditional relational sources (including Oracle®, SQL Server®, Sybase®, IBM® DB2, Teradata®, Microsoft® Access®, and any ODBC-compliant platform) to non-database sources (including Microsoft® Excel® and Microsoft® SharePoint®) to NoSQL systems (including Apache® Hadoop™/Hive™, Salesforce®, SAP® Business Objects, and Oracle® Business Intelligence platforms). Use the power of SQL to run queries against any of these sources.

Simplify data integration with drag-and-drop cross-platform queries
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.

Easily transform and cleanse data
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 from your desktop.

Automate and schedule frequent workflows and tasks
Improve productivity with a library of customizable scripts for automating data exporting and emailing, script execution, and more.

Validate data with 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.

Near-limitless data 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). 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.
  • System requirements

    Platform
    1 GHz

    Memory
    512 MB

    Hard disk space
    2 GB

    Operating system
    Microsoft® Windows Server® 2003
    Microsoft Windows® XP
    Microsoft Windows Vista®
    Microsoft Windows Server 2008
    Microsoft Windows 7 and 8 (32-Bit or 64-Bit)
    Microsoft Windows Server 2012

    .NET Framework
    Microsoft .NET Framework 4.0
    Teradata® .NET Data Provider (13.10 or higher)

    Required browser
    Internet Explorer® 6.0 or higher

    Data sources

    Oracle® 9i, 10g, 11g, 11g R2 (tested on Oracle Exadata 2.0)
    SQL Server® 2000, 2005, 2008 (R2), 2012
    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
    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
    Microsoft Access® 2003, 2007, 2010
    Microsoft Excel® 2003, 2007, 2010
    IBM DB2 for i5/OS V5R4 and IBM i 6.1
    IBM Informix® Dynamic 10.00, 11.0
    Ingres® Community Edition 2006 R2 on Windows 32-Bit
    IBM 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)
    Oracle databases running on Amazon EC2
    Windows Azure™
    SQL Server® databases running on Amazon EC2
    Amazon Redshift
    SAP® Business Objects XI 3.0, 3.1
    Apache® Hadoop™
    Oracle Business Intelligence Enterprise Edition 11g
    Salesforce®
    Microsoft SQL Server Analysis Services
Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
   
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
   
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
close
 
 
CS05