Cross Reference within external Database using XREF API

[Former Member]

Hi Experts,

Can we do Cross Reference within external Database using XREF API uses JDBC to access the Oracle Database Stored Procedures in SAP PI? How to use a JNDI Data source to access the DB and how to do the Connection Pooling will be done by the SAP J2EE server? Kindly let me know step by step proceedings.

Regards

Archana

[Former Member]

Hello Archana,

It can be done with a Lookup call in a mapping.

Here's a little article about the topic in the SAP wiki:

http://wiki.sdn.sap.com/wiki/display/XI/HowtouseCrossReferencewithinexternal+Database

With kind regards

Sebastian

[Former Member]

Thanks. But I need little morethan it. how to proceed step by step etc..