Skip to Content

Integrate SAP ECC with AWS on HANA Using SAP PI

Hello,

We need to integrate our on premise SAP ECC ->SAP PI->AWS on HANA(Cloud application).

Would you please let me know what adapter to use while communicating with AWS on HANA? Basically the requirement is to write data to AWS on HANA database.

Can we use JDBC(HANA) adapter ? OData adapter ? or REST Adapter?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 13 at 08:39 PM

    Hello Priyanka,

    Thank you very much for your inputs. HANA on AWS is offering OData service to update data for us. So we ar planning to decide OData adapter to communicate with AWS HANA.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08 at 06:48 AM

    Hi,

    Recently, I've tried to connect to AWS using a plain JDBC connection and was successful. First, you need to get the required JDBC drivers and deploy them in PI/PO. Then, place the AWS certificate file in keyroot path or in any PI location and use it in JDBC connection string.

    Refer the below SAP notes to check how to deploy the drivers.

    1138877, 1829286 , 1816456 & 1770304.

    ---Priyanka

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Priyanka,

      I want to connect JDBC Receiver channel to MS SQL database which is on AWS.

      Could you please help me with connection string details which needs to maintained on channel level.. or any steps needs to maintained in SAP PI.

      Thanks,

      Chaitanya Duvedi