How To Connect SAP Cloud for Real Estate to SAP Datasphere

[D059835]

SAP Intelligent Real Estate

This post will guide you through the steps to connect your SAP Cloud for Real Estate API published by the SAP API Business Hub for Cloud for Real Estate to your SAP Cloud for Real Estate standard content available in SAP Datasphere via SAP Data Intelligence Cloud.

******************************************************************************************************

As long as SAP Datasphere does not support REST API (will probably supported in near future) I decided to realised it in my real life customer scenario with SAP Data Intelligence Cloud where this blog post is focused on. I think this is (as by now) a very convenience way to do so.

I am also fully aware that there are a lot of more option to push your SAP Cloud for Real Estate data to SAP Datasphere.

******************************************************************************************************

Prerequisites are:

• You have already enabled your SAP Cloud for Real Estate API on SAP Business Technology Platform (SAP BTP) to get your individual OAuth2 token by creating your service key.


• You have a running instance of SAP Data Intelligence Cloud (by now you need this extra instance until SAP Data Intelligence Cloud is fully integrated into SAP Datasphere) in your SAP BTP to create and run pipelines to create tables initially in SAP Datasphere and push data from your SAP Cloud for Real Estate API.


• You have a running instance of SAP Datasphere.


• You created a database user in the SAP_CONTENT Space in your SAP Datasphere system. This is the data entry layer to which you connect SAP Data Intelligence pipelines and write data into the corresponding tables.


• You have imported and activated the Business Content for SAP Cloud for Real Estate in SAP Datasphere via Content Network.


• You have basic experiences in SAP Data Intelligence Cloud, Python, JSON and consuming RESTful APIs.

Steps are:

1. Create an inbound connection in SAP Data Intelligence Cloud from your SAP Cloud for Real Estate API.


2. Create an outbound connection in SAP Data Intelligence Cloud to your SAP Datasphere instance.


3. Create tables in your entry layer of your SAP Datasphere. You can do it via SAP Data Intelligence Cloud and pipelines or directly on your database schema via Database Explorer.


4. Create a Python custom operator to get and parse data from your API and push them to your SAP Datasphere instance, specially in your SAP HANA Cloud schema of your database user, created before.


5. Create pipelines for each entity you want to extract and push to the tables in your entry layer by using your Python custom operator, created in step 4.


6. Manage your inbound and outbound connection of your custom operator in each pipeline.


7. Run your pipelines and enjoy our data!

Git repo: I have already prepared those SAP Data Intelligence Cloud pipelines to manage your full ETL process in detail and want to share my solutions (pipelines and a python custom operator) by exporting a SAP Data Intelligence Cloud "solutions" in my personal Git repo but - please aware - without any further support! There, you will find any further steps and guidance to import and configure those pipelines.

Enjoy your data!