Proxy - JDBC PI 7.31 Single Stack

[former_member309357]

Hello Experts,

    Proxy to JDBC scenario in PI 7.31 single stack.

     I have the requirement that whenever proxy is coming to PI, it needs to look into another JDBC table, if the specific field in that table is available against the fields which comes from proxy. Then only that files needs to be processed and send successfully to JDBC other it should fail.

     Do JDBC Lookup works over here??

     If so please suggest how to use the same in PI 7.31, Single Stack.

     Waiting for your valuable replies.

     Thanks a lot in advance.

Thanks

Ravi.

[gagandeep_batra · Accepted solution]

Hello Ravi

Yes you can do Jdbc Lookup check below link for that

http://scn.sap.com/people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-s...

after lookup you can check for your field if it is available then pass it otherwise if it's not available then raise the exception and stop it in mapping only.

Regards

gAgan

[former_member309357 · Accepted solution]

Thanks Gangadeep for your quick reply .

But, whenever I am trying to import table structure as an external definition as shown in the blog you mentioned above, I am unable to found that table.

I am using 3 tier architecture in my project.

Kindly suggest.

Thanks

Ravi

[former_member309357]

Hello experts,

     To import the table, do we need any authorization to that tables for the user we use in the JDBC receiver communication channel.

     Please provide your valuable inputs.

Thanks

RAvi..

[rodrigoalejandro_pertierr]

you need a JDBC Lookup, but i would create a UDF insted of standard JDBC Lookup.

that because you will need to receive a collection of the fields that exists in the table in the DB, then validate which fields exists and send only those field.

the other way should be call a JDBC lookup per field. in this case the standar function apply better.

i dont have the whole context of the scenario i give you alternatives.

BTW are you trying to get the TABLE1 from your DB same as the blog? You need to find the table which  you will compare the fields that come in the client proxy .

Regards

[former_member309357]

Hi Rodrigo,

    I am trying to find the table which I need to do look up but unable to find so.

Thanks

Ravi.

[rodrigoalejandro_pertierr]

check the parameter defined in the External Definition object I belive that one of the parameters are bad defined.

i sugguest if its possible to confirm the data with the DB team i you has doubts about it.

Regards

[former_member309357]

Hi Rodrigo,

    Can you please elaborate step by step. First I am trying to import table as external definition. As of now, no JDBC receiver channel is created and neither parameters in message mapping.

     And my scenario is PROXY to JDBC and we are using same receiver jdbc channel for all the outbound scenarios. In this case do i need to create another JDBC receiver channel with the same connection parameters??

     Waiting for your valuable reply.

Thanks

Ravi

[gagandeep_batra]

Hello ravi,

check below help doc for step by step approach

http://help.sap.com/saphelp_nwpi71/helpdata/en/44/749dd812dd3676e10000000a114a6b/content.htm?framese...

Regrads

gAgan

[former_member309357]

Hi Gangadeep,

   Thanks for your quick reply.

   As I told that we have scenario PROXY-JDBC and using common channel for all the scenarios.

   For the look up which I need to use, do I need to create an another channel with same database connection parameters.

Thanks

Ravi

[gagandeep_batra]

It is better to use two CCs.

Regards

gAgan

[former_member309357]

Hi Gagan,

    I am unable to find the table which I need to import as external definition.

    Checked for all the existing tables which are using currently by JDBC Receiver, but none of the tables are appearing while searching.

    Please help.

Thanks

Ravi

[gagandeep_batra]

did you check the status of Receiver CC in RWB & also check the authorization for that

Regards

gAgan

[former_member309357]

The status of the Receiver CC is running and could you please let me know how can i check for the authorization.

Thanks

Ravi

[gagandeep_batra]

check the PI user in database have the access for that tables or not?

Regards

gAgan

[rodrigoalejandro_pertierr]

Hi, if you take a look to the blog, to be able to impot the table first, you need to create a CC. second go to ESR--> create an "external definition" object and select the option to import the TABLE, there you need to define the DB name and the DB table, thats all

once you import it you have two possibilities, create another CC for the integration or use the channel created before, the configuration will be the same. its up to you.

Best Regards

Rodrigo

[former_member309357]

Hi..

  The problem I am getting is I am unable to find the table name which I need to import.

Thanks

RAvi

[rodrigoalejandro_pertierr]

have you seen this blog?

http://scn.sap.com/people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-import-sq...

Rgds

[former_member309357]

Hi Rodrigo,

       I have followed the above link, but whenever trying to find out the table to import as external definition, none of the tables were displaying

Thanks

Ravi...

[Former Member]

Hello,

U can certainly use standard JDBC lookup  function inside mapping and depending upon the response send message to another system.

Thanks

Amit Srivastava