SUP+HANA


Steps to configure SUP to connect to HANA Database

1. Download HANA client and install \Use the ngdbc.jar from  c:\program files\sap\ for 64 bit install or the corresponding folder for 32 bit
2 Follow the below steps. Connecting t HANA requires 2 major steps as described below


First you need to add the connection to the Sybase Control Center (SCC)

1. Copy the ngdbc.jar file (HANA JDBC connector) into the \UnwiredPlatform\Servers\UnwiredServer\lib\3rdparty directory.
2. Stop and Start the SUP Platform services
3. Launch the Sybase Control Center (SCC)
4. Open up Connections in the Unwired Server Cluster Management View
a. Located under -> Domains -> default -> Connections
5. Click the New button
6. Select JDBC in the Connection Pool Type drop down
7. Use the DB2 template
8. Enter in the JDBC connection information
9. Click Test connection


After the connection has been made you then need to add the connection in you SUP Mobile SDK (Eclipse IDE)

1. Copy the ngdbc.jar file (HANA JDBC connector) into the \UnwiredPlatform\Eclipse\endorsed directory.
2. In the Mobile SDK right click on Database connections in the Enterprise Explorer section and choose New
3. Select Generic JDBC and add a Name
4. Click the New Driver Definition icon
5. Select the Generic JDBC Driver
a. You can change the name if you want
6. Click the Jar List tab
a. Click Add JAR/Zip and browse to the ngdbc.jar file that you copied to the \UnwiredPlatform\Eclipse\endorsed directory.
7. Click the Properties tab
a. Enter in your HANA JDBC connection info
8. Click Ok

Comments

Popular posts from this blog

How to create Component-preload.js files for Fiori Applications

How to create a new user in Open DS LDAP server for Sybase Unwired Platform

Building Cost Effective Enterprise Mobile Applications