Toad Data Point - great for SQL queries and data export automation
Rating: 8 out of 10
April 04, 2017
AC
Vetted Review
Verified User
4 years of experience
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.
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.