Monarch Data Pump : Features & Benefits

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

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

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

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

DATAWATCH