• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • HelpSystems Bolsters Automation Tool with Database Triggers

    November 4, 2014 Alex Woodie

    Organizations that use HelpSystems’ business process workflow software, dubbed AutoMate, last week gained the capability to incorporate database triggers into their integration scripts. The software, which can integrate with IBM i resources, also got a new GUI.

    AutoMate and AutoMate BPA Server are Windows-based workflow scripting products that HelpSystems obtained earlier this year with its acquisition of Network Automation Inc. (NAI). The Los Angeles-based company had been selling the AutoMate line of products for 10 years.

    With the version 10 releases of AutoMate and AutoMate BPA Server, HelpSystems delivered a new database trigger function that enables users to initiate functions when certain actions are performed on the database, such as updates, deletes, or triggers. Currently, the company is only supporting SQL Server and Oracle databases.

    Database triggers are not supported on DB2. AutoMate is able to integrate with IBM i and z/OS applications and incorporate those platforms into scripted workflows, but not through the database. Instead, it can work with these platforms through available APIs, FTP file transfers, and through 5250 and 3270 emulation.

    The new GUI in AutoMate should make it easier to build integration scripts. The product offers a library of more than 600 pre-built actions, and the new GUI brings shortcuts that present the user with the most frequently used tasks in the Task Builder.

    New actions in AutoMate v10 offer the capability to manipulate images and PDFs without any third-party tools, including rotating, resizing, cropping, converting, and filtering any quantity or size of images automatically. The PDF action allows users to create, sign, stamp, encrypt, decrypt, extract, search, and replace PDF files.

    Version 10 also introduces support for Java applications, including the capability to manipulate images and PDFs without any third-party tools; support for Microsoft Windows PowerShell environment; support for Amazon‘s DynamoDB and Simple Email Service (SES); and support for Facebook.

    Meanwhile, the BPA Server version of AutoMate, which is used for automating multi-machine environments, has also been bolstered with the addition of the Workflow Wizard, a new global search function in the management console, and the capability to restart a workflow from a specific point in the process upon failure.

    HelpSystems sells its AutoMate products through its AutoMate subsidiary. For more info see www.networkautomation.com.

    RELATED STORY

    HelpSystems Launches Mobile Initiatives, Acquires NAI for Workflow Automation



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    DRV Tech

    Get More Out of Your IBM i

    With soaring costs, operational data is more critical than ever. IBM shops need faster, easier ways to distribute IBM applications-based data to users more efficiently, no matter where they are.

    The Problem:

    For Users, IBM Data Can Be Difficult to Get To

    IBM Applications generate reports as spooled files, originally designed to be printed. Often those reports are packed together with so much data it makes them difficult to read. Add to that hardcopy is a pain to distribute. User-friendly formats like Excel and PDF are better, offering sorting, searching, and easy portability but getting IBM reports into these formats can be tricky without the right tools.

    The Solution:

    IBM i Reports can easily be converted to easy to read and share formats like Excel and PDF and Delivered by Email

    Converting IBM i, iSeries, and AS400 reports into Excel and PDF is now a lot easier with SpoolFlex software by DRV Tech.  If you or your users are still doing this manually, think how much time is wasted dragging and reformatting to make a report readable. How much time would be saved if they were automatically formatted correctly and delivered to one or multiple recipients.

    SpoolFlex converts spooled files to Excel and PDF, automatically emailing them, and saving copies to network shared folders. SpoolFlex converts complex reports to Excel, removing unwanted headers, splitting large reports out for individual recipients, and delivering to users whether they are at the office or working from home.

    Watch our 2-minute video and see DRV’s powerful SpoolFlex software can solve your file conversion challenges.

    Watch Video

    DRV Tech

    www.drvtech.com

    866.378.3366

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    NGS:  FREE, Live Webinar: Reporting & Analytics on IBM i for Manufacturers & Distributors. Nov 18
    MiNET:  Automate PDF, email, Fax, Archiving & more with ArtForm400. Try us for a FREE Redbox code!
    Four Hundred Monitor Calendar:  Latest info on national conferences, local events, & Webinars

    More IT Jungle Resources:

    System i PTF Guide: Weekly PTF Updates
    IBM i Events Calendar: National Conferences, Local Events, and Webinars
    Breaking News: News Hot Off The Press
    TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

    Green Screen Replacement Beats The Clock First Pass On Power8 Enterprise Performance

    Leave a Reply Cancel reply

Volume 14, Number 21 -- November 4, 2014
THIS ISSUE SPONSORED BY:

Profound Logic Software
Maxava
Manta Technologies
Linoma Software
Fresche Legacy

Table of Contents

  • Vision Gets Serious About Hosted HA with MIMIX 8
  • HelpSystems Bolsters Automation Tool with Database Triggers
  • Inventory Forecasting Software Lives in the Cloud
  • HarrisData Supports Linux with new ‘AppsInHD’ Platform
  • Zend Delivers Mobile App Enhancements to PHP Developers
  • Storwize Gets Faster Pipes, Encryption at Rest
  • Attachmate Emulators Run Natively on iOS and Android
  • Halcyon Tackles IBM i Security with New Products
  • Homebuilder Repels the Tape Monkey with Crossroads VTL
  • ARCAD Software Takes On Database Modernization

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • The Power11 Transistor Count Discrepancies Explained – Sort Of
  • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
  • Big Blue Delivers IBM i Customer Requests In ACS Update
  • New DbToo SDK Hooks RPG And Db2 For i To External Services
  • IBM i PTF Guide, Volume 27, Number 33
  • Tool Aims To Streamline Git Integration For Old School IBM i Devs
  • IBM To Add Full System Replication And FlashCopy To PowerHA
  • Guru: Decoding Base64 ASCII
  • The Price Tweaking Continues For Power Systems
  • IBM i PTF Guide, Volume 27, Numbers 31 And 32

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle