Easy lookup for improved data consistency
With our designer you can easily create and change the columns (also called attributes or cells) of your entities and branches without being confronted with the technical database jargon.
In several cases you want a column to be a reference to another entity, what we call a lookup column. With a lookup column users do not have to enter data in the column but simply select a value from the other entity, a method that greatly contributes to data consistency.
Creating a Lookup column in the designer happens in 2 clicks: first select the type Lookup and then select the entity you want to reference, done!
Let's talk language
Different languages are used in a company or organization and therefore a modern application should not be limited to one language.
The multilingual capabilities of our solution, whose user interface is currently available in 8 languages, extend beyond the user interface.
You can enter a caption or description in all the languages you have selected from the language list for all columns of the entities and branches which strengthens the adoption by and usability for your users.
Simplicity and recognisability
Working with a cloud application does not mean that you have to train your users in a completely new user interface.
Our applications apply current style guidelines to create a user experience that is easily recognizable but also free from unnecessary options and unused functions and where actions are displayed with familiar icons.
Attention is also paid to easy editing of data with or without a keyboard and with full column sorting, filtering and selection capabilities, just like an installed desktop application.
Data-driven security
Defining security so that users have access to the right data within their area of responsibility is a challenging task. The responsibilities arise from the business rules and do not coincide with the technical layout of a database. Granting the classic update or read rights to a table, entity or Excel worksheet is insufficient for this.
That's why we provide data-driven security that makes it possible to assign users' rights according to their area of responsibility by restricting users' access to a specific set of data based on your own values. These restrictions also apply during (hierarchical) lookups into other entities. For example, you can restrict access to one or more countries, departments, brands, groups, categories, etc. and these restrictions will apply across all tables or entities automatically.
Branches, a unique feature
Branches are a unique feature to create Clones, Archives, Change Sets and Extensions
- A change set allows you to enter changes and mark rows for deletion but only update the data in the entity after validation.
- Extensions allow you to enter data which is additional to an entity and which only applies to a part of your organization, such as data related to country or region, data specific to a department or a brand or data specific to another connected database or application.
- Extensions can also be used to prepare the introduction of new data that you do not yet want to distribute within the organization and which you then merge with the entity at the appropriate time.
- A clone can be created with or without copying the data from the entity. A clone always maintains the same structure as the entity but has its own data.
- An archive is created by copying the entity structure and its data. An archive cannot be modified, neither its structure nor data, so it is an ideal way to create "versions" - immutable snapshots - which are indispensable for compliance, audit and legal requirements.
Compare editions and explore our complete features list
Explore