On demand fetching data from Third party System

[Former Member]

Hi,

I have a requirement where in User wants to run a report in SAP ECC system to pull the record from a Third party system's table.

Issue here is:

Live data: It has to get the data from Third party system whenever user runs the program.

Any possible way to work it out? Through SAP PI.

TIA.

Regards

Prabhat.

[Former Member · Accepted solution]

Use Proxy to JDBC for your scenario. It is good to go as both jdbc and proxy support synchronous.

Regards,

Suhale Shaik.

[Former Member]

Hi Prabhath,

You go through the below link for proxy settings.

For Jdbc Configuration go through this

Regards,

Suhale Shaik.

[Former Member]

Hi,

What is the volumes you are looking at? Because going to a third party to fetch large amount of data might take some time and resource intensive.

But if it is not large volumes. Go this route if possible.

Proxy - WebService. Sync call.

Regards,

Jannus Botha

[Former Member]

Data is not large. Would be around 1k records with 4-6 relevant fields.

What about JDBC instead of webservice? would there be any issue?

Thanks,

Prabhat.

[Former Member]

Hi,

JDBC would also work fine. We are using a similar solution. So know it works.

Good luck,

Jannus BOtha

[Former Member]

Hi Prabhath,

Use proxy as  synchronous. What about the party system? Is it data base?

What about your PI version?

Regards,

Suhale Shaik.

[Former Member]

Thanks Suhale for reponse!

Yes, third party is database. Can be connected to through JDBC.

PI 7.3.

Thanks,

Prabhat.