Skip to main content

Via the interface

To create a custom table, go to the Table structure app (Catalog > Data > Tables structure).

Tables data structure

tip

It is also possible to directly create a table from the Datamart Studio, via the top right button.

Shortcut

To begin, click on the "Create table" button.

Create table

There are two options available:

  • Creating a table from a template
  • Create your own table structure

Choosing the template​

The "Create table" button will lead you to a page divided into different tabs representing each type of table.

Choosing the template

From each tab, you will be able to choose among one or more templates provided by Actito.

  • The Event and Simple orders templates for Interactions tables
  • The Children, Loyalty, Sponsorship and Vouchers templates for Linked Data tables
  • The Companies, Product catalog, Stores and Subscription catalog templates for Repository tables
  • The e-Retail, Retail and Subscription orders templates for Multi-tables

You can also retrieve the definition of these tables using the blue button.

See the JSON

From the screen that opens, you can view the table definition or download it to get a ready-to-use JSON example that you can modify.

Download the JSON

For more information about the predefined fields and the use cases of each template, please read the page on "Using a JSON Template".

Creating the table​

Choose your template, then click on "Select".

By default, the table will take the name of the template, but you can choose to rename it.

For Interactions and Linked Data templates, you will have to select the profile database to which the table must be linked.

Click on "Save" and the table will be created immediately. It will use the technical attribute "profileId" as link with the profile database.

General Data

For Repository templates, the link with the profile table must be made afterwards (see below).

Linking a Repository table to a profile table​

In order to build this link, it is necessary to add a new attribute in your profile table (to do so, please read "Adding an Attribute to the Profile Table")

At the second step (Value type), select the "Datamart" button as Restriction type in the Value restrictions section.

You will be able to select your Repository Custom Table in the drop down menu.

Linking a Repository table to a profile table

Follow up with the attribute creation to confirm this link.

In the profile file, the value taken by this attribute will be the primary key used to identify an entry of the Repository table ("businessKey").