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 can create several entities at the same time, thus avoiding repeating the creation process for each entity, saving the user a lot of time.

How is it used on Platform?

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

Open

After entering the UI we can see that it is divided into 2 areas:

Tras entrar en la UI podremos ver que esta dividida en 2 zonas:

Open

• 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 you must do is 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 on the contrary you can select a set of them.

• By default the name of the entity will be: DOMAIN_NAME_OF_THE_TABLE.

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

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

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 permission you will grant.

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

Upon completion, it will return to the list of entities where the new entities created will be.