Creating Data Model

Data model allows to define in what form the data will be stored in the system, i.e. to specify the structure of data created in the system, as well as their properties.

A data model consists of a number of related objects and can be created in 2 ways:

  • Through the user interface;

  • Via XML file.

Before you start:

  • Create an account with superuser rights or access to the "Data Model" section. Access to sections is configured for the role that is subsequently assigned to the account.

Via User Interface

To create a data model:

  1. Create a draft and enable the draft mode.

  2. Create the data model object: entity or reference set with the necessary parameters.

  3. Publish the data model draft upon completion.

If necessary:

  • Specify source systems and their trust level for loading data from third-party systems.

  • Create nested objects for use in attributes of entities/reference sets.

  • Create measurement units if you need to convert values of different currencies, systems of measures and weights.

  • Create enumerations to have an ability to select values of record attributes from the list.

Creating draft

Figure 1. Creating draft

Creating data model object

Figure 2. Creating data model object

Via XML

  1. Create xml files describing data model elements or edit existing ones by exporting the existing data model.

  2. Import new xml files.

When editing data model, be sure to re-index the data. Otherwise there may be conflicts in the data structure.

Export screen

Figure 3. Export screen

Import screen

Figure 4. Import screen