Skip to Content
Product Information
Author's profile photo Axel Meier

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

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sven Knöpfler
      Sven Knöpfler

      Thanks Axel Meier for this very interesting blog! Thats 10 years of HANA development suddenly available for every DWC user. I am looking forward to use that feature in future implementations. Just a minor questio, if I may: is there a way in the WEB-IDE, to grant access to every consumable model (for WEB-IDE as well as for DWC) instead of defining all the models manually? Thanks and regards

      Sven

      Author's profile photo Axel Meier
      Axel Meier
      Blog Post Author

      Hi Sven,

      no, this is deliberately designed to require explicit grant access for each and every DWC model that needs to be consumed in WebIDE / HDI.
      Thanks,
       -Axel
      Author's profile photo Sven Knöpfler
      Sven Knöpfler

      Thanks for your reply. Good to know!

      Author's profile photo Xavier Polo
      Xavier Polo

      Axel Meier can this blog be updated to show the process with BAS?
      we have some problems to make it work.

      Author's profile photo Axel Meier
      Axel Meier
      Blog Post Author

      Hi Xavier,

      tks for sharing your comment. I'll update the Blog content.

      Pls check out below Blog leveraging SAP Business Application Studio instead of SAP WebIDE:

      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.

      Pls feel free to check our new "BTP: E-2-E Data & Analytics Scenarios" Landing page where we're constantly adding new Blogs / Links - also visible on the HANA Cloud, Data Warehouse Cloud, SAP Data Intelligence & SAP Analytics Cloud Blog Community Pages.

      BTP: E-2-E Data & Analytics Scenarios: https://blogs.sap.com/2021/06/08/sap-business-technology-platform-end-to-end-data-analytics-scenarios/

      DWC Community Page: https://blogs.sap.com/tags/73555000100800002141/?category%5B0%5D=76664&category%5B1%5D=76119&category%5B2%5D=76118

       

      Thanks,

      -Axel

       

      Author's profile photo Xavier Polo
      Xavier Polo

      Thank you very much, I will check all this information