Native SAP HANA data warehousing
As a short introduction, we all know that the world of SAP modeling systems is multifaceted and complex. Native SAP HANA data warehousing refers to the process of designing, developing, and maintaining data warehouses exclusively within the SAP HANA platform.
Data warehousing is essential for businesses looking to make data-driven decisions. It involves collecting, storing, and analyzing data from various sources to gain insights and support decision-making.
Obviously, such comprehensive solutions, which have grown over the years, cannot easily be distinguished from each other in a single short text, especially since topics such as know-how, licenses, and strategy must always be included individually in the analysis.
To be able to at least roughly separate the solutions conceptually, we deliberately refrained from examining all technical options in a single blog. One of these options includes the enhancement of native SAP HANA modeling with explicit data warehouse functions (known as SAP HANA for SQL data warehousing).
SAP HANA for SQL data warehousing is a solution that enables experienced SAP Business Warehouse customers and new customers to design, build, and operate their own data warehouse using native SAP HANA tools. Both SQL-based development and graphical editors can be used to meet the requirements for harmonization, strategic reporting, and data integration.
The upcoming blog series on this topic is intended to give you a classification of this solution and briefly present its essential core components:
- SAP HANA for SQL data warehousing – Positioning
- SAP HANA for SQL data warehousing – Core Components
- SAP HANA for SQL data warehousing – data warehousing foundation
1. SAP HANA for SQL Data Warehousing – Positioning
SAP HANA for SQL data warehousing is a native SQL data warehousing approach that is implemented with the SAP HANA platform on-premise. This solution can be seen as an extension of the frequently used pure virtual approach to modeling in SAP HANA (mainly with the calculation views). The actual enhancement comprises tools and objects that are aimed in particular at persisting the data models. With SAP HANA as the foundation of SAP HANA for SQL data warehousing, not only does the system speed benefit from all known HANA-specific performance drivers (among others: in-memory), but also its functional scope by the Advanced Analytics package (among others: predictive, geospatial, and graph data processing).
The fact that SAP HANA for SQL data warehousing is an SQL-based development (graphical and/or script) results in a largely open system landscape with regard to communication and virtualization. This means that, in addition to SAP-specific tools such as SAP Analytics Cloud or SAP Analysis for Microsoft Office, third-party tools can also be connected.
As mentioned above, it is up to you ,as a customer, to decide in which cases they want to be used for the graphical development (calculation view or nDSO, for example) or rather for script-based development (among other things: Functions or Procedures). In both approaches, SAP HANA for SQL data warehousing provides graphical and script-based editors, which are supported with the Git-enabled SAP Web IDE for SAP HANA.
By working with SAP HANA extended application services, advanced model, this solution also incorporates the microservice architecture, with which multiple runtimes are possible in a system environment and developments made can also be operated in the cloud.
In addition to these topics, a holistic data warehouse solution also includes classic functions such as data integration, delta capability, persistence, and monitoring. These aspects will be covered in our next blog “ SAP HANA for SQL Data Warehousing – Core Components”.
In conclusion, by utilizing native SAP HANA data warehousing, organizations can harness the full potential of the SAP HANA platform to store, manage, and analyze their data efficiently. This results in improved business intelligence, better decision-making, and increased competitiveness in the market.
Are you interested in getting to know the above benefits and facets of this solution in more detail? Then please take our course on this topic via our free learning journey in new learning site : learning.sap.com.