Get started with data models data-model-beta
-View Federated Data Model
What is a data model data-model-start
A data model is a set of schemas, audiences, and the links between them. It is used to federate audiences with databases data.
In Federated Audience Composition, you can create and manage data models directly in the Canvas view. This includes adding schemas and audiences, as well as defining the links between them based on your use case.
Learn more about schemas and audiences.
For example, you can see below a representation of a data model: the tables with their name and the links between them.
Create a data model data-model-create
To create a data model, follow these steps:
-
In the Federated Data section, access the Models menu, and browse to the Data model tab.
Select the Create data model button.
-
Define the name of your data model, and select Create button.
-
From your data model dashboard, select Add schemas to choose the schema associated with your data model.
-
Additionally, you can add audiences to your data model. Select Add Audiences to define your target groups.
-
Establish connections between tables in your data model to ensure accurate data relationships. For more information, read the create links section.
-
After completing the configuration, select Save to apply your changes.
Create links data-model-links
To create links between tables of your data model from the table view tab, follow these steps:
-
Select the
-
Fill in the given form to define the link.
Cardinality
-
1-N: one occurrence of the source table can have several corresponding occurrences of the target table, but one occurrence of the target table can have at most one corresponding occurrence of the source table.
-
N-1: one occurrence of the target table can have several corresponding occurrences of the source table, but one occurrence of the source table can have at most one corresponding occurrence of the target table.
-
1-1: one occurrence of the source table can have at most one corresponding occurrence of the target table.
To create a multiple join link, select the plus icon. You can now create multiple joins between the schema fields.
-
All the links defined for your data model are listed as below:
To create links between tables of your data model from the Canvas view tab, follow these steps:
-
Access the Canvas view of your data model and choose the two tables you want to link
-
Select the
-
Fill in the given form to define the link and select Apply once configured.
Cardinality
-
1-N: one occurrence of the source table can have several corresponding occurrences of the target table, but one occurrence of the target table can have at most one corresponding occurrence of the source table.
-
N-1: one occurrence of the target table can have several corresponding occurrences of the source table, but one occurrence of the source table can have at most one corresponding occurrence of the target table.
-
1-1: one occurrence of the source table can have at most one corresponding occurrence of the target table.
-
-
All links defined in your data model are represented as arrows in the canvas view. Select an arrow between two tables to view details, make edits, or remove the link as needed.
-
Use the toolbar to customize and adjust your canvas.
- Zoom in: Magnify the canvas to see details of your data model more clearly.
- Zoom out: Reduce the canvas size for a broader view of your data model.
- Fit view: Adjust the zoom to fit all schemas and/or audiences within the visible area.
- Toggle interactivity: Enable or disable user interaction with the canvas.
- Filter: Choose which schema to display within the canvas.
- Force auto layout: Automatically arrange schemas and/or audiences for better organization.
How to video data-model-video
Learn how to create a data model in this video: