
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 SAP Datasphere. The purpose of this series is for you to have a walkthrough of how SAP BW bridge, SAP Datasphere, 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 Datasphere.
Introduction to SAP BW bridge for SAP Datasphere
SAP BW bridge is the latest feature to be released for SAP Datasphere. 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 Datasphere. 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 Datasphere tenant with SAP BW bridge.
SAP Datasphere with SAP BW bridge
Part 2: Combining Data coming from SAP BW bridge and SAP Datasphere
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 Datasphere: Space - bridge
For comparison, a normal space created in SAP Datasphere will have Space Type: SAP Datasphere
SAP Datasphere: Space - DWC
Step 2: Import Table
In the "Data Builder" App, select "Import Remote Table"
SAP Datasphere: Import Table
Step 3: Select Connection
Ensure you have the right connection to your BW bridge selected.
SAP Datasphere: Import Remote Table (1)
Step 4: Select Remote Table
Browse your Info Areas for your table of choice and go to "Next Step"
SAP Datasphere: Import Remote Table (2)
In this example, we are using the ADSO CMCS12 - CM CS: Service Notification - Items (2LIS_18_IOITEM)
SAP Datasphere: 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 Datasphere: Import Remote Table (4)
Once your import is successful, you will see the Import Status as "Import Successful"
SAP Datasphere: 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 Datasphere: Data Builder
You can explore the structure of the table that was imported by selecting the newly imported table.
SAP Datasphere: Data Builder - Table Details (1)
SAP Datasphere: 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 Datasphere: Data Builder - Table Details (3)
SAP Datasphere: Data Builder - Table Details (4)
This will not copy the table but instead make it visible to other spaces in SAP Datasphere.
Helpful Information
|
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 Datasphere.
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 SAP Datasphere (Demo)
Part 2: Combining Data from SAP BW bridge and SAP Datasphere (Demo)
Part 3: Using SAP Analytics Cloud on top of SAP BW bridge and SAP Datasphere (Demo)
Part 4: Using the Transfer Tool to migrate objects to SAP BW bridge and SAP Datasphere
Do have a look at our additional articles for more information:
Introducing SAP BW bridge for SAP Datasphere
SAP Datasphere, SAP BW bridge: Overview and Technical Deep Dive
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |