Tasks

GoAnywhere Director includes over 60 built-in tasks for performing a wide variety of business processes. This includes tasks to retrieve and distribute files, transform data, encrypt/decrypt files, compress/decompress files and interact with databases. Other tasks can be used to call native commands, execute programs, send emails, search and replace file contents and more.

You can also build your own custom tasks to use within Projects. This is especially helpful if you need to perform special processing or connect to ERP systems and other applications using proprietary interfaces.

Multiple tasks can be "chained" together within a Project to perform a series of steps. For instance, a Project could be defined with a task to retrieve an XML file from a trading partner, then another task to parse the XML and finally a task to import the data into a database table.

Listed below is a summary of the built-in tasks:

DATABASE
SQL Runs any SQL statement supported by the database server (i.e. SELECT, UPDATE, INSERT, CREATE, DELETE, CALL, etc). This task is especially useful for extracting data from database tables, which could then be converted to various file formats and transmitted.  It is also useful for importing data from files that may have been retrieved from trading partners.
 
DATA TRANSLATION
CSV Write Converts a set of records to a CSV (delimited text) formatted file.
CSV Read Reads a CSV file and produces an output that can be used in another task (for instance, to import into a database).
Fixed-width Write Converts a set of records to a fixed-width (e.g. fixed length) formatted file.
Fixed-width Read Reads a fixed-width formatted file and produces an output that can be used in another task (for instance, to convert to XML format).
Flat File Read Reads a flat file and produces an output that can be used in another task.
Excel Write Converts a set of records to Microsoft Excel file format. Supports Microsoft Excel 95, 97, 2000, XP, 2003, 2007, and 2010 file types.
Excel Read Reads an Excel file and produces an output that can be used in a different task (for instance, to convert to CSV format). Supports reading from Microsoft Excel 95, 97, 2000, XP, 2003, 2007, and 2010 workbooks.
XML Write Converts records to an XML document. Accepts multiple inputs to produce complex XML structures with optional Schema and DTD validation. For example, order header and order detail records can be combined within a single XML document.
XML Read Reads data from a XML document (with or without Schema and DTD validation) and produces one or more outputs that can be used in another task (for instance, to import into a database).
Modify RowSet Modifies the contents of rows or records.
 
FILE ENCRYPTION
PGP Encrypt Encrypts files using the Open PGP (GPG) encryption standard.
PGP Decrypt Decrypts files using the Open PGP (GPG) standard.
PGP Sign Signs files with a private key (uses Open PGP).
PGP Verify Verifies file signatures with a public key (uses Open PGP).
Password Protect Excel Password protects an Excel document.
 
DATA COMPRESSION
Zip Compresses, packages and optionally encrypts files using the ZIP standard.
UnZip Decompresses ZIP files.
GZip Compresses files using the GZIP standard.
GUnzip Decompresses GZIP files.
Tar Packages several files together using the TAR standard.
Untar Unpackages a TAR file.
 
FTP
FTP Connects to a FTP server for performing file transfers (gets, puts) and other FTP commands.
FTPS Connects to a FTPS server for transferring files over SSL/TLS.
Close Session Closes an open FTP or FTPS session.
 
SSH Tasks
SFTP Connects to a SFTP server for transferring files over SSH.
SCP Connects to a SCP-compliant server for transferring files over SSH.
Execute SSH Commands Executes a command or shell script on a remote SSH server.
Close Session Closes an open SFTP, SCP, or SSH session.
 
E-MAIL
Send E-Mail Sends E-Mail messages through a SMTP server (with or without S/MIME encryption). Supports file attachments.
Retrieve E-Mail Retrieves E-Mail messages from POP3 and IMAP servers (with or without S/MIME encryption).
 
AS2
AS2 Send messages using Applicability Statement 2.
 
HTTP
HTTP Transfers files or calls web services using HTTP protocol.
HTTPS Transfers files or calls web services using HTTPS (HTTP over SSL).
GoAnywhere HTTPS Posts and Gets data from the HTTPS server in the GoAnywhere Services™ product.
 
MQ ENTERPRISE MESSAGING
Open MQ Session Opens a Message Queue Session with a MQ (JMS) Server.
MQ Send Message Sends messages to a MQ Server.
MQ Retrieve Message Retrieves messages from a MQ Server.
Commit/Rollback MQ Message Processes or rolls back MQ Messages without closing the session.
Close MQ Session Closes the session with the MQ Server.
 
LOCAL FILE SYSTEM TASKS
Copy Copies files and directories on local file systems, as well as network shares.
Create File List Builds a list of files based on filter criteria (e.g. wildcards, size, date). This "file list" can then be used in other tasks.
Move Moves files and directories.
Delete Deletes files and directories.
Make Directory Creates a new directory on the file system.
Merge Files Merges multiple files into a single file.
Rename Renames one or more files in a directory.
Search and Replace Searches for a string in a file and replaces it with a new value.
 
NATIVE CALLS
Execute IBM i Commands and Programs Executes (calls) a command or program on a IBM i (iSeries) machine.
Execute Native Command Executes a command (e.g. executable, script, etc.) on the system that is locally accessible by GoAnywhere Director.
 
JOB CONTROL
Call Module Routes control to another Module within the Project.
Call Project Executes a Project on the same installation of GoAnywhere Director.
Call Remote Project Executes another Project on a different installation of GoAnywhere Director.
Delay Pauses the Project for a specified period of time.
Exit Module Exits the Module when a condition is true.
Exit Project Exits a Project at the specified location if a condition is true.
Raise Error Generates an error in the Project, which can be used to abort the job or route control to another Module.
 
MISCELLANEOUS
Create Workspace Creates a temporary directory to store files while the job is running.
Delete Workspace Deletes the job's workspace, if any.
Set Variable Assigns a new value to a Variable.
Timestamp Makes the current date and time availabe to various tasks in the project. Custom formats can be defined to indicate how the date and/or time should be formatted.
Print Writes user-specified text into the job log.

GoAnywhere Director can be installed onto Windows, Linux, IBM i, AIX (pSeries), UNIX, HP-UX, Mac OS and Solaris platforms.  IBM i is also referred to as System i, iSeries, as400, as/400 and i5.