Data Access and Transformation
Flexible tools for accessing and transforming data from multiple, disparate systems.
At the core of automation is access to data, the ability to transform it, and the infrastructure to deliver it to other applications. You simply cannot automate IT and business processes unless you bridge the gap between data and applications.
AutoMate provides the extensive set of data access, transformation, and transport tools that you need to streamline your operations. From database queries and transactions with any ODBC database, to file transfer capabilities (via FTP, SFTP, HTTP, and Windows network protocols), XML parsing and transformation, text file parsing and creation, Excel integration, and much more - AutoMate offers intuitive, drag-and-drop tools for data access and sharing.
The key to this functionality is AutoMate's visual task design system which allows IT Professionals to build tasks via drag-and-drop without writing scripts, batch files or custom programs. AutoMate provides over 200 plain-English, drag-and-drop tools called actions which enable sophisticated task development without writing a line of code.
To learn how the Health First used AutoMate to access, transform, and distribute data, read this case study.
Common Uses for AutoMate
- Application Integration
- Data Access / Transformation
- Job Scheduling
- Automated FTP Transfers
- Database Queries / Transactions
- Automated Software Testing
- Report Generation / Distribution
- File Replication and Backup
- Batch Processing
- Event Log Monitoring / Resolution
- System Monitoring / Resolution
- Scripting without Code
- Business Process Management
- GUI Automation

