SAP Data Warehouse Cloud (DWC) integrated with SAP SQL data warehousing – accessing DWC consumable models as Source
This Blog describes the capabilities to share a single HANA Cloud DB-Tenant for both SAP SQL data warehousing and SAP Data Warehouse Cloud (DWC) scenarios, by leveraging the SAP Data Warehouse Cloud consumable models as a source for the SAP IDE (here: WebIDE) artefacts, like: Synonym, Flowgraph, Calculation-View ….
SAP Data Warehouse Cloud provides the capability to connect the HDI-container, artefacts and loaded data to a DWC Space from the DWC Data-Builder Editors (graphical View and SQL View) for immediate access without data transfer.
This scenario describes a close-loop-integration between external consumable DWC models as a source for SAP WebIDE projects – who are connecting to the according connectivity adapter & partner – and the according HDI-container cerated from WebIDE projects, to be assigned to a DWC Space for immediate access by the Data-Builder Editors.
Please treat this Blog-Post as a follow-up to the previous shared BLOG: https://blogs.sap.com/2020/07/01/sap-data-warehouse-cloud-integrated-with-sap-sql-data-warehousing-sharing-a-single-db-tenant/.
In case you’re interested to leverage SAP Business Application Studio instead of SAP WebIDE to access DWC consumbale models, I’d like to guide you to below Blog we created in our group:
Blog 2: Access the SAP HANA Cloud database underneath SAP Data Warehouse Cloud: how to create an SAP HANA Deployment Infrastructure (aka HDI) container on SAP HANA Cloud, and persist actual sales data originated from an external system in the same SAP Data Warehouse Cloud’s existing persistence area. We will show how to provide bi-directional access between SAP Data Warehouse Cloud and SAP HANA Cloud’s managed datasets. You will also see how to expose SAP HANA Cloud & SAP Data Warehouse Cloud’s artifacts, like a table or a Graphical View, as oData services. You should also take a look on this additional blog, which provides hands-on instructions for exposing SAP Data Warehouse Cloud artifacts as oData services and a complete Git repository to kick-start implementation.
I also like to point you to our group Blog Landings page, where we constanly enhance and share new Content: SAP Business Technology Platform: End-to-End Data & Analytics Scenarios , also visible on the different SAP Community pages like SAP Data Warehouse Cloud Community Page