Combining Data from Different Source Systems
You can get data from an almost endless amount of locations. Customer engagement data, financial data, operations data, the list is seemingly never-ending. Analyzing each data source separately gets you some insights. But, in order to get a complete picture, it’s paramount that you have the ability to combine all your data sources. With different combinations of data sources, you are sure to see insights and connections that would otherwise be impossible to perceive. Luckily, with SAP Data Warehouse Cloud, the power to combine data from all your different sources is right in your hands.
The first step to combining data from different systems is to connect the sources you wish to work with to your space.
Once the connections are assigned to your space, you are able to combine them using any of the modeling tools in the Data Builder such as the Graphical View, or the SQL View. The Graphical View is great for visual, intuitive data modeling, whereas the SQL View is great for IT or analyst users that have previous knowledge in SQL.
To combine tables from different sources simply select the source you want and drag the table onto the canvas. This works with any data source combination. For example, you can combine SAP HANA and Odata sources, or local CSV tables and SAP ABAP sources.
To illustrate: let’s say that Kristina from the global shoe e-commerce company Best Run Shoes would like to combine Product information from her SAP HANA connection, with Sales Order information she has on a CSV on her computer. All she needs to do is make sure her SAP HANA source is connected to her “Best Run Shoes – Marketing” space, and then upload the CSV with her Sales Order info. Once she’s in the Graphical View canvas in the Data Builder, she can drag the necessary tables from remote sources, from the Sources tab. As well as drag local tables from the Repository tab. A note: once you have used your remote source tables in any view, they will also show up in the repository tab, along with your local tables.
SAP Data Warehouse also supports connecting different fact or dimension views with one another or combining views with tables to create new models from different sources.
For example, from our Best Run Shoes example, if Kristina saved the model with the Sales Order and Product information, she could then create a new model using the output (named Product_SalesOrder1). She can then add information about clients to the Sales Order and Product output. Kristina can simply drag the Business Partners table- containing customer information- onto the saved View.