Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Jitendra_Kansal
Product and Topic Expert
Product and Topic Expert
0 Kudos
1,185


Hello SMP Administrators,

 

Do you want to expose database information into OData services? Integration gateway will help you. It will convert the data coming from the database to OData. As SMP is based on OSGi, you can not directly deployed JDBC driver to SMP server, it has to be OSGi enabled jar package.

 

There are two different ways to convert JDBC JAR to OSGi JAR:

 

1.  Eclipse plug-in development

2. Command line approach >> Limited to Oracle, SQL server & DB2 drivers

 

I will explain only 2nd approach:

 

In this example, i want to create an OSGi enabled bundle which includes Microsoft JDBC driver for SQL server.

 

Steps followed:

 

1. Copy driver jar file to a temporary folder (SMP server should be installed on same machine)

2. Navigate to this path: C:\SAP\MobilePlatform3\Server\tools\dbconfig

3. execute below command

 
F:\SAP\MobilePlatform3\Server\tools\dbconfig>create_jdbc_bundle.bat -sqlserver C:\temp\sqljdbc4.jar

 



 

You will see a new OSGi enabled jar file has been created in the mentioned folder.

 



 

4. Copy this new jar file and paste in PICKUP folder and make sure that you see an "OK" message under .state folder

 



 

As mentioned already,  there are only 3 supported drivers: SQLServer, Oracle & DB2.

 

-sqlserver

-oracle

-db2

 

So for other databases like SAP HANA, SAP ASE, SAP SQL Anywhere, HSQLDB, MYSQL you can not use above command line method to generate OSGi enabled jar file. You have to go with Eclipse plug-in development

 

Inputs taken from SAP Note 2146914 and big thanks to andreas.wegmann for providing extra information.

CC: SAP for Mobile

Regards,

JK