Products > Business Intelligence Products : Monarch Data Pump > Features & Benefits

productshot

Monarch Data Pump : Features & Benefits

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

Contact Us

North America

Europe, Mideast & Africa

Central & South America

PacRim