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.
- 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.
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.
Approval workflow
An approval workflow that validates all changes to the data is essential to ensure the correctness of the data.
One can choose, down to entity level, for a workflow based on a single approver or on the four-eyes-principle.
The approval process is performed by designated users, and it is important to note that a user can never approve his or her own data entry changes.
The approval process supports the necessary actions like approve, reject, resubmit, forward and so on. A complete log of all approval actions is stored per row or record.
Long-term data retention
In order to comply with all legal provisions and audit rules, we provide for long-term retention periods of supporting data for up to 10 years.
For the audit trail log files, this means that you have a detailed log of all changes in the database going back up to 10 years.
Database backups are stored using the following frequency: daily backups for 7 days - 35 days with the extended backup feature - monthly backups for the past 12 months and yearly backups - taken on the first week of the year - for up to 10 years.
Hierarchical or sequential filtered lookups
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.
When you want to restrict the list of possible values for a column based on the value of another column - as for example only allow the cities for a selected country or the categories for a selected group - then you simply assign the first column as a filter for the second column.
With our hierarchical approach you can repeat this for multiple levels, for example, Region > Country > City or Brand > Category > Group.
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.
Compare editions and explore our complete features list
Compare