Skip to Content

JOINS in JDBC receiver adapter

Hello Gurus,

I have a requirement to design an interface which involves JDBC adapter as a receiver.

Scenario:

SAP would send a request message with EmployeeID field. 

PI would perform the select query on three tables (each table has more than a million records) based on EmployeeID field and send the output of select query back to SAP as response.

Can you please let me know how it can be implemented in PI?

Can a join query be formed in PI message mapping step?

If So could you please provide the step by step procedure ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 15, 2014 at 10:31 AM

    Hi Sahithi,

    Simplest solution would be to implement a stored procedure and call the same from PI mapping which does the all query logic.

    Thanks

    Chirag

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Chirag,

      Thanks for your reply!

      I am able to retriev the data from multipletables using "SELECT" statement at receiver side. My scenario is synchronus.Could you please expain how can we send the response data to SAP.

      Also is it possible to do it dynamically.Incase if i have 10 to 15 table then how could we acheive this ?