Altair Monarch vs. AWS Glue

* 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

When the data which requires ETL has different formats, schema, and volume, this service suits them best. So, when the volume is not consistent (typical use-case of healthcare and online shopping), AWS Glue can be the prime choice. When the data is available in both batch and streaming mode, the developer needs to generate a separate codebase. This increases the source code management efforts. So, prefer to go with Glue when the nature of the data is the same (either batched or streamed).

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

• After data cleansing, the team also implemented the best practices for using AWS platform services as a Data Lake, such as job bookmarking for AWS Glue jobs, proper delimiter for the AWS Glue crawlers, partitioning in AWS S3, and transformation to parquet file for compression and faster querying time in Amazon Athena.
• Data modernization through combining data from multiple sources into a functioning datasets, rebuilding DW, and resctructuring data sources.
• Aims to lessen customer complaints, eliminate manual data extraction requests via SR from different data sources, and Increase accuracy, consistency and speed up reconciliation process.

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

• It’s integration with other cloud vendors is bit difficult
• If it can support non SQL based databases as well, it would be powerful.
• Real time data synchronisation in data source is missing

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 personally found it very usable for a data engineer's day job, particularly for performing ETL and managing the data pipelines.

Incentivized

Amazon responds in good time once the ticket has been generated but needs to generate tickets frequent because very few sample codes are available, and it's not cover all the scenarios.

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

The cataloging of data objects is the best in the case of AWS Glue. We use AWS Glue in all of our data pipelines to sync external and internal data sources and to automatically produce SQL-based ETL based on AWS Glue catalog objects. Integration with Amazon products is the other advantage.

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

• Positive Impact :- after ETL we can able to do some kind of automation
• Negative :- At some point of time it can hamper the cost but not really

Incentivized