Using JDBC Adapter

[Former Member]

Hi Guys,

I am developing a BSP where I have to access a

remote database. I want to use JDBC adapter for this.

But help.sap doesn't provide all the required

information.Can any one suggest a detailed weblog on

this.

Regards,

Amitabh

[Former Member]

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide... to install and configure external drivers for jdbc and jms adapters.pdf

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=<DBName>

UserID and Password.

Configuration of JDBC Adapter for Oracle

JDBC Driver = oracle.jdbc.driver.OracleDriver

Connection = jdbc:oracle:thin:@<hostname>:1521:<DBName>

If the connection is not working find the correct port number.

Hope this helps

SKM

[Former Member]

Hi Amitabh,

You are using BSP just for displaying purpose. For processing you use XI.So i think if u have used JDBC adapter earlier you can very well use it here also.

Also check the Demo Example-Configuration Guide in sdn .You will get better idea because they also have a similiar scenario there.

Njoy

Divya

[cdumont69]

Hello,

I think you can find all you need in help.sap.com :

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

If you need more information, ask for them.

Regards,

Chris