Skip to Content

Tigger IDOC in JDBC to IDOC scenario

Hi,

Please let me know how to trigger idoc from JDBC to SAP (ECC system) for End to End testing. I know to trigger idoc from PI to SAP.but i want to know From JDBC to SAP with detailed steps.Kindly help me on this as i am new to this PI.

I created all ESR and ID objects.

Thanks & Regards,

Priya D

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 13, 2016 at 06:35 PM

    Priya,

    Firstly tha DB team has to update some data in thier database so that it matches your Select query mentioned in sender JDBC channel , once data is present your Channel will poll automatically and post to SAP if no issues.

    Br,

    Manoj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 15, 2016 at 04:07 AM

    Hi Priya,

    first of all, if you want to test jdbc to idoc scenario, hope you have JDBC connection parameter and query SQL statement at place. and you have execute permission on DB.

    whenever data will be available on your DB query SQL statement(exec) will pick the data from jdbc and process the same to IDOC.

    Regards,

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 15, 2016 at 04:11 AM

    Hi Priya,

    Apart from ESR and ID objects did you do the following?

    --> ALE / IDOC configuration in SAP PI and SAP R/3?

    --> Deployed relevant JDBC drivers in SAP PI?

    In Dual Stack systems, we can trigger the message from RWB --> Integration Engine --> Test Message.

    If you wanted to test scenario on single stack create SOAP sender adapter and use Webservice navigator to trigger message for idoc testing in SAP PI/PO.

    Please check the below blog for your reference.

    HowTo - Send Test Messages to the Adapter Engine (to an Integrated Configuration)


    Regards

    Bhargava Krishna

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.