Powerful Data Extraction Tool

Pros

It is extremely powerful to extract data out of PDF files. The automator product works great to automate data extraction processes

Cons

We had a few issues with the installation and upgrade process. The installation instructions could be a little bit more detailed.

Monarch is integral to our day-to-day activity

I've been using Monarch for over seven years and I continue to find ways to use it to make my job easier. We use Monarch daily to quickly produce the information we need.

Pros

I love the way that Monarch can flexibly capture huge amounts of data from various levels of a source file, allowing you to then present that information with formulas, filters and summaries. Monarch projects can also be seamlessly paired with Altair's Automator to produce the reports/data summaries automatically and distribute the files produced via e-mail to variable recipients. The customer service group is top notch (knowledgeable and pleasant)!

Cons

We've had problems working with 17M record ODBC sources, but most anything would. However, that issue may be more due our outdated (7 years behind current) ODBC version than Monarch. Otherwise, my only other complaint is that I didn't start using this software earlier in life!

Just the tool needed

its a huge time saver

Pros

It saves SO much time on a lot of tasks that would normally take way more time to complete and does it pretty effectively.

Cons

There is a learning curve before you can use the product efficiently. Took some of our users a few months to get proficient.

Monarch Complete turned a 5 year long project into a quarterly process.

See my review...

Pros

It's so versatile. I use it to normalize data exported from various sources so that I can make apples to apples comparisons for reconciliation and identification. It's a tremendous help to me. My description above is speaking to the fact that my first use of Monarch Complete was to develop a process to create a data table of custodian cost basis data concatenating data from 20 separate proprietary text files into a single table so that I could compare it to the same data from our portfolio accounting system - to reconcile cost basis or our clients' eligible investment accounts. Incorporating Monarch Complete into my process, I reduced a manual process that took over 2 hours to complete down to about 10 minutes - and then I was able to use Excel to reconcile the cost basis and determine all out of balance issues and report them for resolution - thereby concluding my cost basis project. During the development stage in Monarch, I saved workspaces related to this process, which allows me to then duplicate the process, I just have to change the source file name and it's done.

Cons

Mistakes are not always reversible, as I have found out and I have spent countless hours learning this lesson. When you cannot recover from a mistake, you are forced to close the workspace without saving, so all changes you made since your last save are lost and you have to start over. Basically, if you are not very technically oriented, you may find it difficult to begin working with. But that's mostly a learning curve and thankfully Datawatch has a large community of users that can assist and their support staff are very knowledgeable as well.

Great and powerful!

Benefits include time savings and automating tasks. Since Monarch can read and comprehend, it makes it the ideal software for automating bills, receipts, databases or even any type of data analysis/action items you may have. Be careful setting it up, but once you get your captures just right, the program can amaze. Speedy and reliable!

Pros

Easy to use, powerful, options galore and there is a great help file! This program is excellent for automating mundane tasks and this software is able to read/understand data with precision. Program allows you to read files, excel, csv, etc and able to identify text, numbers and other characters. Want the program to look for a text specific field? No problem! Monarch lets you identify the type and length of expected lines/fields so you can automate with ease. Great for macro running!

Cons

Program only has a few minor negatives, such as size/resources. Otherwise, the program is pretty reliable. Sometimes you have to get a bit creative with the captures of data or try a few tricks such as looking for specific text/fields, but I find overall the program does the job well. There are a lot of variables with documents/spreadsheets so this program will help but you will need some patience :)

The Tool That Helps Me Looking Good

As I mentioned before Monarch helps me to say "yes" to every request (almost) I receive regarding reporting. After 16 years of using it I can say that I am still learning new things by practicing and using it. My wish is that Altair/Datawatch will revisit/reorganize their training and support departments in order for us to get the services we want and deserve. Please create/provide more advance training similar to the one on July 25, 2019 in Boston.

Pros

The flexibility we have to access different files at the same time and produce a customized output.

Cons

The support and the "following up" after selling it. I am a "champion member" an I have been using Monarch for 16 years. I honestly believe that the app does not get the proper attention from Altair/Datawatch. Sorry to say this.

Monarch Review - AMR

Altair Monarch is a great product. It is feature rich and automatable. The support team is very responsive and the user base is very loyal and communicative in Altair Monarch community blog

Pros

1. Single PC User version as well as Server-based multi user version availability 2. Automation capabilities 3. Deep compabatability with Microsoft Excel and VBA 4. Can access and analyze many data sources

Cons

1. Cannot Automate Data Prep Studio activities in Single PC User version 2. Rather expensive for single user version, with annual renewal subscription

Time saver

Pros

I use Monarch on a daily basis. This software is a huge help for those who works with lots of data information stored in different formats that needs to be cleaned and re-formatted to tables. Saves a lot of time for me. My favorite function - sort and clean all extra noise from the original files that requires formatting.

Cons

I'm comfortable with the way it works, did not find any issues.

I have a product that is fun and easy to use. I can get quick answers to important questions!

Pros

I can quickly join different types of data together. I am able to reproduce the data structure I want every day. I can create it and then reproduce the results on the fly. Support for the product is awesome!

Cons

Training is mostly eLearning through WebEx's and YouTube. Would like to have more in class training offered. Training needs to be more than one day.

Powerful, Easy to Learn and Use

Increased efficiencies and greater flexibility with data.

Pros

The ability to easily extract data and it also has many spreadsheet and database functionalities. Works very well with Excel and Access. Fantastic at extracting data from PDF files.

Cons

Expensive, some processes could be streamlined or be made more user friendly, some performance issues.

Altair Monarch

Pros

The ability to process complex documents (PDF, Mainframe reports, Excel, XML, JSON) without writing code. The key is to understand few concepts, the rest is practice.

Cons

No built-in change management for the Automator part of the software. You have to export jobs to save versions.

Monarch has been invaluable with extracting data from our mortgage servicing reports

easy data extraction into excel, text, and pdf formats

Pros

Ease of use. When I first started, I was able to teach myself how Monarch worked and easily able to get answers for my one off questions through their discussion boards.

Cons

More knowledge around the mortgage industry reporting and how the data is presented and needs to be extracted. I had to find another user in our industry to get a lot of help with the reports.

Altair Monarch - Game changing data preparation software

Pros

The ease of use of Monarch is amazing. Drag and drop data sets right into the software and you're off. Even if you've never used the product before, basic usage is very intuitive.

Cons

As with any software product, there is always room for improvement. Occasionally you will run into limitations with formatting or presentations. However, they do an excellent job of listening to the needs of their customers and each update often answers many of issues you struggle with.

Good Value

We were able to recoup our expenses from purchasing the system with the very first use case that we found. We took unstructured text from a .txt file and converted it to Excel, with quite a bit of manipulation being done from that point. Saved a ton of time, with great customer support helping out along the way.

Pros

Reasonably priced for the variety of capabilities that you get with the software.

Cons

Has a learning curve, but great training and support to make that easier.

Monarch is powerful and is the best value for our needs

We primarily use it for extracting data from PDF's so we can import it into SQL.

Pros

It is the only product we have found in this price range that meets our need for PDF extraction. I am learning the REG EXP functions and they are very powerful.

Cons

No real drawbacks, but PDF's can be a real problem and on rare occasions I have to do extra paring in SQL.