Deliver Customized Data and Business Intelligence Without Programming

Monarch Data Pump automatically creates and delivers customized data across your organization at a fraction of the cost and time of alternative solutions.

Monarch Data Pump is a server-based data distribution, ETL (Extraction, Transformation, Loading) 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 business intelligence solution also works with structured data sources, including databases and spreadsheets, to give you enterprise-wide access to customized data — with no programming needed.

Data Mining Tools to Extract Data

Enterprise information systems (i.e., ERP systems, HR/payroll systems) and third party data processing firms create extensive report libraries. Monarch Data Pump provides the data mining tools to extract data from 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

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.

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 systems and applications to turn static reports, statements and document data into actionable information. Efficiently. Seamlessly. Cost-Effectively.

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 & System Requirements

• Pentium 4 single core or better processor
• 2 GB or more RAM
• 250 MB hard drive space