GoAnywhere Technical Documentation
GoAnywhere Director is a centralized solution for automating data retrieval, translation, encryption, compression and distribution for the enterprise. With GoAnywhere Director’s intuitive interface and comprehensive functionality, you can easily streamline and secure the exchange of data with your customers, trading partners and internal servers.
GoAnywhere Director will dramatically reduce the need for custom programming and single-function tools which were traditionally required for processing data. GoAnywhere Director is an enterprise solution with features to support the most demanding environments.
- Simplifies and automates FTP (File Transfer Protocol) processes
- Connects to secure FTP servers (SFTP, FTPS, and SCP) for protected communications
- Exchanges files with HTTP and HTTPS servers
- Encrypts and decrypts files using the OpenPGP encryption standard
- Compresses and decompresses files using the ZIP, GZIP and TAR standards
- Connects to popular database servers including DB2, DB2/400, SQL Server, Oracle, Informix, MySQL and Sybase
- Translates data to/from database tables, Excel, XML, Delimited text and Fixed Width file formats
- Provides options to Loop tasks for advanced data management
- Replicates data between database servers
- Sends and retrieves files via E-mail and secure E-mail
- Allows for centralized control and monitoring of transfers through a browser interface
- Provides a comprehensive built-in scheduler
- Produces complete logging reports
Please note :- All the transactions are initiated from the Thirdparty software GoAnywhere, at no time Projects are allowing transactions initiated from vendor.
Communication to vendors
· Option 1 – if the vendor can use sftp server facility then we would need sftp server IP address, login details, Public pgp keys.
· Option 2 – If the vendor has no sftp server or technical set up, Vendor needs access to GoAnywhere Services, please create a request with Technical services to have an account created on services so that they can upload the files manually or if they want the automated upload of the files on GoAnywhere services, vendor needs to create automated script to upload files. Note - This is not recommended option, if only inevitable this option can be used due the security reasons. For example – All community colleges transmissions are happening this way.
. 
Set Up a New Project:
Click on Projects
. 
. 
. 
.Select the project that you need to copy from, click on Copy button
. 
. 
Click on the Copy button.
. 
Click on pencil icon(edit) the project.
. 
Change the sftp server to ban8 and click on SAVE button.
. 
Testing the sftp connection.
Click on Resources and SFTP Servers on the left under Resources Types.
. 
Click on Edit under Actions.
. 
Click on Test button
. 
Compile the project, after you are done setting up, don't click on Execute project until you are sure of sending the files to vendor. Before Transmitting any test files to vendor ask about the naming of the file.
Before transmitting the files, Please verify all the tasks under project.
1, Timestamp, for manual transmission change the day of the month depending on the datestamp of the file.
2, SFTP, verify if it is pointing to the correct sftp server.
3, Fileset, under this task verify the wildcardFilter is pointing to the right pattern of the file.
4, pgpEncrypt verify for the public key of the vendor.
5, SFTP, the second sftp task, verify if it is pointing to the vendor server.
. 
. 
Click on Execute Project
. 
After you click on Execute Project, click on View Job log to verify the file has been transmitted successfully.
. 
Confirmation of Project committed and compiled successfully.
. 
Bsae directory is the directory where you are pulling the file from
For example: prod banjobs code tree is /banjobs/PROD/
Ban8:- /banjobs/BAN8.
. 
Schedule a New Job:
Under Project tab:
Enter Job Name, Description, Project(Browse for Project Name), Login as and Password(Use GoAnywhere Login and Password - Job_Run)
Please note: - Job_Run is the username set up to only run all scheduled jobs on GoAnywhere Director.
And also note that:- Job Name and Project should be same to make it easier to search on jobs that have run successfully or failed for some reason.
. 
Click on Save
Under Schedule Tab:
Check scheduling with Client and fill in all appropriate fields.
. 
Click on Save
Under E-Mail Notification Tab:
Notifications are optional.
. 
Click Save if data is entered.
Do not enter any data under Project Variables Tab.
Importing the Vendor Keys:
Save the file that vendor sends by email containing the public keys to GoAnywhere File Manager.
. 
Click on the folder of the vendor you want the public keys to reside in.
. 
Click on Upload
. 
Click on Add(verify)
. 
Browse to the folder where the public keys are stored on your computer.
. 
Click on Close
. 
Go to GoAnywhere Main Menu - Under Tools - Click on Manage OpenPGP Keys
. 
You will see the existing keys in the list below.
Click on Import Keys(s)
. 
. 
Click on the Server.
. 
Browse to the folder that contains the keys.
Select the keys folder, then select the vendor folder (for ex. Deleta Dental) containing the keys you want to import.
Click the button next to the keys you want to import.
. 
Click on Select .
Click on Import.
. 
Verify message that key(s) were imported successfully.
. 
Prod installation
When the projects have approval from the functional users for migration to prod. Change the status on the ticket to 'Awaiting install'
Anthony Becker - Database Management team will conduct code review and migrate the projects to PROD folder.
<<DBHowTo>>