Get started with data models data-model-beta

AVAILABILITY
To access data models, you’ll need one of the following permissions:
-Manage Federated Data Model
-View Federated Data Model
For more information on the required permissions, please read the access control guide.

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.

{modal="regular"}

Create a data model data-model-create

To create a data model, follow these steps:

  1. In the Federated Data section, access the Models menu, and browse to the Data model tab.

    Select the Create data model button.

    {modal="regular"}

  2. Define the name of your data model, and select Create button.

  3. From your data model dashboard, select Add schemas to choose the schema associated with your data model.

    {modal="regular"}

  4. Additionally, you can add audiences to your data model. Select Add Audiences to define your target groups.

    {modal="regular"}

  5. Establish connections between tables in your data model to ensure accurate data relationships. For more information, read the create links section.

  6. After completing the configuration, select Save to apply your changes.

NOTE
If you’re creating a link with multiple joins, you can only use the same combination of source and target schemas once.
Table view

To create links between tables of your data model from the table view tab, follow these steps:

  1. Select the three dots icon followed by Create link next to one of the table, or select Create links within the Links section:

    {modal="regular"}

  2. Fill in the given form to define the link.

    {modal="regular"}

    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.

    The plus button is highlighted, which lets you create a multiple join link for the model. {modal="regular"}

All the links defined for your data model are listed as below:

{modal="regular"}

Canvas view

To create links between tables of your data model from the Canvas view tab, follow these steps:

  1. Access the Canvas view of your data model and choose the two tables you want to link

  2. Select the button next to the Source Join, then drag and guide the arrow towards the Target Join to establish the connection.

    {modal="regular"}

  3. Fill in the given form to define the link and select Apply once configured.

    {modal="regular"}

    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.

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

    {modal="regular"}

  5. 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:

recommendation-more-help
fadff0d9-29d0-4d44-99a6-2499b0b7778b