TrustRadius: an HG Insights company

Toad Data Point

Score8 out of 10

41 Reviews and Ratings

Get a Demo

What is Toad Data Point?

Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and workflow automation.

Categories & Use Cases

Reviews

What users are saying about Toad Data Point.
View all reviews

Excellent Utility Environment Across Multiple Data Sources

Incentivized
Verified User
Professional in Research & Development (10,001+ employees employees)

Use Cases and Deployment Scope

I work as a data scientist, marshalling and summarizing data for model-making and analytics to be run against it. I use Toad as a development and query environment against our corporate data warehouse, which encompasses multiple data sources. The target is a Netezza data appliance and the majority of work we do utilizes standard, uncomplicated SQL against

Pros

  • Connects to multiple data sources
  • Allows code folding to encourage focus on subsections of code
  • Is standard across multiple database engines
  • Is stable and well documented across its history

Cons

  • Leaks memory in Windows 10 (at least as currently configured)
  • Occasionally hangs and requires a restart
  • Some operations are either multi-step or unintuitive
  • Does not support extensions to change functionality

Return on Investment

  • It is the least common denominator - not particularly optimized for our environment or workflows.
  • Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
  • Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
  • It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.

Alternatives Considered

SQL Server Management Studio (SSMS) and Microsoft Visual Studio Code

Other Software Used

SQL Server Management Studio (SSMS), Microsoft Visual Studio Code, Notepad++

The best option for data analysts who know SQL

Incentivized
Yoni DvorkisView profile
Lead Data Scientist in Information Technology at Atrius Health (1001-5000 employees employees)

Pros

  • Export data into excel.
  • Export data into excel using a pivot table functionality.
  • Navigation between windows is intuitive and easy to understand.
  • Good for SQL novices and experts alike.

Cons

  • Occasionally freezes up when disconnected from the laptop docking station.
  • Better functionality to export data into Excel on an automated basis needed for automated querying.
  • Better integration with Python Jupyter notebook.

Alternatives Considered

RStudio and Microsoft Access

Other Software Used

RStudio, TIBCO Spotfire, Microsoft Access

Considering a Business Analysis tool? Consider Toad Data Point.

Incentivized
Dan Hotka
Oracle ACE Director in Professional Services at www.DanHotka.com, LLC (1-10 employees employees)

Pros

  • Ease of building SQL/accessing data, using the Query Builder.
  • The new workflow feature mimics products like Hyperion and is centered on how business analysts are used to working with their data.
  • The dimensional views are definitely a hidden gem. This feature allows you to display similar data in multiple windows, then filter on specifics. ALL windows will then reflect the same data. An example here would be salaries organized by dept then salaries organized by job type. As you filter, both analyses will reflect the filtered data.
  • You can easily create spreadsheets and pivot table spreadsheets.
  • You can email the results to the team/you can save the results in the intelligence central repository so others can access it.
  • You can automate all of these things.

Cons

  • The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now.
  • Would be nice if the 'Automate' feature was a bit easier to use.
  • Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release).
  • Would be nice if there were fewer releases.

Alternatives Considered

Business Intelligence Discoverer

Other Software Used

Microsoft Office 365, Oracle BI Foundation Suite, Toad for Oracle

Usability

Toad Data at it's Best!

Incentivized
Steve BynumView profile
Data System Specialist in Information Technology at Poquoson City Public School (201-500 employees employees)

Pros

  • Ease of use. It is a very easy product to use without any particular training.
  • Multiple data source connection. It easily connects to multiple data sources which allows you to use different data sources to run reports.
  • Seamless application. Once you set everything up-- whether it is an FTP or export of data-- you can set it and forget it!

Cons

  • Training. I think they should offer some basic training, which is all that was needed.
  • Licensing. We had to purchase a couple of copies for two machines. I am not sure if anything can be done about that.
  • Vender Expos. Have not heard of them being at any national conferences.

Alternatives Considered

SQL Developer

Other Software Used

Microsoft Access, Microsoft SQL Server, SAP Crystal

Solve that Dataset consolidation Issue

Incentivized
Andrew KuhnView profile
System Analyst Manager in Information Technology at Cigna (10,001+ employees employees)

Pros

  • Joins data from across Oracle, Access, Google Analytics
  • Can pull from Sharepoint lists data
  • The ability to cleanse data and transform easily
  • The user interface is very easy to use for not so technical users

Cons

  • The connections can be a bit slow to setup
  • More functionality could be added to the process that can easily be transformed or cleansed
  • Continue to add more data sources

Alternatives Considered

Tableau Desktop, Oracle Hyperion Enterprise Performance Management and Toad for Oracle

Other Software Used

Microsoft Access, Oracle Hyperion Enterprise Performance Management, Jabber