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:
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