Proxy to JDBC scenario data to be fetched from two dB

[Former Member]

Hello all,

we have a requirement in which the data is sent from an abap program and using PI it will fetch the data from DB at client side,

and we need to display the data in the report program.

As we need the real time data and need to be displayed back in the Report program the processing time should be less than 30 sec.

We have tried the scenario using synch Proxy-synch jdbc and we are getting the data with in time but we tried this with 1 DB.

But now we have requirement change and we need to look the data in 2 Data bases.

• we need to pass data through client proxy(Synch) to PI and it should check the data in 2 DB and send back the data.

• the data sent back from the DB, we need to show in our ABAP program.

Please send in your inputs so that i get some pointers regarding this requirement.

Thanks

Karandeep Singh

[VijayKonam]

If you are looking to fetch multiple fields, from 2 DBs, BPM is a must. May be using a fork in parallel might help reducing the time to process but over all the process is definetly going to take longer time.

VJ

[Former Member]

HI Vijayashankar,

Thanks for your reply.

Please brief me the steps for using fork in BPM.

Thanks

Karandeep Singh.

[prateek]

Checking data in 2DB and making sync calls from both DBs won't be possible without BPM. But that would increase the overall processing time of scenario. Do you need to fetch multiple fields from database? If no, have you also thought of JDBC lookups?

Regards,

Prateek