RepreZen API Studio vs. Toad Data Point

RepreZen API Studio is well suited for running on two operating systems and the nice UIs are good. But better appearance could improve the UX.

Toad Data Point is the clear tool of choice if the end-user is interested in reports that are relatively simple to build using SQL code and export to Excel. It is less useful if the analyst also needs to run statistical models on the data and visualize the data for those functions I usually use RStudio or Jupyter Notebook which incorporates those features much more seamlessly.

Incentivized

• Running on OS X and Windows
• Great performance
• Nice UI and UX

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

Incentivized

• The program can error out when reconnecting to a database from a timeout but that is easily fixed by restarting the program.
• If you aren't familiar with database tools the UI can be overwhelming to some.

Incentivized

I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap

Incentivized

It's really easy to make APIs via RepreZen API Studio.

Toad give me more flexibility. Being able to utilize FTP to send data and receive files from external systems is wonderful. Using the automation tool to run different database, file, and system activities has made my day-to-day functions easy. Being able to schedule tasks right from the software has also made thing easy.

Incentivized