Do you find yourself printing and wading through thick paper reports from ERP systems, HR/payroll systems, banking, healthcare or government information systems and then having to re-key the data into spreadsheets for analysis and reporting?
If so, Monarch Pro is the solution for you.
Features:
-
Imports Data Directly from virtually any corporate database, spreadsheets, database files, PDF files, HTML files and more
-
Extracts Data from Report Files produced on any mainframe, midrange, client/server or PC system
-
Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls) spreadsheets so you can work with your data in the format you want
-
Supports SharePoint® repositories, including access and export
-
Works with Data in Monarch Pro to sort, filter, analyze, visualize and export data to a spreadsheet, database and other application
-
Creates New Views of Data using data extracted from existing reports, combine report-based data and/or database data
-
Easily Combines up to nine different data sources in one Monarch Pro session
- Take your productivity to a new level with Monarch Pro —
- the world’s #1 Report Mining and Analysis solution!
Whether you’re a manager, analyst, accountant or auditor, you’ll find Monarch Pro easy to use. This powerful data mining tool eliminates time consuming, error-prone work by transforming existing text-based or PDF reports into live, actionable data. Quickly. Easily. And, without programming.
No IT Help Needed
Monarch Pro is business intelligence for everyone. Even non-technical users will find it easy to:
- Build a collection of filters, calculations, summaries and charts and apply them to different data sets
- Export data anytime to Excel, Access or PDF files without help from the IT department.
- Unlike other business intelligence (BI) or reporting tools, Monarch easily "mines" data from existing text-based reports - an information source typically ignored by other solutions. Monarch V9 Professional ("Monarch Pro") also enables users to mine, combine and analyze data from PDF files, database files, spreadsheets, OLE DB/ODBC sources, delimited text, and HTML files.

- Instead of printing and re-keying data from a complex Trial Balance report, or replicating the same data using a BI tool, Monarch is used to visually "mine" the data from the report without programming. Monarch then displays mined data as a live data table, for easy sorting, filtering, new calculations, etc. The data can also be summarized with subtotals, graphs, coloring, etc. Data can be exported to MS Excel, Access or other applications at any time.
- Once Monarch has mined desired data from reports, PDFs and other sources, end users can then easily analyze the data, including sorting and filtering data; creating new calculated fields; summarizing data with subtotals and grand totals and automatic graphs; and, at any time, export data to MS Excel, Access, and a wide variety of other file formats. Monarch integrates enterprise data with the MS Office environment with no programming, no need for live access to enterprise databases, and no need for IT help.

- Mine data from PDF reports, import and analyze data from XLS, MDB, DB, DBF, WKx, delimited text and HTML files, as well as any ODBC-compliant data source such as SQL Server and Oracle.
- Read and mine data from report files commonly known as print files, spool files, TXT files, formatted ASCII files, PRN files and SDF files.
- Monarch is a compelling data acquisition and analysis solution for any organization. It is actively used by organizations with limited access to core databases, including firms which have outsourced its core processing, as well as organizations with legacy information systems. Monarch is also actively used by organizations running top tier enterprise information systems such as SAP, PeopleSoft, Oracle Financials and Lawson. Organizations running such systems discover Monarch helps reduce the number of enterprise system seats needed for occasional users who are often simply running reports to find needed data.
- Monarch Pro enable easy acquisition and analysis of certain data that is virtually impossible to obtain using any other data tool.
Adapts to How You Work
Monarch Pro also adapts to how you work. You can sort and filter data, combine it with complementary data from other sources, supplement data with new calculations, and summarize or export to Excel, Access, and other applications.
Technical Professionals Benefit Too
IT professionals also benefit from Monarch Pro. Imagine fewer demands for custom database queries and report writing jobs.
Monarch Pro includes all the standard features of Monarch — the world's leading report mining and analysis tool — plus the ability to:
- Monarch turns any report into a live database.
- Monarch Pro also enables end users to work with data sourced from the following additional data sources:
- • PDF files (commonly known as "PDF Normal")
- • Data within a separate file, such as Excel, Access, delimited text (CSV) and other file formats
- • Data within an OLE DB/ODBC database source (SQL Server, Oracle, DB2, etc.)
- • HTML files, such as database-generated HTML pages displaying financial or other business data.
- Monarch V9, is available in two editions:
Supported File Types Used by Monarch as Data Sources
| File Type: | Monarch Standard | V9 Monarch Pro V9 |
|
X | X |
| PDF files | X | |
| HTML files | X | |
| dBASE DBF | X | |
| Paradox DB | X | |
| Access MDB | X | |
| Excel XLS | X | |
| Lotus WKx | X | |
| Delimited text files (CSV, etc.) | (manual Monarch work needed) |
|
|
|
X | |
|
|
X | |
| Supported File Types Exported by Monarch | ||
| File Type: | Monarch Standard V9 | Monarch Pro V9 |
| X | X | |
| HTML * | X | X |
| Excel XLS | X | X |
| Excel 2007 XLS | X | |
| Access MDB | X | X |
| dBASE DBF | X | X |
| Paradox DB | X | X |
| Lotus WKx | X | X |
| Fixed length text | X | X |
| Delimited text | X | X |
Monarch Pro Brochure | Monarch Pro v10 Datasheet


