Create a Web Service with SAP BusinessObjects Data Service to Deliver Real-Time Data Quality

  • by Don Loden, Director - Data & Analytics, Protiviti
  • August 25, 2011
Learn how to create a real-time data quality Web service to deliver accurate and reliable customer data. Explore time-saving tips and tricks for developing a flexible data flow that any application can use to cleanse and standardize data and for configuring an SAP BusinessObjects Data Services server.
Key Concept

The data quality engine on the SAP BusinessObjects Data Services server uses a break key to minimize a comparison recordset considered for a data match. Without the break key narrowing down a recordset, the match operation is inefficient and processes more data than necessary, causing the data flow to perform poorly. Performance is especially important for a real-time job, as these jobs often imbedded in other applications as web services. For example SAP NetWeaver Master Data Management uses the data quality engine natively to perform real-time data quality. Any performance degradation in the real-time job will be magnified in the host application.

Data quality is a topic that is consistently at the forefront of most IT corporate initiatives. Businesses are more concerned than ever about ways to enhance customer experience at every touch point. Having the best customer record at input is the first step in promoting and maintaining quality master data in the enterprise.

Take, for example, ordering an item online and the convenience of a business already knowing your address from past order history, or correcting an entered address with a prompt suggesting, “Did you mean this address?” Companies with mature business intelligence implementations often know a customer’s entire purchase history, and they use this history to both speed up and enhance the ordering experience. Prompts such as “Would you be interested in these products?” are often used in these scenarios.

These examples signify that a company has a mature data quality environment and is actively pursuing master data management. Behind many of these successful data quality implementations is SAP BusinessObjects Data Services, which can verify, associate, and select the best customer record at every customer interaction.

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


Comments

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.