A growing community of customers and partners is using the SAP HANA in-memory platform for data warehousing purposes for a long time. In recent years, several innovations occurred in this area. Especially the introduction of SAP HANA extended application services advanced version (XSA) and SAP HANA 2.0 changed the way of your traditional software development to a modern and agile data warehouse development in a DevOps style. These innovations have enabled SAP to offer an agile and modern DevOps approach to building data warehousing environments that can address the analytics requirements demanded by organizations today.
Get an overview of the SAP SQL Data Warehousing solution approach and the tooling used to create a modern and cloud-ready data warehousing solution supporting agile development based on an open platform.
Learn more
The SAP SQL Data Warehousing trial is an unlimited developer licensing that includes the capabilities to model, implement, build and run a SAP SQL Data Warehouse solution in a Cloud based environment for development purposes only.
Trial BlogTrial FAQ
SAP’s Data Bits & Bites for Busy People webinar series offers seven sessions dedicated to SAP SQL Data Warehousing.
1. How is an SAP HANA DWH Different?2. Conceptual Modeling with SAP EAD3. Physical Modeling with SAP EAD4. Clone, edit and build DWH artifacts with SAP Web IDE & Git5. How to Use Continuous Integration & Testing in your DWH Environment6. How to Leverage Run & Operate in Your DWH Environment7. Who is using SAP HANA for Data Warehousing and Why?
A series of videos ranging from an introduction to an SAP big data warehouse environment to better understanding modelling, user security, data lifecycle management, UIs and Cloud.
Get to the playlist
Tools like the SAP HANA Web IDE or SAP Enterprise Architecture Designer are used to design and develop an SAP SQL Data Warehousing solution.
Develop your agile DW with SAP Web IDE – SAP HANA SQL Data WarehousingClone, Edit and Build the Data Warehouse Artefacts using SAP Web IDE for SAP HANAModeling the Data Warehouse with SAP Enterprise Architecture Designer (EAD)Designing your agile DW with EA Designer – SAP HANA SQL Data Warehouse (Blog)Designing your agile DW with EA Designer – SAP HANA SQL Data Warehouse (Video)Creating «Extreme» added value services for companies using Data Vault with PowerDesigner as automation toolDevelop your Agile SQL Data Warehouse on SAP HANA: GIT Repository & ContainersIntroducing the NDSO Part 1: How to create a NDSOIntroducing the NDSO Part 2: NDSO services (Delta Capabilities)SAP Web IDE workspace and HDI container isolation, or how to work on one schema with multiple developersOverview Modeling in SAP Web IDE Compared to SAP HANA StudioIntroduction of Join Cardinalities In SQL With SAP HANA 2.0 SPS04How to pivot/unpivot in SAP HANAWhat is the difference CalcView versus SQL View?When to use Execute in SQL Engine for Calculation ViewsFAQ Modeling HANA Calculation Views in Web IDEHands-On Tutorial: Machine Learning push-down to SAP HANA with Python
Provisioning data to a data warehouse or data mart is an essential task, whether it is physical movement of data or virtual access.
Replicate ABAP CDS Views from SAP S/4HANA Cloud to SAP Cloud PlatformExtraction from SAP S/4HANA and other ABAP sources into HANA SQL DW with Smart Data IntegrationSmart Data Integration: HanaAdapter from HANA Express to HANA as a ServiceBest Practices for SAP HANA Data LoadsTest data generator for SAP HANA for large initial and delta data setsReal Time Social Media Analysis in SAP Analytics Cloud
Why do data warehouse release cycles often exceed several months, and what can you do about it? How the Web IDE for SAP HANA enables agile data warehouse development.
Leverage the Data Warehousing Monitor to execute an monitor the Task ChainHANA SPS03 – HANA Web IDE Full-Stack (SCP) for SAP HANA to support Git merge and conflict resolutionAutomated Deployment & Testing with SAP HANA SQL Data WarehousingFirst Guidance document for Git branching and automation integrationSAP HANA Native Storage Extension: A Cost-Effective & Simplified Architecture for Enhanced ScalabilityGenerate CDS artifact definitions from SQL statements
SAP HANA XS Advanced (and Cloud Foundry) is the platform for SAP HANA Native Web Applications on premise and in the cloud. The XSA platform provides additional tooling for automating the build process.
XS Advanced for (not so) dummies Part 1XS Advanced for (not so) dummies Part 2XS Advanced for (not so) dummies Part 3XS Advanced for (not so) dummies Part 4The Path to SAP HANA Extended Application Services, Advanced ModelHow to prepare the HANA XSA environment to run HANA Data Warehousing Foundation 2.x componentsDeveloping with HANA Deployment Infrastructure (HDI) without XSA/CF or Web IDEHow to leverage the XSA based components of HANA Data Warehousing Foundation 2.0 in SAP WebIDE to create new DWF projects and enable DWF capabilities in existing projectsBest practices and recommendations for developing HDI-based rolesGrant privileges in mixed XSC/XSA scenariosThe easy way to make your HDI container accessible to a ‘classic’ database userConsume Calculation Views from XSA via Information AccessSet up the analytics adapter for SAP HANA XSA with SSO for SAP Analytics Cloud