File To JDBC Scenario

[Former Member]

While doing this scenario,

In the receiver communication channel, I selected JDBC adapter as the receiver..

Transport protocol JDBC 2.0

Message Protocol JDBC

Adapter Engine Integration Server

Under Database Connection

JDBC Driver (I am unable to locate the driver...any tips and how to look for that would be appreciated)

Connection(also where can I see the path of that)

Is there any standard driver and connection parameters which we can use for testing.....this scenario...

Mine is a windows XP professional operating system...version 2002 with SP3...

My system has Oracle 10G....

Where can I look for the information about the JDBC DRIVER and Connection...

Also, give me the correct format ....because I am new to XI......trying to learn this scenario...

Thanks..

[Former Member]

Hi Vishnu Vandana Patnala ,

Check the below links guideing u step-by-step:

FILE to JDBC Adapter using SAP XI 3.0

Configuring the Outbound File Adapter

http://saphelp.border-states.com/EN/95/bb623c6369f454e10000000a114084/content.htm

To install JDBC adapters

http://saphelp.border-states.com/EN/b3/cc633c3a892251e10000000a114084/content.htm

configure the available adapters

http://saphelp.border-states.com/EN/88/0f453cf1fcc85ee10000000a11402f/content.htm

[dharamveer_gaur2]

user name: <>

password: ####

driver Name: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@hostname:1521:SID

(System ID of oreacle server).

let me know if any problem

[Former Member]

Hi,

Follow below blog

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-fa0b1ed4...

For all type of Jdbc drivers

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

Regards,

Jayasimha Jangam

[Former Member]

Hey

You need to install drivers as given in the following article

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

Thanx

Aamir