How to Get Data into SAP Data Warehouse Cloud Trial Tenant
You’ve signed up for SAP Data Warehouse Cloud trial and created your first Space – time to connect some sources and get data! But how? In this article, we’ll look at which connections to data sources are supported, how to connect to them, and what practical learning resources can help.
Tip: if you’re looking for a quick way to get data without establishing connections, you can simply upload your own flat files. In addition, our Onboarding Guide and Learning Missions include sample datasets in CSV format (not to mention useful learning resources 😊).
Which Sources are Supported?
SAP Data Warehouse Cloud supports a vast number of data sources – both SAP and non-SAP – and this number is constantly growing.
To get acquainted with the current possibilities in more detail, we recommend the following two sources:
- “Data Integration & Data Source Connectivity in SAP Data Warehouse Cloud” blog post for an overview and discussion of the connectivity options in SAP Data Warehouse Cloud.
- “Connection Types” article from SAP Help portal, for a tabular list of connection types supported out-of-box.
Please note that connections available in your trial account may differ from what you will see in a paid tenant.
How to Connect?
In a nutshell, there are two ways to get data into SAP Data Warehouse Cloud:
- pull data into a Space from remote sources (e.g. OData, cloud file storage and others) using out-of-box connectivity.
- push data from 3rd party SQL clients or ETL tools by using the so-called Database Users (SQL endpoints) in a Space.
Let’s take a look at what is required to start using these options.
Using the Create Connection Dialogue
Once you have created at least one Space in your trial tenant, you can connect it to a supported data source. However, if you try to do this straight away, you’ll notice that some of the connection tiles are inactive.
To activate these tiles, certain prerequisites must be fulfilled – depending on the system or the source you want to connect to. For example, one of the most common requirements is to install the Data Provisioning Agent. To help you understand what’s needed in your case, we’ve compiled the full list of prerequisites for each supported system in this table on SAP Help Portal. Please note: Click here for a list of unsupported features with SAP Data Warehouse Trial version.
In addition, the following how-to resources will walk you through the main activities involved in preparing your tenant for connections:
- DP Agent Installation Guide (PDF)
- Allowlist an external IP Address
- Upload TLS/SSL certificates
- Upload third-party drivers
- Find the externally facing IP of your trial tenant
Once everything is set up, you can establish a connection between the source and your Space. If you need help using the Create Connections dialogue, our Data Sources learning track includes how-to guides for connecting to the most popular sources.
Using Database Users (SQL Endpoints)
In addition to pulling the data from remote sources, you can push the data into SAP Data Warehouse Cloud tenant from 3rd party SQL clients and ETL tools. Before you can connect a specific tool, however, you’ll need to create a database user in your Space. This will generate a set of credentials you can use in the tool of your choice to establish a connection with SAP Data Warehouse Cloud. This video will show you how to do it.
For guidance on connecting to specific tools, take a look at these Learning Tracks as well:
Yes, you got that right – database users can be used for both, data ingestion and data consumption. Meaning that your SAP Data Warehouse Cloud can connect to various business intelligence tools like MS Excel or MS Power BI (to name a few).
If you like practical hands-on activities, you will love our learning resources. Below we have highlighted several resources about connectivity, but this list is not exhaustive – feel free to browse our how-to videos in the Learning Tracks, participate in virtual hands-on workshops (streaming live or on demand) or complete end-to-end practical scenarios in our Learning Missions.
Free Online Workshops:
- Make Connectivity Seamless and Easy – learn how to create connections to third-party tools, big data sources and work with the Remote Data Monitor.
- Create Connections and Master Data with Ease – this session will introduce you to connections and the data modeling features in SAP Data Warehouse Cloud.