/
Bulk Generation of Entities on Relational Databases

Bulk Generation of Entities on Relational Databases

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:

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:

  • 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.

 

Related content

Creación bulk desde una base de datos relacional
Creación bulk desde una base de datos relacional
Read with this
Bulk creation from a relational database
Bulk creation from a relational database
More like this
Creation from a relational database
Creation from a relational database
More like this
How to create a Presto Entity
How to create a Presto Entity
More like this
Step by step creation
Step by step creation
More like this
Creation of an Entity in a historical database
Creation of an Entity in a historical database
More like this