JDBC to JDBC without XI/PI

[Former Member]

Hi All,

I have need to integrate our SAP ECC 6.0 with an external application oracle-based. Which are the possible integration connections without XI/PI? We think for example of JDBC to JDBC connection. HAve you experience / tips about it or other kind of connections?

Thanks,

Bob

[former_member181985]

Hi Bob,

Direction of data flow, Is it ECC --> ORACLE or ORACLE --> ECC or BOTH?

what is the interface mechanism on ORACLE application side ?

Edited by: Praveen Gujjeti on Nov 27, 2010 1:24 PM

[Former Member]

Hi Praveen,

both direction of data flow. The interface mechanism on ORACLE application side is JDBC but also web services can be developed. So we are thinking also to use web services for the connection between the systems.

Which are the main advantages of web services compared to JDBC?

Thanks a lot,

Bob

[Former Member]

Hi

Web services can be sync as well as async. Exception handling is alo possible.

JDBC will be only async. You need to establish connection to the tables in your code where JCO is happening.

Regards

Monika

[Former Member]

Hi

You can go for JCo

Using JCo in Java, you can connect to ECC using RFC's or even Entreprise services on ES Workplace.

Regards

monika