Workflows for Transfer family SFTP Connector

Hi,

Have a look at https://aws.amazon.com/aws-transfer-family/features/?nc=sn&loc=2&dn=1

The standard target of AWSSFTP is an S3 bucket :

Data stored natively in AWS Storage services
Store the files you exchange as objects in your Amazon S3 bucket or Amazon 
EFS file system so you can extract business insights faster. The key piece that 
makes this exchange possible is that AWS Transfer Family stores your data natively 
in S3 or EFS, while preserving relevant file metadata. For example, with your files 
stored in Amazon S3, you can use Amazon Translate to make process documents 
more tailored for international audiences. You can also use Amazon Comprehend 
to extract relationships and insights from text files, or you could even use Amazon 
Athena to query CSV files to analyze historical data. Similarly with files in EFS, 
you can directly integrate your ERP system to access these files on arrival from 
your business partners.

When the file is in the bucket, you can trigger a Lambda: https://docs.aws.amazon.com/lambda/latest/dg/with-s3-example.html

And from this Lamda, trigger a Step Function to execute any workflow that you want: https://aws.amazon.com/step-functions/

All the above will be constructed based on AWS serverless managed services: so, minimal effort and maximal efficiency on your side. No patching, server montoring, HA, scaling, etc: the managed services will take care of that for you.

Best,

Didier