Bulk creation from a relational database

Owned by Onesait Platform
Last updated: 10/04/24
3 min read

Since version 3.1.0-KickOff, Ontologies have been referred to as "Entities" in the Control Panel. This does not alter any functionality; the nomenclature has simply been changed for a better understanding of the concept.

Available since version 5.2.0-TopGun.

User Interface: 5.3.2-Ultimate

Introduction

The bulk Entity creation functionality from a relational database allows you to automate the process of creating Entities from relational databases.

Until now, when we connected to a relational database, we had to create Entity by Entity, while now you will be able to create several Entities at the same time, thus avoiding repeating the creation process for each Entity, saving a lot of time to the user.

Steps

Create the Entity

From the Control Panel, navigate to the Development > My Entities menu.

image-20240403-142732.png

This will take us to the list of available Entities. To create the Entity, click on the "+" button at the top right of the screen.

image-20240227-121951.png

From the different Entities that we will be able to create, we will select the "Bulk creation from a Relational Database" one:

Connection and selection of tables

After clicking on it, we will access the user interface, where we can see that it is divided into two areas:

  • The upper area allows you to select the tables from which you want to generate an Entity.

  • The lower area is used to add permissions to users on the entities you generate.

The first thing to do is to select the database on which we are going to work, and the data schema if applicable.

On the right side, we will see the available tables of that database and the schema.

  • You can select the tables individually, or you can select a set of tables.

  • By default the entity name will be: TABLE_NAME_DOMAIN.

  • You can also change the name of the entity created from this table.

  • The ID of the entity will be the Primary Key of the Table. You can select from the fields in the table.

At the bottom, you will be able to select the users to whom you will grant permissions on the created entities and what type of permissions you will grant.

Once the tables have been selected and the permissions have been granted to the users, we can click on the "Create" button to start the Entity creation process.

When finished, you will return to the list of entities where the new entities will be created.

A window will then be displayed with the available options to be performed with the Entity created.

Clicking on the "Close" button will take you back to the Entities list, where the newly created Entity will appear.