Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Oracle drivers

Hi ,

Good morning,

Integrating File to Oracle system , I got connection parameters & JDBC drivers , i configured and checked the data is not going to the receiver database.how can i know the format of the oracle drivers.points will be appreciated.

regards,

stephen

Former Member
replied

Follow below blog

FILE to JDBC Adapter using SAP XI 3.0

Connection parameter & jdbc drivers changes

connection string : jdbc:oracle:oci8:userid/password@server

Note that this connection string is only if you use the Oracle OCI driver. The OCI driver requires a shared library or DLL on the server.

The thin driver for Oracle is more commonly used as it doesn't require any additional libraries. The connection string is as already listed above:

jdbc.oracle.thin:@server:port:SID

Follow this link

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

For all type of Jdbc drivers

http://www.devx.com/tips/tip/28818

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question