Install MS SQL JDBC driver on PI7.31 Java stack only.

[Former Member]

Hi all,

I have downloaded sqljdbc_4.0 from Microsoft  and now My question is How can I deploy this JDBC drivers to PI 7.31 system?

Can anyone help me ? Your help would be greatly appreciable.

Thanks.

[former_member378621]

Hi Where did you downloaded the sqljdbc4 file. I'm looking in Microsoft website but not able to find it. Could you please advice as we have to use this file to connect to external database from our PI system.

[Former Member]

Hi All,

I have raised this issue with SAP, They recommended the following notes:

#639702 - JDBC Driver for Microsoft SQL Server

#1145221 - JDBC driver exchange to Microsoft JDBC Driver

I have followed the note 639702 and installed driver, But still am getting the error.

According to SAP Note 639702,

We have installed MSSQL JDBC drivers in our PI Dev. system.

1. Downloaded latest drivers from Microsoft website

http://msdn.microsoft.com/en-gb/sqlserver/aa937724.aspx

1. Copied downloaded Zip file to PI location /usr/sap/PID/SYS/exe/uc/linuxx86_64/
2. Stop the SAP system
3. To install followed steps mentioned in Install
   file located in JDBC  Driver Zip file
4. i.e. To
   unpack the zipped tar,

               gzip -d sqljdbc_<version>_enu.tar.gz

    Tounpack the tar, move it to the directory where you want the driver

   installed and type:

               tar -xf sqljdbc_<version>_enu.tar

5. After unpacking the tar file it created a new directory SQLJDBC4.0 where we can see all sqljdbc jar files.

6. Start the SAP system

But still am getting the same error:

Can anybody help me with this?

[AnilDandi]

Hi

You can use SDA maker tool to build and include sqljdbc jar file in com.sap.aii.adapter.lib.sda file. You can also get this sda file by following the steps in SAP Note 1770304.

Ensure that the jar file is compatible with SAP JVM used in your PI system.

Then com.sap.aii.adapter.lib.sda can be deployed on the PI 7.31 system just like any other sda file.

regards

AKD

[gagandeep_batra]

Hi,

Can you remove the file sqljdbc.jar from the  folder and only sqljdbc4.jar  is enough.

Regards

GB

[patelyogesh]

What is your SQL server name?

[Former Member]

Hi,

Please see the links below.

Regards,

Jannus Botha

[Former Member]

I have seen this document External Driver Configuration in Process Integration 7.1 Using JSPM

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4...

But, I didn't undesrtand how can I Add the Driver Jar file to .SDA file & Edit the Provider.xml file

Is it different process in PI 7.31?

[Former Member]

Hi,

You find com.sap.aii.adapter.lib.sda in directory DATA_UNITS\JAVA_J2EE_OSINDEP_J2EE_INST on your SAP NetWeaver 7.10 PI Java installation DVD.

Regards

Venkat