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:
||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.
||Converts a set of records to a CSV (delimited text) formatted file.
||Reads a CSV file and produces an output that can be used in another task (for instance, to import into a database).
||Converts a set of records to a fixed-width (e.g. fixed length) formatted file.
||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.
||Converts a set of records to Microsoft Excel file format. Supports Microsoft Excel 95, 97, 2000, XP, 2003, 2007, and 2010 file types.
||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.
||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.
||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).
||Modifies the contents of rows or records.
||Encrypts files using the Open PGP (GPG) encryption standard.
||Decrypts files using the Open PGP (GPG) standard.
||Signs files with a private key (uses Open PGP).
||Verifies file signatures with a public key (uses Open PGP).
|Password Protect Excel
||Password protects an Excel document.
||Compresses, packages and optionally encrypts files using the ZIP standard.
||Decompresses ZIP files.
||Compresses files using the GZIP standard.
||Decompresses GZIP files.
||Packages several files together using the TAR standard.
||Unpackages a TAR file.
||Connects to a FTP server for performing file transfers (gets, puts) and other FTP commands.
||Connects to a FTPS server for transferring files over SSL/TLS.
||Closes an open FTP or FTPS session.
||Connects to a SFTP server for transferring files over SSH.
||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.
||Closes an open SFTP, SCP, or SSH session.
||Sends E-Mail messages through a SMTP server (with or without S/MIME encryption). Supports file attachments.
||Retrieves E-Mail messages from POP3 and IMAP servers (with or without S/MIME encryption).
||Send messages using Applicability Statement 2.
||Transfers files or calls web services using HTTP protocol.
||Transfers files or calls web services using HTTPS (HTTP over SSL).
||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
||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.
||Moves files and directories.
||Deletes files and directories.
||Creates a new directory on the file system.
||Merges multiple files into a single file.
||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.
|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.
||Routes control to another Module within the Project.
||Executes a Project on the same installation of GoAnywhere Director.
|Call Remote Project
||Executes another Project on a different installation of GoAnywhere Director.
||Pauses the Project for a specified period of time.
||Exits the Module when a condition is true.
||Exits a Project at the specified location if a condition is true.
||Generates an error in the Project, which can be used to abort the job or route control to another Module.
||Creates a temporary directory to store files while the job is running.
||Deletes the job's workspace, if any.
||Assigns a new value to a Variable.
||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.
||Writes user-specified text into the job log.
GoAnywhere Director can be installed onto Windows, VMware, 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.