Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
sumit_goel553
Explorer
0 Kudos

             

                                How to Deploy the JDBC Driver in PI 7.1/7.3

1) SAP-XI3RDPARTY is a Software Component, which contains wrapper SDAs for external drivers, Download the SAPXI3RDPARTY*.SCA from the Service Marketplace .Extract the SAPXI3RDPARTY*.SCA file from winrar From this you can extract the  archives for deploying the 3rd party drivers file com.sap.aii.adapter.lib.sda

2)Download the Driver jar file from the database website in my case it was oracle For oracle download from oracle website according to JDK and oracle version in your system

3) Add the ojdbc6.jar file to the lib sub-directory of the sda file com.sap.aii.adapter.lib.sda. You can look the other driver files already deployed in the same directory.


4) Edit the file provider.xml which is in the server sub-directory of the sda file and add an entry for the ojdbc6.jar file and add the entry: <jar-name>lib/ojdbc6.jar</jar-name> and save the file


*

5) Copy the updated SDA file com.sap.aii.adapter.lib.sda and copy it to the /usr/sap/trans/EPS/in directory

6) Start JSPM  using the below command:

./go "-config=/jspm/forceMode=true" "-config=/jspm/deployVersionRule=updateAll"

7) Select  the “Hot Fixes” option and click Next and Start the deployment and wait till the deployment status show deployed


8)Check whether the component is deployed open below url

http://hostname:<port>/nwa/classloader

Component type select library and search for com.sap.aii.adapter.lib

And then click on resources


Note:When deploying new drivers you should also package all previously deployed drivers, as otherwise these drivers will be overwritten

====================================================

*N.B.,

7.1+ JSPM is replaced by SUM

====================================================

Refer to Note 1138877,1829286,1770304

Labels in this area