Home Up Your Contact Contents

LANGUAGE SOFTWARE - PROMT Natural Language Processing Technologies
Kielikone - Translation Software -
MOT 6.0 Sanakirjasto - MOT MOBILE
Informatic - ORFO 2004 Russian and Multilingual Proofing Tools - CONTEXT DICTIONARIES
English Language Teaching - Chinese Language Teaching

Chinese, Japanese, Korean Software
- Russian Software


Hinta - Price Information Tilaustiedot  / Order Information





Data Transformation

Monarch Data Pump (MDP) V8

FeaturesWhat is new? Technical Requirements

MDP is an enterprise solution offering enterprise data ETL with automated information delivery in one solution, without programming. MDP can automatically access, transform, and publish customized data mined from reports, spreadsheets, HTML files, and other data sources in a wide variety of ways, including uploading customized data to databases such as SQL Server or Oracle; publishing Excel spreadsheets or templates, Access files, etc., for delivery via e-mail, file folder or as an RSS (Really Simple Syndication) news feed. Powerful scheduling, logging, and scripting features make MDP a powerful, highly scalable, yet easily administered solution to get the right data to the right people at the right time in the right format.

Create and Deliver Customized Enterprise Data in One Automated Solution…Without Programming

Monarch Data Pump V8 (MDP8) is a server-based information delivery and data ETL (Extraction, Transformation & Loading) solution. Unlike other data distribution systems, MDP8 automatically mines data from existing reports, PDF files, spreadsheets, databases, ODBC data sources and more, plus delivers the right information to the right person at the right time, with virtually no new programming.

Gartner Group estimates that workers spend at least 10% of their time just looking for the information they need to perform a business task or make a decision. CIO Magazine once noted the average executive wastes up to 82 minutes per day searching for needed information! MDP8 helps organizations end such wasteful, frustrating information-chasing, at a fraction of the cost and complexity of alternate solutions.

Only MDP8 can access, combine, customize and publish data mined from "unstructured" data sources, particularly existing reports and PDF files from your enterprise information systems, such as ERP systems, HR/payroll systems, and information systems designed for specific industries, such as healthcare and banking. MDP8 can also access and combine data from "structured" data sources, such as databases and spreadsheets, to fulfill your organization's ETL and enterprise information delivery needs.

With MDP8, managers and workers throughout the organization, plus partners and customers outside the organization, can all receive the actionable, customized data they need without programming and without help from the IT department. MDP8 will help your organization expedite informed decision-making, identify new business opportunities, and resolve business issues before they become big problems, at a cost and ease of implementation that no other alternative enterprise solution can touch.

MDP8 combines Datawatch's latest Monarch Report Mining/Data Mining engine with the Microsoft .NET framework to provide a highly scalable and easily administered enterprise solution to acquire, combine, and monitor customized data, and deliver that data in a wide variety of formats, on an automatic, scheduled basis.


  • Quick and easy access to data, "mined" from existing text-based reports, PDF files, and/or extracted from databases, spreadsheets and other data sources, without new programming
  • Automatic creation of highly customized data views to solve specific business needs
  • Automatic delivery of data in a variety of formats: publish Excel, Access, PDF or other files via e-mail with optional password-protected Zip compression; file folder delivery or http WebDAV; upload customized data to databases such as SQL Server or Oracle via OLE DB; publish data via RSS (Really Simple Syndication)
  • Optional export of data in valid XML format, using projects created using Datawatch's VorteXML Designer software
  • Easy scheduling of processes to run on a daily, weekly, monthly, etc. basis, in any combination, or simply set MDP8 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," such as alerts to managers and workers that select data is outside of predefined acceptable levels, etc.
  • Optional additional scripting using VB.NET for further integration with your existing IT infrastructure
  • And much more

What's New

Monarch Data Pump V8 is a Windows server-based information delivery and data ETL solution which automatically imports, transforms and delivers customized data mined from report files, databases, spreadsheets, ODBC data sources, HTML files, and now PDF files, and includes the ability to export and deliver the data in multiple formats, including natively as a PDF file.

Other new features in MDP8 include:

  • Report monitoring. MDP8 monitors file folders constantly for newly generated reports and automatically extracts, transforms, loads and distributes the required data
  • Zip compression. MDP8 can deliver, via e-mail, customized data as a compressed Zip file, with optional password protection
  • Robust alerting. Should a MDP8 process fail, adminstrators not only receive an alert, but also the job log, for faster trouble-shooting
  • Password management for .NET scripts. For enterprises applying customized .NET scripts to MDP8 processes, individual passwords are stored securely
  • Improved OLE DB functionality; and
  • New XML transformation module. This optional module allows users to automate processing of reports and other business documents into valid XML, using projects created by Datawatch's VorteXML Designer software.

Technical Requirements


  • Pentium 3 Processor (Pentium 4 recommended)
  • 256 MB RAM


  • Win 2000 SP4, Windows XP SP1, or Windows 2003 Server
  • .NET Framework V1.1+ (free download from Microsoft)
  • Monarch Pro 8.0+ (included)
  • IIS 5.0+ (for Web Service and Remote Administration)

Monarch Data Pump V8 Data Export Formats

  • OLE DB/ODBC Data Sources (e.g. MS SQL Server, Oracle, DB2)
  • Excel 2.1, 3.0, 4.0, 5.0 and 8.0 (xls)
  • Access 1.0, 1.1, 2.0, 3.0, 4.0 (mdb)
  • PDF
  • dBASE III, IV, and 5.0 (dbf)
  • Paradox 3.x, 4.x, 5.x and 7.x (db)
  • Lotus 1-2-3 Release 1 (wks), Release 2 (wk1), Release 3 (wk3)
  • Fixed length and delimited text
  • HTML*
  • XML-SS*
  • Monarch Portable Report File (PRF)

* requires Office XP or freely available Office XP web components



Home ] Up ]

Send mail to Mari.Haapaniemi@trantor.fi with questions or comments about this web site.
Copyright © 2002 Trantor Ky
Last modified: 11/10/06