Altair Monarch vs. Toad Data Point

* Individual seat licenses are very expensive, which is one reason we are moving to CMOD/RMS. But RMS has less functionality than standalone Monarch (now known as "Modeler"). I would like to know what improvements we can expect in RMS, I would also ask, what is the future of the standalone version? * In the past there has been a dearth of user discussion and support in the online community, although this seems to be improving with the new "Datawatch Commmunity" (http://community.datawatch.com).

Incentivized

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

• It allows us to quickly dump large non-ALV SAP reports into Excel. Exporting these reports prior to Modeler was cumbersome at best.
• Customizable models allow us to easily gather required data from the same report running different dates. This is perfect for month-end reports.
• Quick exports.

Incentivized

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

Incentivized

• Setting up visualizations with time series data requires a good understanding of how the software works. I would like it to be more intuitive. Having said that, time series data is inherently complicated and I don't see any obvious ways to make it simpler. But I'm not a software designer myself; they could put more resources into the user experience.
• Their video training is really helpful and they have a big library of videos, but the videos get out of date as they come out with new versions. I can imagine that it's difficult to keep all the videos updated, but it would be great if the videos were always using the latest major version of the product.
• They need more visualizations. They have a pretty big collection now but it seems like there is often some other way to present and visually analyze data that would be a better/tighter fit with requirements than the visualizations available in the standard product. I understand it is possible to add more visualizations - custom visualizations - but that's beyond my expertise.

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

Datawatch recently repositioned Data Pump and essentially priced us out of the market. The initial investment was very inexpensive, but the yearly maintenance contract was viewed as being a little pricey. The only value of the contract was that it included software upgrades. The Professional Services portion of the contract that was meant to provide support was not viewed as being very effective or beneficial.

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

Datawatch is very good value of money compared to QlikView; QlikView is really more of a BI tool and has a lot of functions that I didn't need. Datawatch is very strong in the real-time area where Tableau, Panorama, and Qlik don't do very well. If you need to set up a visual monitoring dashboard, Datawatch is the best product I've seen for that. if you want to do a lot of in depth statistical analysis of large databases, Tableau is probably a good option.

Incentivized

TOAD excels at connecting to divergent data sources, but appears geared more to DBAs than to regular query users. Microsoft's offerings excel against Microsoft SQL Server, but sometimes struggle with other data sources. However, SSMS and vs code excel at many developer productivity/workflow enhancements. vs code, in particular, has a lively extension system that allows it to be tailored for development/querying/model building/etc. That flexibility comes at a cost - the learning curve is steep for new users. The tradeoff between complexity and power may not be good for some environments/users/situations.

Incentivized

• Data Pump reduces complexity of report solutions by offering a standardized approach for organizing and scheduling
• 97% service level for past 5 years for all of our jobs going through Data Pump

Incentivized

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

Incentivized