SFTP GET function with Boomi & Gloomi

Owned by Lara Juenger
Last updated: Sept 19, 2023
4 min read

Many Integration use cases still rely on the creation and sharing of files. SFTP is a common, reliable and secure mechanism for the transfer of files. As part of the UConn Boomi Service model for project teams, a service account is available on a dedicated sftp server (a.k.a. gloomi.grove.ad.uconn.edu) for each SubAccount. Each project team is responsible for ensuring proper security and privacy and use of data within their team as it pertains to file sharing and access via SFTP.

Boomi offers several Process Libraries and tutorials for learning how to use the SFTP connector. A great place to start is with Recipe: Start Connecting with SFTPs. The instructions below are intended to give a basic example, specific to the use of SFTP at UConn.

This article is intended for individuals who have a Boomi Associate Integration Developer Certification. If you do not know how to complete an action like “add a message shape”, please complete the recommended trainings

 Instructions

Always look for v2 before using an earlier version of any connector. In this case we will use the sftp v2 connector. Each SubAccount comes delivered with a default sftp connector for use with gloomi.grove.ad.uconn.edu that is already populated with credentials.

  1. Credentials are stored in LastPass for each subaccount sftp user.

  2. The Authentication Type for connecting to gloomi is Username and Password, there is a data directory in the root, the host is gloomi.grove.ad.uccon..edu, the user name and password are specific to your subaccount and the proxy type is Atom. Nothing else needs to be set for pushing and pulling files to gloomi but other sftp connections might be different.

  3. A simple process to get a file looks like this. Begin with a No Data Start shape.

  4. Add a Set Properties shape and click the green plus under the Properties to Set label and add a the Remote Directory property of the SFTP V2 connector. Click OK.

  5. Add the directory path by clicking the green plus under the Property Values label and entering a static filename. Click OK.

  6. Add an SFTP v2 connector to the Set Properties shape. Set the Connection to the connector created in step 2, e.g.SFTP V2 to Gloomi Connection for IAM. Set the action to GET. Click the Import button. Select an atom to run the import on. Boomi will do some processing

  7. Select and atom to run the import on. Boomi will do some processing then present the Object Type of File in the drop down. Click OK.

  8. Click Save on the Operation window.

     

  9. You will specify the filename you are getting as the ID on the Parameters tab of the Connector Shape

  10. Add a Stop shape. Save the process.

Time to test!

How to Test

  1. Click Test in the upper right corner of the process pallet.

  2. Pick the Test Atom Cloud (TAC) available in your subaccount and click OK. An example shown here is the generic Test-Atom-Cloud for the mail UConn account.

  3. The process will execute in test mode, and you will see each step get a green halo as it completes successfully. You will see a success message when it is done.

  4. To verify the file was retrieved correctly you can stay in boomi and click on the Stop Shape, click on the Shape Source Data tab in Test Results and view the sftp response.

 Related articles