Skip to Content

Create an Entity Relationship Model in SAP Datasphere

An entity-relationship model (or E/R model) describes interrelated things of interest in a specific domain of knowledge. You can use an E/R model to better understand a subset of the entities in your space, and to communicate this information to other stakeholders.
You will learn
  • Overview of E/R Models
  • How to create an E/R Model
  • How to associate data columns
  • Finalise an E/R Model and deploy
jmmargojmmargoMarch 13, 2023
Created by
January 6, 2023

This tutorial is part of a mission, in which you try to help Best Run Bikes to to get a holistic view of their sales data by using the power of SAP Datasphere. You will get the sales data of Best Run Bikes and it is your mission to use the features of SAP Datasphere to help the bike suppliers make the best possible business decisions.

This mission consists of 8 modules that contain the necessary steps you need to follow in your mission to help Best Run Bikes:

  1. Sign up for a SAP Datasphere free tier tenant.
  2. Get to know the SAP Datasphere interface
  3. Add users and assign roles
  4. Create your Space
  5. Import your datasets
  6. You are here -> Create an entity relationship model
  7. Create a graphical view model
  8. Define measures, business semantics and preview your data

You can also follow the steps in this tutorial by watching this video. Please note that SAP Data Warehouse Cloud has evolved into SAP Datasphere. While this video references SAP Data Warehouse Cloud, the content applies to SAP Datasphere.

  • Step 1

    An E/R model provides a diagram for organising your data entities (tables and views) in relation to one another. You can:

    • Add entities from the repository or import them from a connection or a CSN file, as well as creating new entities directly.

    • Modify the properties of your entities including adding human-readable business names and creating associations directly in the diagram.

    • Save and deploy all the contents of your model with a single action.

    The work that you do in an E/R model benefits all the users in your Space as they can use the entities that you import or enhance as sources in their views.

    ER Model

    A data model is a way to organise the data and define the relationship between the data elements you have, to give it a structure. This structure must be aligned with your team’s needs to generate reports and queries.

    Log in to complete tutorial
  • Step 2
    1. Go to the Data Builder and click on the New Entity-Relationship Model button.

      ER Model Icon
    2. This takes you into the graphical modelling interface. Since you imported the sample data manually via CSV, then your data can be found under the Repository.

    3. Click and drag the table SalesOrders onto the canvas. This table holds information about customer orders.
    4. Next, click and drag the table SalesOrderItems to add more detailed information about your orders.
      SalesOrder and SalesOrderItems
    5. With the data tables now in your modelling interface, you are now ready to create the relevant associations and deploy your E/R model.

    Log in to complete tutorial
  • Step 3

    After including the SalesOrder table and the SalesOrderItems tables from your Best Run Bikes dataset into the model, they must now be associated to each other.

    1. Click on the SalesOrders table and then click on the Create Association arrow icon.

    2. Drag it over to the SalesOrderItems table to create an association between the two tables.

      Association b/w tables
    3. Ensure that the created association is between the columns SalesOrderID in the Association Properties panel.

    4. Drag and drop to connect the sales column from one table to the other if it’s not done already.

      Association Properties
    5. Next, click and drag the BusinessPartners table. This table contains information on Best-Run Bikes customers, which is useful when connected to the sales data. We’ll go ahead and create an association to the SalesOrders table using the PartnerID column.

      BusinessPartners Table
    6. Now add some geographical location information to the model. Drag the Addresses table onto the canvas.

    7. And now create an association between the Addresses and BusinessPartners tables using the AddressID column.

      AddressID Association
    Log in to complete tutorial
  • Step 4

    You’ve now joined all the tables we will be using in this model. Type a name into the Model Properties panel and click on Save. And once that’s completed, you can click on the deploy icon.


    You have now created associations between the tables by creating an Entity-Relationship model. You can now use this model to create Graphical or SQL views and model your data accordingly.

    Where can you create Entity Relationship Models in SAP Datasphere?

    Log in to complete tutorial
Back to top