JDBC adapter - Oracle

[Former Member]

Hello all,

I am trying to build a scenario that uses the JDBC adapter in two communication channels to connect to Oracle databases. I am having difficulty connecting to the database so I have a few questions:

1. Does a driver get installed with the XI installation that allows me to connect to Oracle databases, or do I have to install that driver seperately?

2. What connection info do I put into the communication channel when it asks for <b>JDBC Driver</b> and <b>Connection</b>?

Thanks in advance

[Former Member · Accepted solution]

Hi,

have you seen this document?

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Hope this help

Francesco

[Former Member]

Harrison

Does a driver get installed with the XI installation that allows me to connect to Oracle databases, or do I have to install that driver seperately?

>> you need to install it separately in XI using SDM tool .

What connection info do I put into the communication channel when it asks for JDBC Driver and Connection?

>> you need give driver details and connection like databaseservername,databasename,port.which driver ur uisng.

check this blog for how eneter driver and connection details

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30