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.
  • 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. 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 Microsoft Office SharePoint KPIs
  • Supports authentication, copying, deleting, folder creation, version control, check-out respected

New to Monarch Data Pump V9:

  • Automated, programming-free support of all desktop Monarch V9 Report Mining functionality, notably:
    • Exporting of summary data to Excel with subtotals and grand totals as live Excel formulas and optional Excel outlining
    • Exporting data to Excel with AutoFilter already activated
    • Exporting data in Office 2007 OpenXML spreadsheet format (xlsx)
    • User-Defined Functions
    • Linked Objects in Monarch model
  • Ability to read files from SharePoint libraries and export customized data back
  • New integration with Microsoft Office SharePoint Server (MOSS) 2007 enables easy creation of SharePoint KPIs:
    • When exporting to OpenXML Spreadsheet format (xlsx), Monarch Data Pump V9 will automatically create a macro-driven named range for each measure appearing in the last row of a summary
    • These named ranges can then be consumed by SharePoint to define SharePoint KPIs.
  • Use macro-generated files and folders for scheduled input
  • Acceptance of FTP source of input files
  • Significant increase in file monitoring capacity: 62 file specifications per process (MDP8.5 allows 62 file specs in total)
  • MDP logging enhancements made to:
    • XML job log presentation with new style sheet
    • Windows event log
    • OLE DB exports
  • No requirement to resolve mail addresses to Windows Address Book (WAB) for high-security installations
  • Ability to set email importance level
  • Edit title and description of exports
  • Various user interface (UI) and usability improvements

New to Monarch Data Pump V9 Professional:

  • Installation up to 32 physical CPUs for significantly higher volume of data production (MDP Standard can be installed with up to 2 physical CPUs)
  • Powerful remote administration over the network using the familiar Microsoft Management Console interface
  • Web-enabled Monarch Data Pump administration using any browser, to remotely view and run processes; cancel and delete jobs, view job logs, check server status and more
  • Web service interface for more seamless integration with other applications and platforms
  • Tight integration with SQL Server 2005 Information Services (SSIS). Enables SSIS programmers to execute Monarch Data Pump processes via its web service and get status updates and success/failure events within familiar SSIS workflow

Contact Us

North America

Europe, Mideast & Africa

Central & South America

PacRim