Information Management Options in SAP HANA: Smart Data Quality

  • by Don Loden, Director - Data & Analytics, Protiviti
  • September 28, 2016
SAP HANA has features to both manage data and improve data quality that many SAP users might not know exist. These new options offer real-time transformational possibilities that were unthinkable until recently. Learn about the tools you can use to cleanse, match, or enhance data in real time with Smart Data Quality.
Learning Objectives

Reading this article, you will learn:

  • How to construct a real-time enabled data enrichment process in SAP HANA to cleanse and enhance data quality
  • Time-saving development best practices to accelerate your SAP HANA flowgraph development
Key Concept

Many define data quality as whether data is fit for use. Poor quality data can make or break an analytics endeavor for an organization. Without quality data real-time analytics can offer little value to the organization. Using SAP HANA developers will not only offer real-time analytics, but analytics of high data quality as an output. This offers credibility to the solution and helps prepare data in real time for better utilization.

Data quality is always a challenge for organizations seeking a robust analytics solution. If the data does not conform to high quality standards, then the analytical capabilities of the solution are highly diminished.

Data quality is even more important for a real-time analytics solution based on SAP S/4HANA. Take a recent experience I had with a company with a dashboard that is powered by an SAP HANA ERP system. This analytics solution allowed the company to have unprecedented access to real-time operational data. The business was very excited about the new capabilities and the value that this would bring to the organization.

However, when the solution was demonstrated to the chief financial officer (CFO), all the excitement around the new capabilities began to stall. The CFO had so much knowledge of the business and history of the company that he could immediately tell that the numbers in the dashboard were not possible. All development was halted until the data quality issues could be remediated.

Problems like this are very real when speaking about the real-time data access that SAP HANA provides. This is a problem that cannot be handled by legacy batch-based tools as the solution would be in real time. Fortunately, SAP has a pretty unique solution in SAP HANA to help with real-time data quality issues: SAP HANA’s Smart Data Quality (SDQ) tool.

Don Loden

Don Loden is an information management and information governance professional with experience in multiple verticals. He is an SAP-certified application associate on SAP EIM products.  He has more than 15 years of information technology experience in the following areas: ETL architecture, development, and tuning; logical and physical data modeling; and mentoring on data warehouse, data quality, information governance, and ETL concepts. Don speaks globally and mentors on information management, governance, and quality. He authored the book SAP Information Steward: Monitoring Data in Real Time and is the co-author of two books: Implementing SAP HANA, as well as Creating SAP HANA Information Views. Don has also authored numerous articles for publications such as SAPinsider magazine, Tech Target, and Information Management magazine.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.