Datastores

 

A ‘datastore’ is the data model of a datamart and is prerequisite for working with datamarts.

You can define and maintain datastores in the general settings.

Existing datastores are visible on this tab. For each datastore you will see the following data:

• datastore name
• number of rows (the number of records)
• creation date
• date on which the definition or content of the datastore was last modified

Click the ‘+ Add’ button to add a new datastore.

A datastore can be edited and copied by clicking on the gear icon.

Add

Complete all fields to add a datastore.

Definition

First, you give the datastore a unique name.

Besides the unique name, for a working datastore you also need a unique column, for example customer number or transaction number. You can include this column in your dataset. If no unique column is present in the dataset then Ternair can generate a unique column for you. You define this under type.

Under description it is possible to give a description of the datastore.

Create

Next, you define the columns of your dataset.

Each datastore must have a unique ID (key). The first column name (ID) is generated automatically. The label is customizable.

Then you define the other columns. For each row you define a column name, a label (how the user sees it in the flowbuilder) and specify the type of date: text, number, decimal or date (time).

Once the column is defined, click the “check mark” icon to save the row.

Edit

Once the columns are defined, you can edit the data by clicking the edit icon.

Additional properties
By clicking on the ‘>’ icon, you can add additional properties to a column.
The red dot next to the ‘>’ icon indicates that additional properties have been created.

• Default value:
  You can assign a default value to each column. This is the value that a column gets, when no value is supplied in the dataset.
• Key type:
  It is possible to define multiple keys in one datastore. Using the dropdown menu, you can add a key type to a column.

Note! Once you have saved the datastore, you cannot change the value ‘column name’ and ‘column type’.

Delete

Note! When you delete the datastore, both the datastore and its contents are permanently deleted. This action cannot be undone.

Datalayers

Datastores can only be used through a datalayer. Read more about datalayers here.