Skip to Content

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

File to JDBC Scenario

Hi all,

My scerio : File --XI ---JDBC scenario

JDBC is oracle DB

how to give connection parameters for an oracle.

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
Not what you were looking for? View more on this topic or Ask a question