Deliver Customized Data and Business Intelligence without Programming
Monarch Data Pump automatically creates and delivers customised data across your organisation at a fraction of the cost and time of alternative solutions. And it delivers the data when you need it and how you need it.
Unlike other reporting tools, Monarch Data Pump is a serverbased enterprise report mining and data ETL (Extraction, Transformation, Loading) solution. It automatically transforms unstructured data sources, such as report files and PDF files, into live, customized data in various formats, including Excel.
New to Monarch Data Pump V10.5:
Automated, programming-free support of all desktop Monarch V10 and V10.5 Report Mining functionality, notably:
- Ability to include the source report file(s) in XLSX/XLSM export for enhanced compliance and auditability of Excel spreadsheets
- Ability to embed Digital Signatures for enhanced security
- Import of XPS files
- Import and export of XLSM files
- Import and export of ACCDB files
- Export of data to Pivot Tables in XLSX/XLSM files
- Export of summary data based on a key value change
Expanded Date Macros include all Monarch V10 Time Interval Macros
Export and Import Processes
- Allows for easy movement of Processes between different Monarch Data Pump servers, the ability to duplicate Processes quickly or export them for archival purposes
Insert Document Properties in XLSX/XLSM files
- Enhances the searchability of these file types, as well as improves organization, auditing and tracking-especially useful in a SharePoint / Excel Services environment, where properties can be used as custom index fields
New "Open with Monarch" option when editing project lists
- Makes it easier to check out a project in Monarch and make any model changes.
Zip Compression when moving and copying input files
Allows Distribution Processes to attach only one file per e-mail
- Delivers the capability to unbundle attachments, providing flexibility in cases where e-mail systems or policies set limits on the total attachment size
Compatible with Windows 7
Monarch Data Pump Can Deliver Data As
- Excel spreadsheets sent via email or RSS feeds
- As data that will automatically create, update, append and/or overwrite databases
- Text files sent to a document archive, and more
Adds Value to Microsoft SharePoint Monarch Data Pump offers an easy, programming-free way to integrate output from legacy systems with MS SharePoint.
Monarch Data Pump Can:
- Transform reports or data extracts from any system into Excel, Access, etc., and deliver them to SharePoint for distribution and/or access
- Automatically export data in Open XML Spreadsheet (xlsx) format, to easily facilitate, in conjunction with Excel Services, web-enabled KPI reporting capabilities within Microsoft Office SharePoint Server 2007
Additional Features:
Create, update, append and/or overwrite databases: SQL Server, Oracle and DB2 via OLE DB
Email delivery of data with optional password protection and Zip compression.
Files copied to MS SharePoint libraries and other WebDAV enabled repositories.
Files copied to network folders
Ability to publish data via RSS (Really Simple Syndication) data feeds
Easy scheduling of processes to run on a daily, weekly, monthly, or yearly basis, in any combination.
Delivery of “alerts”, to managers and workers noting that select data is out side of predefined acceptable levels
Optional additional scripting using VB.NET for further integration with existing IT infrastructure.
Optional data exporting in valid XML format, using projects created with Datawatch’s VorteXML Designer software
