Features:

• Quick and easy data mining of existing text-based reports, PDF files, and/or databases, spreadsheets and other data sources, without new programming
• Variety of data export formats: Excel, Access, PDF and more
• Create, update, append and/or overwrite databases: SQL Server, Oracle and DB2 via OLE DB
• Automatic customized data views
• Email delivery of data with optional password protection and Zip compression
• Allows inclusion of source report files in an XLSX/XLSM export so users can easily jump from the spreadsheet to the source data for purposes of compliance, auditing, reconciliation and accuracy
• Allows for adding Digital Signatures in XLSX/XLSM exports for enhanced security
• Files copied to 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. Or, set Monarch Data Pump to run a process immediately upon receipt of incoming reports, PDF files or other data files
• Robust job logging and simple administration, including Web Service and remote administration
• Delivery of "alerts" to managers and workers noting that select data is outside 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

Features for use with Microsoft SharePoint:

• Offers easy, programming-free way to integrate output from legacy systems with SharePoint
• Transforms reports or data extracts from any system into Excel, Access, etc., and delivers them to SharePoint for distribution and/or access
• Creates OpenXML spreadsheets (xlsx) to allow web rendering and other features under Excel Services
• Summarizes data for easy definition of SharePoint KPIs
• Supports authentication, copying, deleting, folder creation, version control, check-out respected

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
• Table verification
• 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