Tigger IDOC in JDBC to IDOC scenario

[priya_danasekar2]

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

[Bhargavakrishna]

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

[GauravKant]

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

[manoj_khavatkopp]

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

[priya_danasekar2]

Hi Manoj,

Thank you for the information.

Regards,

Priya D

[former_member186851]

Hello Priya,

If you just want to test the data from SAP PI ,you can trigger from Run time work bench.