SQL transformation workflow

Key features

Modelio BA Data offers additional functionalities to Modelio BA allowing the modeling of data consistent with your relational repositories.

screen modelio sa data

Conceptual, Logical, and Physical Data Models editors

Modelio BA 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 BA Data synchronizes different levels of models to guarantee consistency at all times. Dedicated consistency checks ensure that the model is correct for data modeling.

uml data model

Automatic transformations between models

Modelio BA 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 BA 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

Generation and reverse-engineering of SQL schemas

Modelio BA 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 BA Data supports the SQL-92 standard and the following RDBMS:

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

Project documentation

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

BPMN Collaboration Diagram

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