Need to automatically sync files via FTP/SFTP to S3 buckets? This article will show you how to do this with Thru OptiFlow, a product from Thru that enables businesses and enterprises to create file transfer workflows using multiple protocols and repositories.
Thru Inc’s file transfer automation solution is the only cloud-based solution of its kind that allows you to create, schedule and manage file transfer workflows without any scripting requirements or file size limits. Even better, all syncs of Amazon S3 storage are tracked in Thru and notifications can be sent to your users, devices and systems after syncing is complete.
Below is a quick demo from our webinar, The Future of File Transfer Automation, showing you how OptiFLOW can used to automatically sync files into your Amazon S3 storage from SFTP servers.
Note: OptiFLOW can preform various other file transfer automation scenarios. To learn more about what OptiFLOW can do, go here.
Scenario: Schedule Daily File Transfers from an SFTP Server to Amazon S3
The video you are about to watch will show you a scenario where a company needs to schedule a daily transfer of Purchase Order files from an SFTP server > store in Thru Cloud Storage > and then store a copy in Amazon S3 for archiving. You can read the video transcript below the video demo as you follow along.
Let’s go on to a demo where we can replicate that workflow [syncing files from SFTP server to an Amazon S3 bucket]. Okay so here I am and I’m just going to move a file via SFTP into an SFTP server. Let’s take this “Purchase Order 101” and we’re going to drag and drop it over here into the source. So while this file gets transferred we can now go and look at OptiFLOW itself.
So here’s the control panel that we set up. The OptiFLOW™ Control Panel is divided into sections that show each stage of the workflow. Workflows can be simple like one step actions (putting data into a folder) or you can set up a more complex, multi-step process. Setting up a workflow consists of three basic steps.
Using this pencil [icon], we can get access to edit the workflow and I can give you a quick tour of adding some sources. Choosing what repositories you want OptiFLOW to automatically pull data into your Thru site is as simple as that.
We can then look at adding processors and choosing what filters or transformations you want OptiFLOW to perform on the data that has been pulled into your [Thru] site. I’m going to click on a “Pass-Through.” This is where you can add a destination, which involves setting up an action that will be performed in the target repository after the data has been processed. And here is also a location where you can define notifications for the actions that have been performed. We’ve got email notifications, SMS and REST.
Going back to the workflow I’m just going to quickly remove these extra bits that I have added. We can now go to the Activity Stream, which can be accessed by double-clicking on these arrows. The activity stream is showing us what happened with that file that we uploaded to the SFTP server. If we scroll down here we can see that “Purchase Order 101” was pulled via SFTP from the server source, and put here in the [Thru] Cloud in our target directory. Once it arrived, a REST call was created and we can see the REST response that could be pushed out. Then the file was actually moved from a target folder to an S3 archive folder. And then finally, the file was taken from the S3 archive folder and actually pushed into the S3 bucket. If we go over to our S3 location now and refresh, we can see that same file has arrived.
Just going back to OptiFLOW just a second, we have an analytics view where you can view data regarding statistics of what’s going on with the [Thru] site as we showed in the slides earlier. We can see some further detail and this will give us views of daily and monthly statistics in details, and you can actually drill down into the numbers further.
Finally, I just want to mention if there was any errors or alerts an icon would appear and these can be set up to emailed out to admins or sent out via SMS. That’s the demo!
Ready to try Thru free for 14 days? Start your free trial now.