SAP PI has to access DB using OLEDB drivers

[Former Member]

Hi All,

My client is exposing their database through OLEDB provider to outerworld.

They have provided me the IP, username and Pwd details but not the OLEDB drivers.

Could you please suggest the OLEDB drivers that I have to install in SAP PI inorder to access the database through our JDBC channel.

Thanks,

Nida

[arunneerolil]

Nida,

Which database are you using ?

JDBC and OLEDB are different technologies for DB connectivity.

SAP PI JDBC adapter supports only JDBC drivers for DB connectivity.

Refer SAP Note 1138877 - How to Deploy External Drivers JDBC/JMS Adapters

You will have to use the JDBC driver files for the database version.

Almost all the databases supports JDBC drivers.

The driver files are available with the DB setup.

It can also be downloaded from the DB vendor sites.

Regards,

Arun

[Former Member]

Hi Arun,

Client has suggested us to install OLEDB drivers on PI.

Could you please provide me the link where I can get the OLE db driver.

[arunneerolil]

Nida,

Which database do you want to connect to ?

As I mentioned earlier you will have to look for a JDBC driver for the database for configuring it in PI.

Regards,

Arun

[Former Member]

Hi Arun,

Database is SQL server 2012.

Please guide from where can I get drivers for SQL Server 2012.

Thanks,

Nida

[former_member184720]

Driver Location :

Download Microsoft JDBC Drivers 4.2 (Preview), 4.1 and 4.0 for SQL Server from Official Microsoft Do...

[Former Member]

Hi Hareesh,

I have tried this link but there are multiple files provided in download.

I am not sure which one to use. Please suggest.

Thanks,

Nida

[arunneerolil]

Hi Nida,

Download the latest MS SQL driver 4.2 file from the link

sqljdbc_4.2.6225.100_enu.exe

Use the jar file >> sqljdbc42.jar once you unzip the same.

This jar file has to be configured as an external driver in the PI system before using it in your JDBC adapter.

Regards,

Arun

[Former Member]

Hi Arun,

Tried the above process in DB visualizer but it failed saying driver class not found.

Regards,

Nida

[arunneerolil]

Hi Nida,

I have never used DB visualizer.

You can deploy the driver to PI server and connect to the SQL 2012 DB using JDBC adapter.

If you want to test the JDBC driver before deployment, use a simple java program as in the below link.

https://msdn.microsoft.com/en-us/library/aa342339(v=sql.110).aspx

regards, Arun

[RaghuVamseedhar]

Nida,

Please search 'OLEDB driver' and download driver. Then install the driver

External Driver Configuration in Process Integr... | SCN