Products > Business Intelligence Products : Monarch Data Pump Pro > Features & Benefits
Monarch Data Pump Pro: Features & Benefits
Pro Features:
- Ability to install up to 32 physical CPUs for significantly higher volume of data production (Monarch Data Pump Standard can be installed with up to 2 physical CPUs)
- Powerful remote administration over the network using the familiar Microsoft Management Console interface
- Remotely view and run processes, cancel and delete jobs, view job logs, check server status and more
- Ability to use web-enabled Monarch Data Pump administration with any browser
- Web Services interface to allow for seamless movement to and from other applications and even other platforms
- Offers tight integration with SQL Server 2005 Information Services (SSIS), so that Monarch Data Pump Pro custom tasks will appear in the SSIS Toolbox, enabling SSIS programmers to execute Monarch Data Pump processes via its web service. Users will also receive status updates and success/failure events within the familiar SSIS workflow
Pro and Standard Features:
- Quick and easy data mining of existing text-based reports, PDF files, and/or databases, spreadsheets and other data sources, without needing new programming
- Automatic customized data views
- Exports data in various formats: Excel, Access, PDF and more
- Delivers data via email with optional password protection and Zip compression
- Copies files to MS SharePoint libraries and other WebDAV-enabled repositories
- Copies files to network folders
- Creates, updates, appends and/or overwrites databases such as SQL Server, Oracle and DB2 via OLE DB
- Publishes data via RSS (Really Simple Syndication) data feeds
- Provides easy scheduling of processes that run on a daily, weekly, monthly, or yearly basis, in any combination. You can also simply 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
- Delivers email alerts to managers and workers announcing that select data is outside of predefined acceptable levels
- Offers optional additional scripting using VB.NET for further integration with existing IT infrastructure
- Provides optional data exporting in valid XML format, using projects created with Datawatch's VorteXML Designer software
Features for use with Microsoft SharePoint:
- Offers easy, programming-free features 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, and check-in
New to Monarch Data Pump Pro 10.5:
-
Automated, programming-free support of all desktop Monarch V10 and V10.5 Report Mining functionality, notably:
- Ability to include the source report file(s) in XLSX/XLSM export for enhanced compliance and auditability of Excel spreadsheets
- Ability to embed Digital Signatures for enhanced security
- Import of XPS files
- Import and export of XLSM files
- Import and export of ACCDB files
- Export of data to Pivot Tables in XLSX/XLSM files
- Export of summary data based on a key value change
- Expanded Date Macros include all Monarch V10 Time Interval Macros
- Table verification
- Export and Import Processes
- Allows for easy movement of Processes between different Monarch Data Pump servers, the ability to duplicate Processes quickly or export them for archival purposes
- Insert Document Properties in XLSX/XLSM files
- Enhances the searchability of these file types, as well as improves organization, auditing and tracking-especially useful in a SharePoint / Excel Services environment, where properties can be used as custom index fields
- New "Open with Monarch" option when editing project lists
- Makes it easier to check out a project in Monarch and make any model changes.
- Zip Compression when moving and copying input files
- Allows Distribution Processes to attach only one file per e-mail
- Delivers the capability to unbundle attachments, providing flexibility in cases where e-mail systems or policies set limits on the total attachment size
- Compatible with Windows 7