Database Connect (IBM Data Joiner) to SAP ECC intergration via PI/PO 7.3 system.

[Former Member]

Dear Friends,

We have come across a requirement where for a bunch of interfaces A backend database will connect to Data Joiner which inturn needs to fetch data (via lookup) from SAP ECC tables.

As per integration strategy; PI/PO has been considered as central MW and integration system in client's enterprise landscape.

Since, sender JDBC adapter is delivered with capability of reaching into database and executing query to fetch records with a polling interval; could there be some integration options available where a DB Connect system executes a query which reaches PI/PO system via an adapter or API and then PI/PO system converts the same to RFC call fetching data from SAP ECC and then send back records to Data joiner with another API or receiver JDBC Adapter?

Thanks!

Rgds

Prashant Rajani

[MichalKrawczyk]

Hi,

>>>>could there be some integration options available where a DB Connect system executes a query which reaches PI/PO system via an adapter or API and then PI/PO system converts the same to RFC call fetching data from SAP ECC and then send back records to Data joiner with another API or receiver JDBC Adapter?

easiest one - SOAP/WS calls (create a WS on PI which will pull the data from tables via ABAP proxies)

and will return the data to the caller

sender jdbc adapter cannot be started from any other tool (it's a pulling adapter) so the WS call would be the best and most standard option for any lookups,

Regards,

Michal Krawczyk

[Former Member]

Hello Michael,

We had propsed the same but the version of data joiner is not having webservice capabilities.

Thanks!

Rgds

Prashant