Import a Dataset into SAP Datasphere
- How to use the Data Builder
- How to import multiple datasets into your Space
- Which connections are supported in SAP Datasphere
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:
- Sign up for a SAP Datasphere free tier tenant.
- Get to know the SAP Datasphere interface
- Add users and assign roles
- Create your Space
- You are here -> Import your datasets
- Create an entity relationship model
- Create a graphical view model
- 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.
To access the Data Builder, simply click on the Data Builder icon on the left-hand side menu of SAP Datasphere.
- 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.
- Simply click on the import CSV icon as shown in the image below.
- Then, select your source file from your system.
- Quickly review your data and then click deploy once done.
- Give the table a business name and then wait whilst the table is deployed.
- You can then add in your remaining CSV files by repeating the process.
- 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:
Amazon Simple Storage Service
Cloud Data Integration
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
SAP BW/4HANA Model Transfer
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?