Using SAP BW bridge for Data Warehouse Cloud (Part 2: Combining Data – Demo)

November 15, 2022
Sara Sampaio
Technical Articles

Overview

This blog post is part of a series where we will be looking at a few simple use cases and basics when using SAP BW bridge for Data Warehouse Cloud. The purpose of this series is for you to have a walkthrough of how SAP BW bridge, SAP Data Warehouse Cloud, and SAP Analytics Cloud can work together.

In Part 2, we will be looking at how to combine data from SAP BW bridge and SAP Data Warehouse Cloud.

Introduction to SAP BW bridge for Data Warehouse Cloud

SAP BW bridge is the latest feature to be released for SAP Data Warehouse Cloud. The main benefit is being able to leverage existing on-premise designs in SAP BW, while also having access to the latest cloud-based functionality in SAP Data Warehouse Cloud. For a detailed breakdown, please head over to the Overview and Technical Deep Dive blog.

Pre-requisites

In the following section, we will be using an SAP Data Warehouse Cloud tenant with SAP BW bridge.

SAP%20Data%20Warehouse%20Could%20with%20BW%20Bridge

SAP Data Warehouse Could with SAP BW bridge

Part 2: Combining Data coming from SAP BW bridge and SAP Data Warehouse Cloud

Step 1: Select the correct space.

Ensure that you have selected the correct space before proceeding to the next steps. The “Space” you are looking for should be of Space Type: SAP BW bridge as seen below

SAP%20Data%20Warehouse%20Cloud%20%3A%20Space%20-%20Bridge

SAP Data Warehouse Cloud: Space – bridge

For comparison, a normal space created in SAP Data Warehouse Cloud will have Space Type: SAP Data Warehouse Cloud

SAP%20Data%20Warehouse%20Cloud%20%3A%20Space%20-%20DWC

SAP Data Warehouse Cloud: Space – DWC

Step 2: Import Table

In the “Data Builder” App, select “Import Remote Table”

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Table

SAP Data Warehouse Cloud: Import Table

Step 3: Select Connection

Ensure you have the right connection to your BW bridge selected.

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Remote%20Table%20%281%29

SAP Data Warehouse Cloud: Import Remote Table (1)

Step 4: Select Remote Table

Browse your Info Areas for your table of choice and go to “Next Step”

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Remote%20Table%20%282%29

SAP Data Warehouse Cloud: Import Remote Table (2)

In this example, we are using the ADSO CMCS12 – CM CS: Service Notification – Items (2LIS_18_IOITEM)

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Remote%20Table%20%283%29

SAP Data Warehouse Cloud: Import Remote Table (3)

Step 5: Confirm Remote Table

Confirm your table is in the “Ready for Import” tab before selecting “Import and Deploy“. If your table has been imported previously, it will be listed in the “Already in the Repository” and will not be imported again.

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Remote%20Table%20%284%29

SAP Data Warehouse Cloud: Import Remote Table (4)

Once your import is successful, you will see the Import Status as “Import Successful”

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Remote%20Table%20%285%29

SAP Data Warehouse Cloud: Import Remote Table (5)

Step 6: Review New Table

Head back to the main Data Builder tab and we see that our newly imported table is listed as deployed.

SAP%20Data%20Warehouse%20Cloud%20%3A%20Import%20Remote%20Table%20%286%29

SAP Data Warehouse Cloud: Data Builder

You can explore the structure of the table that was imported by selecting the newly imported table.

SAP%20Data%20Warehouse%20Cloud%20%3A%20Data%20Builder%20-%20Table%20Details%20%281%29

SAP Data Warehouse Cloud: Data Builder – Table Details (1)

SAP%20Data%20Warehouse%20Cloud%20%3A%20Data%20Builder%20-%20Table%20Details%20%282%29

SAP Data Warehouse Cloud: Data Builder – Table Details (2)

Step 7: Sharing Table (Optional)

If you would like to share this table with another space, you can do so by selecting the “Share“, followed by the space you would like to share this table with.

SAP%20Data%20Warehouse%20Cloud%20%3A%20Data%20Builder%20-%20Table%20Details%20%283%29

SAP Data Warehouse Cloud: Data Builder – Table Details (3)

SAP%20Data%20Warehouse%20Cloud%20%3A%20Data%20Builder%20-%20Table%20Details%20%284%29

SAP Data Warehouse Cloud: Data Builder – Table Details (4)

This will not copy the table but instead make it visible to other spaces in SAP Data Warehouse Cloud.

Helpful Information

Sharing your table to another space will not create a copy. It only makes your table visible to other spaces
The BW bridge space only allows remote tables from BW bridge. If you would like to combine data from flat files or other source systems, they will need to be created in different spaces.
This is the reason for sharing to different spaces and a recommended design approach to ensure you are not only connected to a specific view

Do check out the demo below where we continue to walk you through our scenario from Part 1.

Demo

In the demo, we will be taking you through the steps for combining data coming from SAP BW bridge and SAP Data Warehouse Cloud.

Thank you for making it this far. We look forward to bringing you Part 3.

As we mentioned in the overview, this blog is part of a series. You can find the additional parts below:

Part 1: Creating Simple Objects Using SAP BW bridge for Data Warehouse Cloud (Demo)

Part 2: Combining Data from SAP BW bridge and Data Warehouse Cloud (Demo)

Part 3: Using SAP Analytics Cloud on top of SAP BW bridge and Data Warehouse Cloud (Demo)

Part 4: Using the Transfer Tool to migrate objects to SAP BW bridge and Data Warehouse Cloud

Do have a look at our additional articles for more information:

Introducing SAP BW bridge for SAP Data Warehouse Cloud

SAP Data Warehouse Cloud, SAP BW bridge: Overview and Technical Deep Dive