Skip to content

Create Server Data Store

Key Lesson: In this step, you learn how to create a **Server Data Store** and configure which transactional entities are persisted to the application database.

Create a Server Data Store for the Purchasing app and add the four transactional entities created earlier as part of defining the data model.

  1. Go to Design.
  2. Select ServerDataStore under Object Types.
  3. Click +.
  4. Enter PurchaseDB and click OK.

When the editor opens, leave the following GENERAL settings at their default values:

SettingValue
STORE TYPEDataBase
USE SYSTEM DATABASEEnabled (default)
DATABASE SCHEMA NAMEsolution
CREATE DB TABLES FOR STATIC ENTITIESDisabled (default)

Under Entity configurations, use SELECT ENTITIES to select the four transactional entities created earlier:

EntitySelection
Purchasing.PurchaseRequestSelected
Purchasing.PurchaseRequestItemSelected
Purchasing.QuotationSelected
Purchasing.QuotationItemSelected

Note

After an entity is selected, it appears under CONFIGURATION. Leave the entity configuration settings at their default values for this tutorial.

Save and close the editor.

The Entity configurations section lists the entities available in the application.

  1. Add the following transactional entities to the Server Data Store:

    • Purchasing.PurchaseRequest
    • Purchasing.PurchaseRequestItem
    • Purchasing.Quotation
    • Purchasing.QuotationItem
  2. Leave all properties at their default values.

  3. Save and close the editor.

Understand how entities and relationships provide the data structure used by the application.

Learn how to configure transactional entities in the entity editor.

Understand how related entities are connected through one-to-many and many-to-one relationships.