Monarch Data Pump Version 10.5 Adds Features for Enterprise Reporting, ETL, Application Integration

New features improve data delivery, compliance, and distribution while reducing cost, time, and complexity

Note: ESJ’s editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements.

Datawatch Corporation has released Monarch Data Pump V10.5 Standard Edition, the latest upgrade to the company’s server-based data distribution, ETL (extraction, transformation, loading) and application integration solution. In addition to new data, analytic, and styling capabilities, and access to new data sources, Monarch Data Pump V10.5 includes new compliance and auditing features. Users can now use Monarch Data Pump to create and export Microsoft Office Excel 2007 spreadsheets containing a copy of the original report source of the data -- eliminating spreadsheet-induced uncertainty, reducing the audit cycle, and easing compliance. Digital Signatures can now also be added for maximum data integrity. Monarch Data Pump V10.5 is compatible with the new Windows 7 operating system.

For companies that distribute reports regularly, either internally or externally, using Monarch Data Pump V10.5 saves money on distribution costs, makes users more productive, and reduces compliance issues. Monarch Data Pump V10.5 can automatically deliver corporate reports in the format users want (Excel), along with the original report source(s) for viewing and auditing within the same Excel file, making it the perfect way to distribute reports generated from any system without programming, database work, or altering any current system output.

“Automating the process of acquiring, analyzing, and distributing high quality data to data marts or to end users in Excel can be very difficult and expensive when using traditional database-oriented tools,” said John Kitchen, senior vice president and chief marketing officer for Datawatch. “Monarch Data Pump V10.5 solves these challenges and adds new data, analytic, and styling capabilities. Monarch Data Pump V10.5 also provides new features to address the spreadsheet compliance and auditing challenges organizations face -- at a fraction of the cost, time and complexity of alternative solutions.”

New capabilities include:

  • Include the source report file(s) in XLSX/XLSM export for enhanced compliance and auditability of Excel spreadsheets
  • Embed Digital Signatures in XLSX/XLSM export for enhanced security
  • Export of data to PivotTables in XLSX/XLSM files for ready to go analysis
  • Insert document properties in XLSX/XLSM files to improve searchability, especially in SharePoint
  • Import and export Monarch Data Pump Processes
  • Compatible with Windows 7 and Windows Server 2008 R2

Monarch Data Pump provides automatic, server-based information delivery and data integration. It automatically mines and combines data from reports, PDF files, and other data sources including spreadsheets and databases with no new programming needed. It provides effortless customization of data views by providing calculated fields, data summarization, sorts, filters, and lookups. Monarch Data Pump easily uploads data to any ODBC- or OLE DB-compliant database such as SQL Server, Oracle, or DB2, or delivers the data in end-user-friendly formats such as Excel. It is very easy to set up, use and maintain.

More information is available at

Must Read Articles