Monarch Data Pump

1
Monarch Data Pump
Brief Overview
Monarch Version 9 Launch Event 15 March 2007 Adam
Street, London

• Gareth Horton
• Product Manager
• Datawatch

2
ETL Solution using Monarch engine

• Create and Manage Processes
• Schedule Monitor
• .NET API / Web Service
• VB.Net Scripting
• Alerts
• Distributions
• OLE DB Export
• Extensive Logging

3
Architecture

• .NET Framework
• C, C
• SQL Server 2000/2005
• Microsoft Management Console
• IIS

4
Distributions

• Global
• Useful for Inbox/Outbox style approach
• c\accounts gets distributed to accounts group
• Export level
• More granular
• Each export can be distributed precisely

5
Distributions

• RSS Pull Distribution
• E-Mail Push Distribution
• NT Event Log Logging and Integration
• Copy Network, FTP, SharePoint, WebDAV
• Move Network, FTP, SharePoint, WebDAV
• Delete

6
Scripting

• Supports VB.NET
• Full .NET framework functionality available
• Internal API with full documentation

7
Scripting

• Script Editor includes wizards for common uses
• Run command lines
• Add distributions dynamically
• Create alert triggers
• Add events to the JobLog
• Call external processes to get files

8
Logging

• Job Log
• XML file
• Recipe as well as Log
• Of potential use for auditing/ Sarbanes-Oxley/Base
  l II purposes
• Automated clean up of job logs
• Add more user-defined entries using script
• Query Logs with script or XPath

9
Alerts

• Basic Predefined Alerts
• Script Generated Alerts
• RSS/E-Mail/NT Event Log
• System Alerts failover to Event Log

10
Scheduling

• Windows Task Scheduler
• Folder Monitoring

11
Integration

• VB.Net Script
• Web Service
• XPath
• .NET API
• Command Lines

12
Questions

• gareth_horton_at_datawatch.com