Skip to Content

Import a Dataset into SAP Datasphere

One way to bring data into SAP Datasphere is by importing flat files. A flat file is a file that does not contain links to other files or is a non-relational database. It stands on its own, for instance, like a single text-only file. The most common flat files are .txt and .csv files.
You will learn
  • How to use the Data Builder
  • How to import multiple datasets into your Space
  • Which connections are supported in SAP Datasphere
jmmargojmmargoNovember 9, 2023
Created by
jmmargo
January 6, 2023
Contributors
jmmargo
meganhoy

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. You are here -> Import your datasets
  6. 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

    SAP Datasphere has two modelling layers tailored for different user groups: the data layer is the area where data engineers can create their models with a technical approach, whereas the business layer is the area for business users who create their models using a more semantic approach. This allows business users to work independently from data engineers, while still being able to collaborate and share data with them.

    Data Modeling Overview

    To access the Data Builder, simply click on the Data Builder icon on the left-hand side menu of SAP Datasphere.

    Data Builder Icon
  • Step 2

    Now it’s time to import the CSV files from the Best Run Bikes scenario, so you can get active with SAP Datasphere. The CSV files can be found in Step 3 of the Get Ready for Your SAP Datasphere tutorial.

    1. Simply click on the import CSV icon as shown in the image below.

      Data Builder Import Icon
    2. Then, select your source file from your system.

    3. Quickly review your data and then click deploy once done.

    4. Give the table a business name and then wait whilst the table is deployed.

    5. You can then add in your remaining CSV files by repeating the process.

      Deploy CSV
  • Step 3

    There are also other ways to bring in your data into your system. SAP Datasphere supports a wide range of connections to data sources. These can be connected in the Connections tab of your Space properties page. These include:

    • Adverity
    • Amazon Athena
    • Amazon Redshift
    • Amazon Simple Storage Service
    • Cloud Data Integration
    • Generic JDBC
    • Generic OData
    • Google BigQuery
    • Google Cloud Storage
    • Hadoop Distributed File System
    • Microsoft Azure Data Lake Store Gen1
    • Microsoft Azure Data Lake Store Gen2
    • Microsoft Azure SQL Database
    • Microsoft SQL Server
    • Oracle
    • SAP ABAP
    • SAP BW
    • SAP BW/4HANA Model Transfer
    • SAP ECC
    • SAP Fieldglass
    • SAP HANA
    • SAP Marketing Cloud
    • SAP S/4HANA Cloud
    • SAP S/4HANA On-Premise
    • SAP SuccessFactors for Analytical Dashboards

    More information on the capabilities of these connections can be found in the SAP Datasphere Connections Help Portal.


    Where do you import flat-files including CSVs and JSONs into your space from?

Back to top