Toad Data Point - great for SQL queries and data export automation
Andy Corson | TrustRadius Reviewer
April 03, 2017

Toad Data Point - great for SQL queries and data export automation

Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Toad Data Point

Toad Data Point is used by one department to provide automated reports for multiple groups within Supply Chain. It is used to automate repetitive tasks that analysts would typically do manually such as exporting and manipulating data in Excel.
  • Toad is particularly good for writing SQL queries because of the drag and drop features that automatically create scripts as well as the intellisense feature for including specific columns in queries.
  • Toad has a simple yet powerful automation script interface which makes it very easy to automate execution of queries and exporting of data.
  • Toad has numerous data connection wizards, and it is very easy to connect to any data source.
  • Toad boasts a cross connection query wizard, but queries have always run very slowly for me, and I do not use this feature after I initially tried it out.
  • Toad sometimes crashes unexpectedly when I disconnect from data sources.
  • Occasionally the intellisense feature hangs and doesn't return the column list when coding SQL. Also, the filters on the query results hang with larger result sets and then never pop up.
Many data source options, easy to connect, organized display of sources by type. Cross connectivity has poor performance, Slow data flows in ETL process.
Scheduling and report distribution is easy to use, although it doesn't support Exchange address book. The true report collaboration tool is not part of Toad Data Point, it is another software.
Toad is well suited for creating ad hoc queries and exporting data to Excel. It is also good for analyzing tables in preparation for creating ETLs, creating and altering views and stored procedures quickly. It is less appropriate with complex ETL processes because it runs very slowly and cannot process multiple data flow simultaneously.

Toad Data Point Feature Ratings

Report Formatting Templates
Not Rated
Formatting capabilities
Not Rated
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
9
Publish to PDF
Not Rated
Report Delivery Scheduling
9
Pre-built visualization formats (heatmaps, scatter plots etc.)
Not Rated
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
Multi-User Support (named login)
Not Rated