cancel
Showing results for 
Search instead for 
Did you mean: 

how to use jdbc odbc to connect to third party database from SAP PI 7.3

Former Member
0 Kudos

Hi Experts,

How do we use jdbc-odbc driver (type 1 driver) to send data from SAP PI 7.3 to a third party DBMS.

How is it different from using jdbc thin driver (type 4 driver) with sap pi 7.3

Accepted Solutions (1)

Accepted Solutions (1)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

ODBC driver (type 1)  is not written in java whereas jdbc adapter is a java based adapter.  So, IMO you can do the direct integration only with type 4 jdbc thin drivers. This is my few cents. Personally I did not work on this. You might want to try jdbc odbc bridge which can be setup after your jdbc driver installation to convert the jdbc format to odbc to talk to the db server.

Answers (2)

Answers (2)

0 Kudos

As discussed below are the differences between ODBC and JDBC connections

 

•     ODBC is Microsoft drivers and uses dlls, JDBC is Java drivers and uses jar files.

•     ODBC is procedural oriented and JDBC is object oriented.

•     ODBC can't be directly used with Java because it uses a C interface.

•     ODBC makes use of pointers which have been removed totally from Java.

•     ODBC mixes simple and advanced features together and has complex options for simple queries. But JDBC is designed to keep things simple while allowing advanced capabilities when required.

•     ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in java and JDBC code is automatically installable, secure, and portable on all platforms.

•     JDBC API is a natural Java Interface and is built on ODBC. JDBC retains some of the basic feature of ODBC.

•     JDBC is Java Database Connectivity. It enables java programs to execute SQL statements. JDBC makes it possible to write a single database application that can run on different platforms and interact with different DBMS. JDBC is language dependent i.e it is used only to make connectivity with java.

•     ODBC is open database connectivity. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data so it is language independent.

•     ODBC is language independent and JDBC is language dependent.

Bhargavakrishna
Active Contributor
0 Kudos

Hi,

you want to integrate Database with PI right?

You can follow the below link to deploy JDBC drivers in PI server.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

you should download the relevant drivers, which is supported by your database.

Regards

Bhargava krishna