Datawatch Logo
About Datawatch Europe Our products Contact Datawatch Europe Buy our software online English version Version francaise Deutsche Fassung Version espanola
Return to our home page
Events
Press enquiries
Sign up for email news
Details of our partners
Monarch software
Read our case studies
Read our White Papers
Consultancy services
Training for Monarch users
Support for Monarch users

Monarch Data Pump V9

Monarch Data Pump V9 is a "new and disruptive" BI solution which uniquely acquires, customises and delivers data primarily through Monarch Report Mining technology. Instead of relying on structured data sources, such as enterprise application production databases, which typically contain "raw" data with no business rules yet applied to them, Monarch Data Pump automatically transforms text and PDF-based reports and business documents, as well as structured data sources, into customised data, for easy delivery to the right people at the right time and in the right format, without programming.

Monarch Data Pump V9 is available in two versions, Standard and Professional:

Please view the Monarch Data Pump V9 datasheet here.

  • Monarch Data Pump Standard
  • Can be installed with up to 2 physical CPUs

  • Monarch Data Pump Professional
  • Can be installed on up to 32 physical CPUs
  • Web Services Interface
  • Web Admin Console
  • SQL Server Integration Services (SSIS) Integration
  • Remote Administration

    • Problem-Oriented Features

  • 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 of MS Office 2007 OpenXML spreadsheets (xlsx)
  • Exporting MS Excel files with AutoFilter already activated
  • User-Defined Functions
  • Linked Objects in Monarch model
  • Monitoring of network folders for automatic running of Monarch Data Pump processes upon receipt of desired reports, PDFs etc.
  • MDP9 greatly increases monitoring capability: 62 file specifications per MDP process (MDP8.5 allows 62 file specs in total)
  • Strong integration with MS SharePoint
  • Enables reading of files from SharePoint (also as in Monarch V9)
  • Simplification of SharePoint KPI generation (new MDP9 feature):
  • MDP9 will 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
  • Note, this works with xlsx files only
  • Customized data files (Excel, etc.) created by MDP can be exported into SharePoint with macro-driven file naming
  • High-volume production of data handled by MDP9 Professional
  • Up to 32 physical CPUs as noted above
  • All web-enabled administration capabilities are exclusive to MDP9 Professional
  • Web admin console uses MDP web service; works with any browser ("pure browser")
  • Enables remote administration
  • View & Run Processes
  • Cancel & Delete Jobs, View Job Logs
  • Check Server Status
  • Integration with SQL Server Information Services (SSIS) also exclusive to MDP9 Professional
  • SSIS replaces SQL Server Data Transformation Services (DTS) – Microsoft's own (very powerful) ETL tool
  • MDP9 (Professional) task will appear within SSIS "Toolbox"
  • Allows SSIS programmer to run MDP "custom tasks" within a SSIS workflow

    • For Existing MDP Customers: What's New in MDP9

    Note: This section repeats some features previously noted above.

    New Features:

  • 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
  • Exporting of MS Office 2007 OpenXML spreadsheets (xlsx)
  • User-Defined Functions
  • Linked Objects in Monarch model
  • Reading of files from SharePoint
  • Simplification of SharePoint KPI generation
  • MDP9 will 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 & folders for scheduled input
  • FTP now an accepted source of input files
  • MDP9 Professional unique features (as noted above):
  • Up to 32 physical CPUs
  • All web-enabled administration capabilities are exclusive to MDP9 Professional
  • Web admin console uses MDP web service; works with any browser ("pure browser")
  • Enables remote administration
  • View & Run Processes
  • Cancel & Delete Jobs, View Job Logs
  • Check Server Status
  • Integration with SQL Server Information Services (SSIS) also exclusive to MDP9 Professional
  • SSIS replaces SQL Server Data Transformation Services (DTS) – Microsoft's own (very powerful) ETL tool
  • MDP9 (Professional) task will appear within SSIS "Toolbox"
  • Allows SSIS programmer to run MDP "custom tasks" within a SSIS workflow

    • Major Enhancements (this is not an exhaustive list):

  • Significant increase in file monitoring capacity: 62 file specifications per process (in MDP8.5, was 62 file specs in total)
  • Several logging enhancements:
  • Enhanced job log presentation
  • Windows event log
  • OLE DB exports
  • No requirement to resolve mail addresses to Windows Address Book (WAB) for high-security installations
  • Set E-mail importance level
  • Edit title & description of exports
  • Various user interface (UI) and usability improvements

    • Both versions provide automation of all desktop Monarch V9 capabilities, including Monarch V9's Excel-based functionality, as well as many more features described further below.

    Information Made Very Easy Indeed

    © 2008 Datawatch Europe. For all enquiries please contact us.