Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
RodrigoCaparroz
Advisor
Advisor
SAP Datawarehouse Cloud is the ultimate end-to-end data warehouse solution from SAP, one single cloud solution that allows you to create your Data Warehouse with transparency, governance and control.

One of the main capabilities of SAP DWC is the virtualization/federation of data. This means you can create your data warehouse / data marts without the need to replicate the data from your systems.

Below you can find, with the “yellow” lines which data sources DWC support virtualization for SAP environments and non-SAP environments:


SAP Data Sources


 


Non-SAP Data Sources


 

So, why not Virtually join one S/4HANA CDS View with one table in SQL Server? See on the video below how easy is to create a model and a join like that:



On this example, the data remains on S/4HANA systems and SQL Server, DWC is joining those tables on the fly and users will get real-time data access to those sources using this model created on DWC
4 Comments