Available from Release 5.2.0 of Onesait Platform

Introduction

The Bulk Creation From Relational Database functionality allows you to automate the process of creating OP Entities from relational databases. Until now, when you connected to a relational database, you 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.

How is it used in the Platform?

From the Control Panel, you have access from the My Entities menu option:

After entering the UI, you can see that it is divided into two zones:

• 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 you will work, and the Schema if applicable.

On the right side, you will see the 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, you can click on the "Create" button to start the Entities creation process.

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