Deliver Customized Data Without Programming

Monarch Data Pump Pro automatically creates and delivers customized data extracted from reports and other valuable but difficult-to-use data sources across your organization at a fraction of the cost and time of alternative solutions.

Monarch Data Pump Pro is a server-based data distribution, integration and application integration solution. It automatically accesses and transforms unstructured data sources, such as report files and PDF files, into live, customized data in various formats, including Excel.

No Programming Needed

This high-volume data production solution also allows you to access and join information from structured data sources, including databases and spreadsheets, to give you enterprise-wide access to customized data — with no programming needed.

Extract Data from Your Most Valuable Information Asset: Reports

Enterprise information systems (i.e., ERP systems, HR/payroll systems) and third party data processing firms create extensive report libraries. Plus you most likely have spent a lot of time and money creating your own custom reports from these systems. Monarch Data Pump provides the tools to leverage this valuable but woefully underused asset by extracting the very high quality data that resides in your existing reports and PDF files for customizable data sets—complete with automatic data verification.

Monarch Data Pump Can Deliver Data As:

• Excel spreadsheets sent via email or RSS feeds
• As data that will automatically create, update, append and/or overwrite databases
• Text files sent to a document archive, and more
• Part of a SQL Server 2005 Information Services (SSIS) process

Report & Excel Distribution Made Easy — And Compliant Too!

For companies that distribute reports on a regular basis, either internally and/or externally, using Monarch Data Pump saves money on distribution costs, makes users more productive and reduces compliance issues. Monarch Data Pump 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—without programming, database work or altering any current system output. Digital Signatures can be added for maximum data integrity.

Easy Administration

Administration for Monarch Data Pump Pro is straightforward and based on the familiar Microsoft Management Console interface. Users can do administration remotely over the network or use the web-enabled administrator to remotely view and run processes, cancel and delete jobs, view job logs, check server status and more through a browser.

A web service interface is also included for seamless integration with other applications and processes as needed.

Adds Value to Microsoft SharePoint

Monarch Data Pump offers an easy, programming-free way to integrate output from legacy systems with SharePoint. It can transform reports or data extracts from any system into Excel, Access, etc., and deliver them to SharePoint for distribution and/or access. Monarch Data Pump can also automatically populate the KPI reporting capabilities within SharePoint Server.

Datawatch leverages your existing reporting investments to solve your business analytic needs. Efficiently. Seamlessly. Cost-Effectively.

What's New Datasheet

Features & Benefits

• Quick and easy data mining of existing text-based reports, PDF files, and/or databases, spreadsheets and more
• 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
• Allows inclusion of source report files in an XLSX/XLSM export

Technology and System Requirements

• Pentium 4
• 512 MB RAM
• Win 2000 SP4, Windows XP SP1, Windows Vista or Windows 2003 Server