Connect Business Objects On-Premise to HANA Cloud Platform

[uladzislau_pralat]

HANA Cloud Platform can be used to implement different extensions. Some extension scenarios will save data in HCP HANA that you might need to reports on and analyse. Primary tool for that is Business Objects Cloud, but you still can use Business Object On-Premise. All you need to do is to connect Business Objects On-Premise to HCP using HANA Cloud Connector. In my blog I will explain how to do that.

 

In my demo Flight data is replicated from SAP NetWeaver to HCP HANA. HANA Modeling capabilities are used to create calculated views consumed by Business Objects on-premise. It similar to OpenSAP course Extending SAP S/4HANA with SAP HANA Cloud Platform scenario with some changes:

• Business Object On-Premise is used instead of Business Object Cloud


• NetWeaver CAL system is used instead of NetWeaver on Lunix VM


• SFLIGHT is used instead of EPM data

I added screenshots wherever configuration is different from OpenSAP course

These are configuration steps:

1. Create SAP NetWeaver 7.50 CAL system

2. Download and install HANA Cloud Connector on SAP NetWeaver 7.50 CAL system Front End

3. Prepare HANA Cloud Platform Account

4. Connect HANA Cloud Connector to HANA Cloud Platform



Note: external and internal IP addresses of a machine where HANA Cloud Connector is installed will be used later

5. Create HANA database in HCP and Create HANA Database user



6. Set up Service Channel in SAP HANA Cloud Connector



6. Set up replication between SAP NW and HANA in HCP





7. Create Table Function and Calculation Views in HANA HCP





Source code can be downloaded from here:

GEOGRAPHY.hdbtablefunction

TRAVEL_CARR.calculationview

TRAVEL_CUBE.calculationview

TRAVEL_TIME.calculationview

8. Create Business Object 4.2 SP3 system

9. Connected Business Obects On-Premise to HCP HANA



Note: Server and Port are from step 3 and step 5

10. Create Webi report connecting to HCP HANA



Both HANA_HCP Connection and Webi document can be created from linked lcmbiar file

Travel.lcmbiar