Skip to Content
0

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

Mar 13, 2017 at 09:02 PM

531

avatar image
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

pi | po | aws | csv | amazon
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Mar 15, 2017 at 08:07 PM
0

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


rest-url.png (14.1 kB)
auth.png (21.3 kB)
put.png (4.0 kB)
error.png (6.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
Karl Papesch Jun 07, 2017 at 07:38 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 07, 2017 at 07:05 PM
0

Hi Iuliana

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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

0