JDBC driver

[Former Member]

Hi

I am having a scenario where i the sender is a SQL database system which uses the JDBC adapter and the receiver is an R/3 systen.can someone tell what would be the prerequistes for the JDBC Adapter,i.e the details of the JDBC drivers and all.

Thanks and Regards

Sunil

[Former Member]

In addition to the reply below, when you define your JDBC outbound/Sender interface in the Integration Directory you need MS-SQL driver definations:

Jdbc Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://servername;DatabaseName=DBnamexxx

[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:<port>;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.

SKM

[Former Member]

chk this link which has details on how to deploy the JDBC drivers so that XI JDBC adapter can use these drivers to access your SQL server database. It is available in the XI homepage -> popular documents section in SDN.

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

Regds

Saravana

[MichalKrawczyk]

Hi Sunil,

take a look at question 5 documents section:

/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions

also this document:

How To Install and Configure External Drivers for JDBC & JMS

https://websmp204.sap-ag.de/~sapdownload/011000358700003994312004E/HowTo_ConfigExtAdapters.pdf

Regards,

michal

Message was edited by: Michal Krawczyk