Sunday, 8 January 2023

SAP HANA Cloud Document Store – Enabling JSON Document Store

Introduction


SAP HANA has well known Row and Document Stores, allowing us to store relational data in Tables and process that data using HANA’s various engines including graph and spatial

SAP HANA actually offers a third store – the JSON Document Store. With the SAP HANA Cloud Document Store (DocStore), we can store JSON Documents in Collections within HANA itself, then process that data using the same SAP HANA engines

Navigate to SAP HANA Cloud Central


When we’re ready to enable HANA Cloud DocStore, we’ll need to navigate to SAP HANA Cloud Central within BTP

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
From the BTP Control Center, we select our Global Account and click Open in Cockpit

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
From here we see our Subaccounts – we choose the Subaccount where our HANA instance resides

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
From our Subaccount, we click on Spaces

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
From the Spaces page, we select the Space that contains our HANA instance

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
Click on SAP HANA Cloud

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
Click on Actions, then Open In SAP HANA Cloud Central

Enabling SAP HANA Cloud Document Store


From within HANA Cloud Central, we can now activate the Document Store

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
Click on the dots, then choose Manage Configurations

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
Click on Edit

SAP HANA Cloud Document Store, SAP HANA Exam, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation
Go to Advanced Settings, select Document Store then click on Save

Once our HANA Cloud instance has restarted, we’ll be able to use the Document Store functionality

No comments:

Post a Comment