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: 
JerryWang
Advisor
Advisor
3,602
There are two approaches to manipulate HANA database instance in SAP Cloud Platform:


1. Use SAP HANA Web-Based Development Workbench provided in SCP cockpit






2. Directly operate on Cloud database in Eclipse with help of Cloud Connector


Switch to Data Source Explorer view in Eclipse, and create a new Connection Profile:




Profile type: Generic JDBC




Maintain Properties as below:





  • Connection URL


You should maintain service channel url created in Cloud Connector.


It means you need to first create a service channel in Cloud Connector and point it to the HANA database instance in SCP. Details please refer to my blog Use JDBC to connect to HANA database instance in SAP Cloud Platform



  • Database Name


Fill the HANA database instance ID in SCP.


  • Driver Class


com.sap.db.jdbc.Driver



  • JAR List


you can download from this url.




Once done, you could directly use Eclipse to browse HANA database instance in SCP.