Toad Data Point - great for SQL queries and data export automation
April 04, 2017

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

Andy Corson | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

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.

Pros

  • 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.

Cons

  • 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.
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

Comments

More Reviews of Toad Data Point