Altair Monarch (formerly Datawatch Monarch, acquired by Altair in December, 2018) works with both relational and multi-structured data including support for a wide range of formats including PDF, XML, HTML, text, spool and ASCII files. The product can access data from invoices, sales reports, balance sheets, customer lists, inventory, logs and more. According to the vendor, the system is easy to use, allowing users to quickly select any data source and automatically convert it into…
N/A
Astro by Astronomer
Score8.7 out of 10
N/A
For data teams looking to increase the availability of trusted data, Astronomer provides Astro, a data orchestration platform, powered by Airflow. Astro enables data engineers, data scientists, and data analysts to build, run, and observe pipelines-as-code. Astronomer is the driving force behind Apache Airflow™, the de facto standard for expressing data flows as code. Airflow is downloaded more than 8 million times each month and is used by hundreds of thousands of teams around the world.
N/A
Toad Data Point
Score8.4 out of 10
N/A
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.
The product is especially useful when you have real-time and/or time series data to analyze. If you have more mundane, simpler requirements, other products might do the job you need for less money (there are even some decent open source visualization tools you can find.) I know the product is very widely used in capital markets applications to monitor and analyze risk and price and volume changes; if you're working in that area, I don't think there's a better tool to use.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Astronomer is well suited for workflow and dependency management for enterprise-level data lakes. It is not a product for data processing though. Different source systems can be integrated, it also provides powerful interfaces for alerting and monitoring. Easy to build DAGs, graphical UI, API support makes the product more user-friendly as well. Astronomer also does a great job on user training.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Creating a basic model to extract data from a report is very easy.
Advanced features like Calculated Fields and External Lookups allow you to augment the raw data.
You can create a "project" to automate the data extraction. Combined with Datapump (a separate DW app), you can fully automate the process once the raw report is generated.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Recently, we had some major sticker-shock when we wanted to upgrade Data Pump. It is an exceptional product, but when the price jumped from $6,000 to over $60,000, it was impossible to get the funds approved internally for the upgrade.
We also paid for yearly maintenance contracts which included Professional Services, but rarely found those services beneficial. However, we did receive all software upgrades for Datapump as part of the contract which we found to be very beneficial. However, with the new pricing, that is not longer the case.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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).
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
