51黑料不打烊

Get started with data models data-model-beta

AVAILABILITY
To access data models, you鈥檒l 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 Federated Audience Composition 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.

    Click on the Create data model button.

    {modal="regular"}

  2. Define the name your data model, and click on the Create button.

  3. From your data model dashboard, click 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. Learn more

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

Table view

To create links between tables of your datamodel from the Table view tab, follow these steps:

  1. Click on Create link menu of one of the table, or click on Create links button, and choose the 2 tables:

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

All the links defined for your datamodel are listed as below:

{modal="regular"}

Canvas view

To create links between tables of your datamodel 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. Click 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 click 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. Click on 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:

video poster

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