Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 07, 2017 at 07:38 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2017 at 07:05 PM

    Hi Iuliana

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

    Add comment
    10|10000 characters needed 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