Monarch Data Pump Pro: Features & Benefits

Ability to install up to 32 physical CPUs for significantly higher volume of data production (Monarch Data Pump Standard can be installed with up to 2 physical CPUs)
Powerful remote administration over the network using the familiar Microsoft Management Console interface
Remotely view and run processes, cancel and delete jobs, view job logs, check server status and more
Ability to use web-enabled Monarch Data Pump administration with any browser
Web Services interface to allow for seamless movement to and from other applications and even other platforms
Offers tight integration with SQL Server 2005 Information Services (SSIS), so that Monarch Data Pump Pro custom tasks will appear in the SSIS Toolbox, enabling SSIS programmers to execute Monarch Data Pump processes via its web service. Users will also receive status updates and success/failure events within the familiar SSIS workflow

Quick and easy data mining of existing text-based reports, PDF files, and/or databases, spreadsheets and other data sources, without needing new programming
Automatic customized data views
Exports data in various formats: Excel, Access, PDF and more
Delivers data via email with optional password protection and Zip compression
Copies files to MS SharePoint libraries and other WebDAV-enabled repositories
Copies files to network folders
Creates, updates, appends and/or overwrites databases such as SQL Server, Oracle and DB2 via OLE DB
Publishes data via RSS (Really Simple Syndication) data feeds
Provides easy scheduling of processes that run on a daily, weekly, monthly, or yearly basis, in any combination. You can also simply 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
Delivers email alerts to managers and workers announcing that select data is outside of predefined acceptable levels
Offers optional additional scripting using VB.NET for further integration with existing IT infrastructure
Provides optional data exporting in valid XML format, using projects created with Datawatch's VorteXML Designer software

Offers easy, programming-free features 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, and check-in

Automated, programming-free support of all desktop Monarch V9 Report Mining functionality to:
- Export summary data to Excel with subtotals and grand totals as live Excel formulas and optional Excel outlining
- Export data to Excel with AutoFilter already activated
- Export data in Office 2007 OpenXML spreadsheet format (xlsx)
- Create user-defined functions
- Link objects in Monarch model
Read files from SharePoint libraries and export customized data back
Integrate with Microsoft Office SharePoint Server (MOSS) 2007 to easily create SharePoint KPIs and to:
- Export to OpenXML spreadsheet format (xlsx), Monarch Data Pump V9 to 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
Leverage FTP as an accepted source of input files
Significantly increase file monitoring capacity to 62 file specifications per process (MDP8.5 allows 62 file specs in total)
Use MDP logging enhancements for:
- XML job log presentation with new stylesheet
- Windows event log
- OLE DB exports
No requirement to resolve mail addresses to Windows Address Book (WAB) for high-security installations
Set email importance level
Edit title and description of exports
Leverage various user interface (UI) and usability improvements

DATAWATCH