Configuring and Designing Data Store Schema

The Data Store (DS) is a flexible, fully indexed cloud database with a dynamic schema designed to store generic data objects. It's designed to handle data that doesn't fit neatly into traditional, structured databases. This flexibility is crucial for modern applications that require handling diverse and evolving data.

Key Features of the Data Store:

• Dynamic Schema - You don't have to know in advance how your data will look; it doesn't have to look the same for all objects. You may store any data you have with no constraints on its structure. There is no need to go through schema creation or modification when the data structure changes.
• Fully Indexed - No matter what data you send, you can always search based on any combination of stored fields in that data. You don't have to know what your queries will be or create the appropriate index in advance. An example of such a search: get the email addresses of all U.S. users who graduated from any university between 2000-2005.

For more information, refer to the Data Store documentation in the SAP Help Portal.

The Data Store is ideal for storing large datasets or data that may grow significantly over time.

• Customer Transaction Data: Store customer transaction data from a commerce storefront such as purchase history, order details, and other transaction-related information. This allows you to analyze purchase patterns, identify top-selling products, and personalize marketing campaigns.
• Customer Behavioral Data: Capture customer behavioral data, such as clickstream data on a media service site. This data can be used to understand user engagement, optimize website design, and improve user experience.

The DS stores JSON data objects, including full support for embedded objects and arrays. Different objects can contain different data fields. Each object has a unique Object ID ( oid ). You can retrieve an object by specifying its oid. Objects are grouped by type for easier look-up and logical separation. Object types do not impose a schema. They are just used for the logical separation of the data. See below for restrictions regarding client-side use of data objects.

When designing your Data Store objects, consider the following:

• Object Structure: Use JSON format to structure your data, leveraging embedded objects and arrays as needed.
• Object ID (oid): Ensure each object has a unique ID for easy retrieval.
• Object Type: Group objects by type for logical separation and easier lookup.

In this video, you will explore how to customize the Data Store within SAP Customer Data Cloud. We will demonstrate how to use the Schema Editor to create a custom object type and define its associated fields.