Monarch [9.0 Standard Edition, Documentation Win]

Excel exporting

• Up to 5X faster exporting engine
• Export Microsoft® Office 2007 OpenXML Spreadsheets (xlsx)
• Export Summary Subtotals and Grand Totals to Excel as formulas

Windows Vista™ Ready

Analytics

• Create User-Defined functions
• Create Monarch Summary views with new data layout options
• Eight-fold capacity increase for Long Formulas
• Improved Duplicate Value Filtering

Collaboration

• Microsoft SharePoint® Collaboration
• Link to External Models
• Republish reports as PDFs with navigation trees

Database Importing

• Up to 20% faster data imports
• SQL Server 2005 native client support
• Improved data filtering-including 22 Monarch functions

Report Mining

• Define up to 22 templates in a single Monarch model
• Define up to 256 lines for your detail template
• New NOT Traps
• Enhanced PDF mining including AES-encrypted PDFs

Monarch 9 introduces a large number of features, focusing heavily on Excel. Monarch 9 Pro also includes Linked Objects, an extremely powerful way of sharing elements of model files, such as templates, filters, calculated fields and summary.

New to Monarch Pro:

• Linking Objects - Monarch 9 lets you import and link various "objects" (e.g., templates, filters, calculated fields, etc) in the local model to objects in an external model.
• PDF Improvements - You can now import data from AES-encrypted PDF files. Improvements have also been made to the PDF importing, based on customer feedback.
• Import Using OLE DB - Monarch now uses OLE DB to import (or perform external lookups) from SQL data sources, such as Access files, SQL Server, Oracle and DB2. This new engine offers increased performance versus the ODBC import capability of previous versions. You can still use ODBC to connect to your data sources as before, but moving to an OLE DB provider will bring performance benefits. You should even realize a performance benefit from your existing ODBC connections, with Monarch using OLE DB behind the scenes.
• Import OpenXML Spreadsheets - With the introduction of the new V9 Excel Export engine, you can now import the new Office 2007 OpenXML Spreadsheet format (xlsx). This new format, introduced in Office 2007, allows up to a million rows.
• Enhanced Database Filters - When you are importing or performing an external lookup to a database source (including delimited text) you now have various Monarch functions at your disposal, including many date-related functions. Note that for SQL sources, the new functions are only supported for Jet Database supported types, including Excel and Access, SQL Server, Oracle and DB2.
• Import Multiple Delimited Text Files - Similar to Monarch's functionality with multiple reports, you can now open multiple delimited text files concurrently, as long as they all use the same model.
• Import Excel Files with No Header Row - Previously, Monarch could not open Excel files which lacked a header row. There is now an option to select this, both when importing XLS and Office 2007 OpenXML XLSX files.
• Ability to force Data Types to Character - It is now possible to change the data type of an imported field to character, allowing numerics which are too large for Monarch to handle to be fully displayed and exported.
• Replace Nulls on Import - There is a new option on the Import Columns screen to force the conversion of null values to default values when importing. The default values are empty strings for character fields, zeros for numeric fields and a date of 1/1/1970 for date fields.
• Multi-Select Project Exports - It is now possible to select a list of specific project exports to run using Ctrl+click and Shift+click.

Monarch Standard
Monarch is Windows-based "Report Mining" software that easily extracts data from existing reports produced by any information system, along with easy data analysis, graphing, and exporting of data to other applications such as Excel and Access.

Monarch Professional
Monarch Pro adds the additional capability of mining data from PDF files, plus importing and combining data from virtually any corporate database, spreadsheet, desktop database, HTML files and other data sources. Monarch Pro lets you combine report data with database data; create multiple "lookups" of data, and more!

Monarch V9 Minimum Requirements

• Windows 2000 Service Pack 4, XP Home/Professional, Windows 2003 Server, Windows Vista
• 256 MB RAM
• 100 MB Disk Space for installation
• Pentium III Class CPU
• 16-Bit Color Display
• Internet Explorer 5
• .NET Framework 1.1 or higher (free from Microsoft)