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: 
kc_kristris
Active Participant
SAP’s BTP services enable customers to engage and experience rich digital business. Integration suite capabilities can be further leveraged to build cost-effective robust solutions. In this blog we will connect BTP Services here, HANA DB with Cloud Integration (a.k.a. CPI).

Prerequisite (exploring through BTP trial account):

  • Account in BTP Cockpit

  • Access to Cloud Integration Tenant (refer how to setup Cloud Integration tenant)


Steps

  • Activities in BTP Cockpit

    • Create an instance – “SAP HANA Cloud”

    • Setting HANA DB credentials (to be used later to access the DB)

    • Create table & Insert data (to be fetched through Cloud Integration scenario)



  • Activities in Cloud Integration

    • Establish DB Connection in Cloud Integration (Overview -> Manage JDBC Material)

    • Design custom i-flow to fetch records from the DB









  • Add “HANA Cloud” service



 

  • Create Instance



                Database Name: DBADMIN

                Password: ****** (Give Password)

               Copy the host name. These details are required to configure JDBC connection in CPI (later                 in the steps).


 

  • Create table & insert entries





  • Setting DB Connection in Cloud Integration - Overview -> Manage JDBC Material


Click "Add"


 




  • I-flow (Based on the business scenario the i-flow can we tweaked)

    • We are passing the select query in the body of the 1st content modifier.

    • JDBC Channel

    • Storing the response in 2nd content modifier (just to see the output in trace)




          Note: Run the i-flow in trace mode to see the response payload

 


Here, we are selecting the fields from the HANA DB table. For other operations we need to            pass the XML SQL in the message body.

 

  • JDBC Data Source Configuration


Pass the user: DB user created above

Password: Assigned above

JDBC URL: “jdbc:sap://<hostname>:<port>/?databaseName=<database-name>&encrypt=true“

Sample e.g. jdbc:sap://asdfabcd-b424-4b96098678.hana.trial-eu10.hanacloud.ondemand.com:443/?databaseName=H00&encrypt=true

 

  • Output




With this we are able to create an instance of HANA DB, Designing DB schema & at last Connected HANA DB through Cloud Integration.

Any question or feedback will be appreciated!
Labels in this area