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

Before we begin, an important caveat:

Like the Script Server, the Document Store is an additional feature that can be enabled within SAP HANA Cloud and we should consider any resourcing requirements before enabling it. Read more here

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

From%20the%20BTP%20Control%20Center%2C%20we%20select%20our%20Global%20Account%20and%20click%20Open%20in%20Cockpit

From the BTP Control Center, we select our Global Account and click Open in Cockpit

From%20here%20we%20see%20our%20Subaccounts%20%u2013%20we%20choose%20the%20Subaccount%20where%20our%20HANA%20instance%20resides

From here we see our Subaccounts – we choose the Subaccount where our HANA instance resides

From%20our%20Subaccount%2C%20we%20click%20on%20Spaces

From our Subaccount, we click on Spaces

From%20the%20Spaces%20page%2C%20we%20select%20the%20Space%20that%20contains%20our%20HANA%20instance

From the Spaces page, we select the Space that contains our HANA instance

Click on SAP HANA Cloud

Click%20on%20Actions%2C%20then%20Open%20In%20SAP%20HANA%20Cloud%20Central

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

Click%20on%20the%20dots%2C%20then%20choose%20Manage%20Configurations

Click on the dots, then choose Manage Configurations

Click on Edit

Go%20to%20Advanced%20Settings%2C%20select%20Document%20Store%20then%20click%20on%20Save

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

Next Steps

Now that we’ve enabled HANA DocStore, what can we do next?

We can start by creating our first DocStore Collection, and getting used to how we INSERT and SELECT JSON. The DocStore Documentation is available to provide guidance here

There’s also a collection of other blog posts below which may interest you. I hope this blog post has been helpful to you, and welcome any comments or questions below