Regarding JDBC connection

[Former Member]

Hi Experts,

i would like to do File to JDBC scenario.

what are the setting i need to provide in XI for this scenario to establish connection b/w XI and JDBC server??

plz suggest me??

Thanks in advance.

[former_member181985 · Accepted solution]

You need to deploy the DB specific driver files in XI.

[Former Member]

Hi,

Please check this blog, this would be helpful.

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

Regards,

Siddhesh S.Tawate

[Former Member]

Bhuvan,

Parse this - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

So, for establishing connect you need to know,

1.Java class for JDBC driver

2.Address with which you can establish a database connection using the JDBC driver.

3.user name to log in DB

4.Pwd for user-name (including confirmation)

But, I am sure, all these details can be provided by your basis team.

Cheers !

Vaibhav

[Former Member]

Hi,

You need to deploy the external driver for JDBC..

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

Create a JDBC receiver communication channel using the required connection string.Connection string will vary according to DB.

Regards,

Prakasu.M

[Former Member]

provide the jdbc connection url specific information in JDBC adapater (receiver communication channel in your case)