Control and quality assurance of the data supply of a HANA Data Warehouse

With the ADWEKO data warehouse manager for SAP HANA you get a fully comprehensive solution which controls the data supply of a HANA data warehouse, assures its quality and, if necessary, offers the necessary adaptation options.

In contrast to the classic data warehouse, where the datamarts were initially loaded, the HANA data warehouse no longer has any internal processing procedures that can determine when the data for a particular buyer is completely available and whether it meets all data quality requirements. In the HANA data warehouse the completeness and correctness must therefore be determined by other methods and elsewhere.

For this purpose, our solution ADWEKO data warehouse manager for SAP HANA allows the load logging to be performed centrally by the data integration layer. Methods preceding the actual loading procedures receive the data and log the loading status. This centralized approach has significant advantages in terms of maintainability and extensibility.


Modular structure

The ADWEKO data warehouse manager for SAP HANA has a modular structure. The component load monitoring aims at determining the status of all data loads and making it available to the customers. To achieve this, a data integration layer is generated for the HANA data warehouse, whose interfaces for the ETL tools hardly differ from the interfaces of the existing loading mechanisms - only functions for load control are added. During the data delivery all loads are logged and the corresponding analysis is made available in the HANA data warehouse in the form of a virtual datamart. Based on this information, business users can be informed about the status of the data relevant to them.

Our solution basically uses the data model of the HANA data warehouse to generate all HANA artifacts that relate to the customer-specific characteristics of the data model in the data warehouse. This not only saves implementation effort, but also ensures that later extensions of the data model and tables in the HANA data warehouse are directly reflected in all components of the platform. This is a central building block for the long-term successful and efficient operation of the HANA data warehouse.

Our solution also makes use of this integration with the data model in the component load control, which independently controls the sequence in which the individual tables of the HANA data warehouse must be loaded, based on the dependencies in the data model, in order to avoid temporary inconsistencies in the data.

Further components data quality monitoring and data quality management are being developed

The ADWEKO data warehouse manager for SAP HANA is successively extended by ADWEKO with components that build on each other. In addition to the already mentioned functionalities of load monitoring and load control, further components such as data quality monitoring and data quality management are in the development phase. The data quality monitoring component will enable you to derive quality criteria from the data model and store customer-specific rules against which the data is checked in the integration layer. The data quality management component will enable you to use functional release processes to clean up data quality defects that have been identified.

The ADWEKO data warehouse manager for SAP HANA is a fully comprehensive solution which controls the data supply of a HANA data warehouse, ensures quality and offers the necessary adaptation options (manual or automated) if required. It is a useful and necessary addition to the use of a modern data platform based on SAP HANA technology and enables comfortable and long-term efficient operation.

Your contact person

Contact us and learn more about our solution and the possible applications:

Waldemar Fix
Director and Head of Software Solutions

> waldemar.fix(at)adweko.com