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:
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.
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
servers or Mail
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.
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.