Using SAP BW bridge for Data Warehouse Cloud (Part 2: Combining Data – Demo)
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.
In the following section, we will be using an SAP Data Warehouse Cloud tenant 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
For comparison, a normal space created in SAP Data Warehouse Cloud will have Space Type: SAP Data Warehouse Cloud
Step 2: Import Table
In the “Data Builder” App, select “Import Remote Table”
Step 3: Select Connection
Ensure you have the right connection to your BW bridge selected.
Step 4: Select Remote Table
Browse your Info Areas for your table of choice and go to “Next Step”
In this example, we are using the ADSO CMCS12 – CM CS: Service Notification – Items (2LIS_18_IOITEM)
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.
Once your import is successful, you will see the Import Status as “Import Successful”
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.
You can explore the structure of the table that was imported by selecting the newly imported table.
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.
This will not copy the table but instead make it visible to other spaces in SAP Data Warehouse Cloud.
Do check out the demo below where we continue to walk you through our scenario from Part 1.
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 2: Combining Data from SAP BW bridge and Data Warehouse Cloud (Demo)
Do have a look at our additional articles for more information: