multiple JDBC drivers

[Former Member]

Hi all

in my scenario i want to connect SAP to multiple data base

for example sap to system1,system2,system 3 and vice versa

system 1 has SQL server

system 2 has oracle data base

system 3 has data base sybase

my question is does sap support multiple JDBC driver installation at a time?

or how can i do this sceanrio?

any document or blog will be highly appreciated

Thanks

sandeep

[former_member192295 · Accepted solution]

Hi,

XI/PI can support more then one drivers installation, based on requirement choose driver, but one channel at a time can support one driver and can communicate one database only.

[JoelTrinidade]

Hi Sandeep,

I am witness that Xi can connect to multiple databases. There is no problem just make sure you mention the driver string correctly.

Regards

joel

[Former Member]

Of course, you can connect XI with multiple databases. You can install the JDBC drivers for all databases. There is a guide in the How to section called How to Install and Configure External Drivers for JDBC JMS (NW2004).

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards

Jai

Edited by: Jaishankar on Mar 6, 2009 12:11 PM

[former_member206760]

dear Sandeep,

if you want to do this though XI ...it is very simple

you will have only one source system -> SAP

and 3 target business systems namely DBASE1,DBASE2,DBASE3..

and you will have seperate communication channel for each of them...

you can specify different driver information in different communcaion channels like in the SQL communcaition channel which conncets to dbase1 you can specify SQL deriver

for oracle communcation channle that conncets dbase2 you can speciy oracle drivers ans so on

YES XI does support different driver instatllation

hope this helps

Edited by: Tarang Shah on Mar 6, 2009 1:01 PM