Datawatch Automator Server

Datawatch Automator Server is server-based data distribution, migration and integration solution which automatically creates and delivers customised data across your organisation.

Datawatch Automator Server can:

• Take data from print and report files and PDF files and turn it into live, customised information in a number of formats including Excel, without programming.
• Integrate data among enterprise applications, and populating data marts and data warehouses.
• Distributereports and export data for use in dashboards, scorecards and KPIs
• Automate the delivery of text files to document archives or content management systems
• Supply actionable information for comprehensive, strategic enterprise analytics.

Export formats includes:

• OLE DB/ODBC Data Sources (e.g. MS SQL Server, Oracle, DB2)
• Excel (xls, xlsx, xlsm)
• Access (mdb, accdb)
• PDF
• dBASE (dbf)
• Fixed length and delimited text
• HTML
• XML

Datawatch Automator Server - Features

Current features

• Data from existing reports such as PDFs and other data sources can be mined, customised and exported into live data in various formats without programming.
• Access and combines data from enterprise databases such as SQL Server, Oracle and much more.
• Deliver corporate reports in the format users want along with the original report source(s) for viewing and autditing within the same file.
• Provides ETL for data marts/warehouses including data integration between applications.
• Integrates enterprise data with Microsoft SharePoint Server (MOSS) 2007 and later without complex database programming.
• Delivers data via email, OLE DB/ODBC, network folders, RSS, FTP, SharePoint libraries and more.
• Offers high-volume data production (up to 32 CPUs), remote web administration, web services interface and tight integration with Microsoft SQL Server Integration Services.
• Monarch 11 compatibility.
  

Datawatch Automator Server - System Requirements

• Pentium 4 or better processor
• 4GB or more RAM
• 500MB hard drive space
• Additional hard drive space for temporaryfiles created during processing (dependent on the size of input filesprocessed and may be up to 8GB)

Operating System

• Windows 2003 Server SP2 or later
• Windows Server 2008
• Windows Server 2008 R2
• Windows Vista SP1
• Windows 7
• Monarch v11 Required for Model Building

Database Software

• SQL Server Standard/Enterprise 2005
• SQL Server Standard/Enterprise 2008
  
• SQL Server Standard/Enterprise 2012 or
  
• SQL Server 2008 Express SP1 (provided with Monarch DataPump)