Skip to Content

Import a Dataset into SAP Data Warehouse Cloud

test
0 %
Import a Dataset into SAP Data Warehouse Cloud
Details

Import a Dataset into SAP Data Warehouse Cloud

August 10, 2021
Created by
August 3, 2021
One way to bring data into SAP Data Warehouse Cloud 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 Data Warehouse Cloud
QR code

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 Data Warehouse Cloud. You will get the sales data of Best Run Bikes and it is your mission to use the features of SAP Data Warehouse Cloud 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 trial.
  2. Get to know the SAP Data Warehouse Cloud 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


Step 1: Get to know the Data Builder

SAP Data Warehouse Cloud 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 Data Warehouse Cloud.

Data Builder Icon
Log on to answer question
Step 2: Import CSV files

Now it’s time to import the CSV files from the Best Run Bikes scenario, so you can get active with SAP Data Warehouse Cloud.

  1. Simply click on the import CSV icon as shown in the image below.
Data Builder Import Icon
  1. Then, select your source file from your system.
  2. Quickly review your data and then click deploy once done.
  3. Give the table a business name and then wait whilst the table is deployed.
  4. You can then add in your remaining CSV files by repeating the process.
Deploy CSV
Log on to answer question
Step 3: Check the supported connections in SAP Data Warehouse Cloud

There are also other ways to bring in your data into your system. SAP Data Warehouse Cloud 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 Data Warehouse Cloud Connections Help Portal.

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

Next Steps

Back to top