• Contents
  • Index

Altair® Monarch® Server

 

About Monarch Server Automation Edition

Automator is a data conversion solution that uses existing ASCII or ANSI reports, PDF files, XPS files, ISAM files (for example, XLS, MDB, ACCDB, DBF), Open XML Spreadsheets (XLSX/XLSM), HTML files, and OLE DB/ODBC sources as data sources. You can input report files (for example, TXT, DAT, PRN, LOG) into Automator and then export their data to a variety of formats (for example, PDF, XLS, XLSX/XLSM, MDB, ACCDB, HTML, DBF) or to an OLE DB or ODBC destination. Automator also allows you to export files to a Microsoft Office SharePoint Server, FTP site, email destination, or distribution list. In short, Automator lets you extract, transform, move, and load data faster and more easily than previously possible.

Automator offers far more than an easy way to automate Monarch Complete: it is an information delivery system capable of distributing files over the network and to SharePoint locations, emailing users the files they need, or alerting them about new files and where to get them, that is, either over the network or via the Internet. RSS feeds can be created and integrated with newsreaders or corporate information portals so that users are kept up-to-date on the latest information and can click to download or view the information via their browser.

Automator is a perfect solution for extracting data from periodic reports on a regular basis. For example, you might instruct Automator to process files delivered to a specified location on your network at 3:00AM, delivering Excel files to all sales reps so that they have the latest figures in their inbox first thing in the morning.

Alternatively, you can use Automator to monitor specified folders so that as soon as a file arrives, the conversion process begins.

Automator is also great for automating complex conversion projects that call for extracting data from multiple reports, generating output for multiple recipients, or for taking multiple passes through a complex report in order to assemble the data you need.

Features and Functions

Automator has the following capabilities:

  • Automated conversion of data from TXT, PDF, ISAM, XPS, and OLE DB/ODBC sources to an ISAM or OLE DB/ODBC (for example, SQL Server and Oracle) target by scheduled or event-driven execution via monitored folders

  • Email distribution of PDF, ISAM, and Open XML Spreadsheets

  • File system and SharePoint distribution of input and export files

  • RSS publication

  • Creation of logs and alerts resulting from operations

  • User creation of pre-processes and post-processes using VB.NET Scripting

  • Scheduled administration of job logs and database entries