SAP PaPM Cloud: Let us talk about Integration

Hi Everyone,

2021 is almost ending, and SAP Profitability and Performance Management made sure to leave a memorable mark by releasing the Cloud version. From the time it got released in May until this moment, we are very pleased by your curiosity towards this solution, which fueled us, experts, to write informative blogpost about it too — week after week after week. . . .

As one of my final blogposts this year concerning SAP Profitability and Performance Management Cloud (SAP PaPM Cloud), let me quickly answer an important question you have concerning the integration between SAP PaPM OP & SAP PaPM CLOUD.

What can serve as the bridge between my two SAP Profitability and Performance Management Solutions?

As SAP Profitability and Performance Management Cloud has SAP HANA Cloud as its underlying database, seemless connection to several sources and databases has been easier. Hmmm, what made me say that?

If you are not yet aware, SAP HANA Cloud and SAP HANA have these data accessing methods offered such as Smart Data Access (SDA) and Smart Data Integration (SDI) which are both capable to not just access SAP datasources but also made it possible to access even non-SAP sources and databases.

Since these methods are fully established and have several blogposts already, instead of me showing you how to create connections, let me share with you instead the documentations published by experts that helped me learn how to set SDA/SDI properly.

• SAP HANA Smart Data Access
• SAP HANA Smart Data Access(1): A brief introduction to SDA
• The various Data Provisioning Options for Hana
• SAP HANA Smart Data Integration
• Hana Smart Data Integration – Overview

Also I have bumped into these nice step-by-step instructions prepared by SAP

• Use Smart Data Access to Virtualise Data from the Cloud to an On-Premise Database
• Use Smart Data Integration to Virtualise Data from On-Premise to the Cloud

After these collection of articles and documentations, I trust that you are now fully confident with connecting your On-Premise Datasources to Cloud?

PERFECT!!!!

So we just answered the initial question, didn’t we?

What can serve as the bridge between my two SAP Profitability and Performance Management Solutions?

Answer: Smart Data Access as it performs both buffering and real-time replication, then incase for any reason this option is not available for the source you are connecting into then Smart Data Integration should be used.

Since the holiday spirit is in the air, aside from answering above question, let me give you a bonus tip and trick on how I will do the connection from setup to reading in the modeling screen of PaPM Cloud. (This is just one example on how you can do it)

1. Login as Admin to the underlying SAP HANA Cloud Database of SAP PaPM Cloud.
2. Create SDA or SDI Connection pointing to the underlying database of SAP PAPM 3.0
3. Create a HANA View for the SDA/SDI datasource you want to access, to make the data accessible to SAP PaPM Cloud
4. Ensure that the default schema of SAP PaPM Cloud is then having the rights to read on the HANA View from Step 3.
5. Consume this HANA View via Administrations > Connections in SAP PaPM Cloud.
6. In the modeling screen of SAP PaPM Cloud create a Model View Hana View and successfully consume the data

I hope this mini blogpost helped you be more comfortable in making your On-Premise data accessible to SAP Profitability and Performance Management Cloud. Thank you for visiting my blogposts this year and for continously suggesting topics that will be interesting for our community.

In case we dont meet anymore this year, I wish you all Happy Holidays and stay safe.

See you again soon!!!