on 06-15-2013 10:59 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you want to integrate Database with PI right?
You can follow the below link to deploy JDBC drivers in PI server.
you should download the relevant drivers, which is supported by your database.
Regards
Bhargava krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.