August 16, 2022
Toad® Data Point is a multi-platform database query tool built for anyone who needs to access data, understand data relationships, and quickly produce reports.
With Toad Data Point, you can:
Toad Data Point provides a full-featured Database Explorer, Query Builder, and Editor for the following databases:
Toad Data Point also provides querying and reporting functionality via the following provider types:
ODBC Connections
The purpose of the ODBC provider is to offer basic connection and querying capabilities to any database that supports an ODBC 3.0 or later driver. For a list of databases tested with the ODBC provider, see the System Requirements in the Release Notes. This form of connectivity allows connections to databases such as Netezza, IBM iSeries, Ingres, and Vertica™. Because this form of connectivity is generic, it is not full-featured and may not be as robust as the fully-exploited providers for the other databases.
Business Intelligence and NoSQL Data Sources
Toad Data Point provides users with the ability to connect to non-traditional data sources, such as Business Intelligence and NoSQL sources. You can connect to these data sources and explore data and objects, query data, report results, and automate tasks.
The following data sources are supported:
Business Intelligence |
SAP Business Objects™ | Google Analytics™ | OData | Oracle BI Enterprise | Salesforce® | SharePoint® | SQL Server Analysis Services |
NoSQL |
Azure Table Service | Cassandra™ | Cloudera Impala | DynamoDB | HBASE™ | Hive™ | MongoDB™ |
Toad provides tools that help you succeed in your query and reporting goals. Many of these tools are considered Best Practices and are beneficial for individual users as well as managers. The following table describes the benefits of using Toad to improve Best Practices:
Best Practice |
Benefit |
---|---|
One tool |
Connect to any database type for basic query needs. Using one tool for all platforms makes it easier to learn and train others. Managers can create common files shared by all users. This ensures consistency for connections, queries, and reports. |
Shared connections |
Easily share connections between users by importing or exporting them. |
Project management |
Organize files and make them easily accessible to provide significant time savings. The Project Manager provides an easy way to group Database Diagrams, queries, and reports. It also provides the following useful features:
|
Automation |
Tasks that are frequently repeated can be automated and scheduled using Automation. You can schedule long running queries to execute during off-hours and can automatically export the results to Excel. You can also add these tasks to the Project Manager, and then double-click them to execute them. Automation offers an extension to your work day without you having to be there. |
Database Diagram |
Database schemas can be complex and difficult for new users to understand. The Database Diagram displays the database relationships between tables to reduce the learning curve. It also provides the following useful features:
|
Query Builder |
Create complex queries visually using the Query Builder. You can also:
|
Excel |
Build Excel reports and share them with colleagues. The One Click Export feature offers options for quickly building Excel reports, including pivot tables for data manipulation. If you want data in an exported report to reflect changes to the database, you can use the One Click Export feature to export the underlying query with the report so it can be refreshed with the latest updates. |
Share Files and Reports |
Store files and reports in libraries that can be shared with colleagues. You can specify a directory on a network share to share these files with others. |
Most reporting projects have a general flow throughout their lifecycle that requires you to understand your data sources, create queries, generate reports based on query results, and automate scripts for repetitive tasks.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center