Send CSV file to Amazon Cloud bucket in PI / PO (SFTP to Rest transmission)

[Former Member]

Hello experts,

I need to create a transmission in SAP Process Orchestration to send a CSV file from our SFTP server to Amazon bucket. The vendor only accepts CSV format. I am thinking of using REST adapter on receiver channel, but not sure about the rest of the details...what kind of authentication should I choose (they provide Access Key ID and Secret Access Key)? Would a transmission SFTP to Rest work? Did anyone create this kind of transmission before and can help with some advices?

Thank you,

Iuliana

[Former Member]

Hi Iuliana

we have a similar requirement.were you ever able to get this connection working, if yes can you provide few inputs?

[Former Member]

Hi Ranjith,

We also have similar requirement could you please help us with the inputs if you achieved this successfully. Will appreciate for your valuable inputs.

Thanks in Advance

Regards

G V Anil

[Former Member]

I configured the Sender channel to pick up an XML file from our Unix server via SFTP adapter - this works fine. I will have to deal with the conversion from CSV to XML later on.

However, I am having trouble configuring the REST adapter in Receiver channel.

I am attaching some printscreens on how the Rest URL looks like and where I've put the Access Key ID and Secret Access Key, the PUT command and the error I am getting on the Receiver channel.

I appreciate any idea on what I need to change to the Receiver channel to make the transmission work.

Thank you,

Iuliana

[karl_papesch]

Hello, were you ever able to get this connection working? I'm trying to do the same thing, Send csv file via REST adapter to Amazon S3 bucket. I have my receiver channel settings the same as yours, but I'm getting a different error, "Exception caught by adapter framework: Peer certificate rejected by ChainVerifier:" Did you also have to import any certs into PI Trusted CA's?