A Data Model is an abstract model that organizes data into separate entities with defined relationships between entities. It provides users with an abstract layer of the data structure based on the Entity-Relationship Model.

Typically, a data model is composed of entities, attributes, and relationships, where entities represent the data tables in the database, attributes represent the data columns, and relationships represent the link between the data tables.

Data Model Designer

The below image illustrates the Data Model Designer.

The Entities panel on the left of the designer lists the data tables in the databases. You can select the entity to see its associated attributes and relationships. The Properties panel on the right displays the properties for the selected entity, attribute, and relationship in the model.

Supported Data Sources

The Data Model for the reports supports the following data sources:

• Oracle
• SQL Server
• MySQL
• Postgres