Data Services and Amazon S3 - Integration?

[#1]

A client just threw a Data Services question at me that I can't answer - how do you get Data Services to integrate with Amazon S3?  They want to read files from S3 into Data Services for analysis and transformation, and then write their output back to S3 (ideally).

I did some googling and surprisingly, I can't find any discussions of anyone having done this before.

Could Data Services could call FTP to move files in and out of S3?

Is there some other interface or API that could be called from Data Services using the SQL transform (via a custom stored procedure)?

Has anyone already solved this?

I would be delighted to hear your ideas or war stories.

Cheers!

Michael

[Former Member]

Hello,

DS 4.2. SP7 has added connectivity to AWS S3. You can use the "File Location Object" to extract and load data to S3.

Here is a video of how to use File Location Object"

SAP Data Services File Location Object - YouTube

Please note that in DS 4.2.5, the File Location Object only supports FTP, SFTP, SCT protocols. In DS 4.2.7, we added support for AWS S3, Google Cloud Storage, and Azure Blob Storage.

Hope this help,
Lofan