how to Dump files in AWS S3 from SAP business Process Automation

[vedika11]

I am working on a solution where I need to upload files from SAP Build Process Automation (SAP BPA) to Amazon S3. I have already created a flow to download files from an SAP BPA screen flow, but I am facing issues connecting to S3. SAP BPA does not provide a native way to directly connect to S3, and I am unable to use Basic Authentication via SAP Cloud Platform Integration (CPI). Is there a way to achieve this integration, or would another approach be necessary

SAP Build Work Zone, advanced edition SAP Business Workflow  SAP Business Process Automation by Redwood SAP Business Process Management SAP Build SAP Build Process Automation 

[MarioDeFelipe · Accepted solution]

Hi @vedika11 

You are right, there isn't a native connector in SAP BPA directly for S3, and using SAP Cloud Platform Integration (CPI) might be restricted by the lack of support for Basic Authentication.

There are several ways but probably your simplest way is using an API-Based Approach with any AWS SDK or REST API, in 2 steps.

You use SAP BPA's capability to invoke RESTful APIs to connect to S3 directly. Amazon S3 allows to Generate Pre-Signed URLs for S3 file uploads. Pre-signed URL allows to securely uploading files without directly exposing your AWS credentials.

After this, you Invoke the Pre-Signed URL from SAP BPA: Once the pre-signed URL is generated (which could be done using a small AWS Lambda function or a custom API Gateway endpoint), you can use SAP BPA's HTTP call capabilities to upload files directly to S3 using the URL.

Like that you do not need managing AWS credentials directly within SAP BPA, as the pre-signed URL handles the authorization securely.

There are some blogs and articles on how to do these 2 steps even you see them separate, quite simple. Let me know how it goes