Database
GoAnywhere Director™ can connect to a wide variety of database servers including DB2 on the IBM System i, DB2, Oracle, PostgreSQL, SQL Server, Informix, Sybase and MySQL. Since GoAnywhere Director connects to database servers over the TCPIP network using standard drivers, no additional software needs to be loaded onto those database servers.
Database server connections can be defined in GoAnywhere Director as reusable Resources which can then be selected from simple drop-down menus.
Any SQL statement supported by the database server can be issued by GoAnywhere Director including SELECT, UPDATE, INSERT, DELETE, CALL and CREATE statements.
Screen example of a SQL SELECT statement in GoAnywhere Director:
Data Export
Rows (records) can be retrieved from tables (physical files) on the database servers using SQL SELECT statements. An intuitive SQL Wizard is provided in GoAnywhere Director for building SELECT statements quickly. With the wizard, the user can choose tables, joining, fields, column headings, "where" criteria and "order by" criteria.
The selected records can be converted into Excel documents, delimited text files, fixed-width text files and XML documents. As part of a cohesive process, the resulting files can then be compressed and/or encrypted and then placed on the local file system, distributed to FTP and HTTP servers, or sent to email addresses.
Data Import
Files can be imported into database tables using GoAnywhere Director. These files may already exist on the local file system or may have been fetched by GoAnywhere Director from FTP servers, HTTP servers or Mail servers.
GoAnywhere Director can read data from popular formats including Excel documents, delimited text files, fixed-width and flat file text files and XML documents. The imported data can be appended to the end of existing tables or can replace the contents of the table.
Database Replication
Rows (records) can be replicated between database servers using GoAnywhere Director. For instance, a project could be defined to copy records from a System i physical file into a SQL Server table. This project could be scheduled and automated. Records can be appended to the end of a table or can replace the existing records in the table.
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.