JDBC driver for Ms sql server 2016

[former_member735330]

Dear Experts,

We have installed SAP PI 7.5 running on SUSE Linux 15, DB :ASE 15.0 , We are trying to install JDBC drivers for connecting the thirdparty application which is having MS SQL server 2016 as database. Following are the steps which we followed for installing the drivers:

1. We downloaded sqljdbc_9.2.0.0_enu.tar.gz from microsoft website.

2. We have followed the steps given in the below link https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/1433/actions/17943 (how to install the external drivers for AXIS/JDBC/JMS adapter)

3. We user SUM tool to deploy the com.sap.aii.adapter.lib.sda file, but it is rejecting the component.

Please help us to identify which JDBC driver needs to downloaded from microsoft link so that we can install for connectivity.

Regards,

Raksha.

[bijayashreebanoj_brahma]

Hi Raksha,

I am not clear what you are trying to do.

1) If you are trying to update your XI3RDPARTY version, then its different story.

2) If you are trying to update your "com.sap.aii.adapter.lib" version (which I saw in your post), then you can go with required higher version as per your requirement.

To achieve this, you can download corresponding SCA file and un-zip the file and create new SDA file, from SDA file present after un-zipping from SCA file, using tool described in my blog.

But remember every time you modify SDA file to create new, the version changes in

META-INF file of newly created SDA file as below and later on you can't downgrade.

Implementation-Version: 7.5007.20170224131921.0000

Implementation-Version: 7.5007.20170224131921.0001

Implementation-Version: 7.5007.20170224131921.0002

3) If you want to add extra jar files to exiting "com.sap.aii.adapter.lib", then ask basis team to provide you, already deployed file and you can add your jar files using tool. If Basis does not have the deployed file, then you need to download exact version of "com.sap.aii.adapter.lib", deployed in your system (not the version of your XI3RDPARTY). Then you create new SDA file described in my blog.

Thanks,

Bijayashree

[former_member735330]

Hi Bijyashree,

Thanks for the information, Please let me know how and where to download the required version of com.sap.aii.adapter.lib.sda (without SAP-XI3RDPARTY.SCA). I have the below deployed current version in my PO system:

7.5000.20150910153728.0000

Regards,

Raksha

[former_member735330]

Hi,

I have already gone through with the step provided.

I am facing below issues:

I have downloaded the latest SAP_XI3RDPARTY SCA file (SAPXI3RDPARTY20_0-80000870.SCA) and while using SUM to deploy it I am getting below error:

Rejected ComponentsSUM has detected that the following components are not eligible for deployment. Optionally, revise the components in the download directory, and then rescan it.
Note that if you leave them as they are currently, the SUM will not deploy these components to the system. com.sap.aii.adapter.lib.sda sap.com/com.sap.aii.adapter.lib Component sap.com/com.sap.aii.adapter.lib cannot be downgraded.
System version: 7.5000.20150910153728.0000
Archive version: 7.5000.20150610001139.0001

Regards,

Raksha Shah

[former_member735330]

It worked after making changes in com.sap.aii.adapter.lib.sda file and again added the file in SAPXI3RDPARTY19_0-80000870.SCA and using SUM I have directly deployed SAPXI3RDPARTY19_0-80000870.SCA file.

Regards,

Raksha

[S_Sriram]

Hi Zubin.

You can search in google to find so many links, refer the follwoing blog it may help you

https://blogs.sap.com/2020/05/05/how-to-deploy-external-jms-and-jdbc-drivers-in-sap-po-7.5/

Regards

SS