SQL transformation workflow

Key features

Modelio SA Data offers additional functionalities to Modelio SA allowing the modeling of data in coherence with your relational repositories.

screen modelio sa data

Conceptual, Logical, and Physical Data Models editors

Modelio SA Data supports:

  • standard UML and dedicated diagrams to help master data models
  • dedicated editors for persistency modeling and physical SQL schema design

This provides data designers with the level of abstraction or precision they require to generate the appropriate data schemas.

Modelio SA Data synchronizes different levels of models to guarantee permanent consistency. Dedicated consistency checks ensure that the model is correct for data modeling.

uml data model

Automatic transformations between models

Modelio SA Data supports data modeling using UML. This enables business analysts to start data modeling activities during business analysis, combining it with other business modeling activities (BPM, architecture, and so on) using the integrated UML and BPMN modeling support.

Modelio SA Data will then transform models into persistent class diagrams, where the model will be further annotated for persistency purposes. Finally, this model can be transformed to an SQL table diagram to generate SQL schemas.

SQL model transformation

SQL schema generation and reversal

Modelio SA Data boosts productivity and quality by generating database schemas from high level models. It helps:

  • understand and modernize current database schemas,
  • raise their abstraction level to carry out business analysis.

From your existing databases, Modelio rebuilds the corresponding model, linking the enterprise architecture to already defined data.

SQL generation reverse

Supported SQL standards

Modelio SA Data supports the SQL-92 standard and the following RDBMS:

  • MySQL
  • Oracle
  • SQL server
  • PostgreSQL
  • DB2/AS400
SQL SGBDs

Project documentation

Because one of the main purposes of a model is to help in communication, it is often necessary to document the design of data structures. Modelio SA Data provides automatic generation of documentation from models.

Documentation de projet

Need more information? We can help you

Please fill out this form and we will get back to you rapidly or you can email us directly (This email address is being protected from spambots. You need JavaScript enabled to view it.) or call us at +33 1 30 12 18 40.

Please complete all fields

To know and exercise your rights, including the withdrawal of your consent to the use of the data collected by this form, please consult our legal notice.

A tailor-made service offer