Which Would Be Simpler/Easier to Read From and Write To ? Sftp or Amazon S3?

Question

Hi guys,

So I've been tasked to read from an sftp, convert it to a certain format and then upload it back. I was told, getting it from the Amazon S3 server would also be an option. So, which would be easier? Would appreciate a few resources, though I will also be doing my own research. I was told just earlier today and I'm asked to give feedback by tomorrow. Between other things I'm trying to accomplish, I don't think I could delve deep enough to determine for sure.

Anything else I should know about?

Thank you.

Ron

RonGatmaitan · Answer

Thanks for you replies, guys. @oliverd @TheOC Will definitely look into these.

oliverd · Answer

If SFTP hasn't in fact been depreciated then it would probably be the best choice since it's an open standard.

TheOC · Answer

hey @RonGatmaitan

The process to download from SFTP can be as simple as the download tool within Alteryx:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/File-Transfer-Protocol-FTP-Download/ta-p/10599

This tool is not depreciated - i believe the tool @oliverd is discussing is built by a community user. You do not need to use community-built tools to download/upload from SFTP.

In my experience, Amazon S3 is incredibly easy. 
https://help.alteryx.com/20214/designer/amazon-s3

So in your shoes given the choice, i'd go with Amazon S3 for ease of use, but both are valid and possible.

Cheers,
TheOC