Data Cleansing in Real Time Using BusinessObjects Data Services

  • by Jeswin Davidson Ebenezer, SAP BusinessObjects Consultant, YASH Technologies
  • December 9, 2011
Extracting the right data from your transaction system for analysis and decision making is important. You can standardize and correct data using SAP BusinessObjects Data Services. A real-time data migration example illustrates the concepts and walks you through the process. The scenario can help technical teams in any organization understand the data quality process for data migration. You can use this process in a non-SAP environment when data warehouses are built on top of relational database systems for reporting and analysis. You can also use it when the target is in an SAP system.
Key Concept

SAP BusinessObjects Data Services is an information management application for data integration, data quality, data profiling, and text analysis. It allows users to integrate, transform, improve, and deliver trusted data that supports critical business processes so that they can make sound decisions on time.

Data cleansing is an important aspect of SAP BusinessObjects because it allows companies to combine redundant records and streamline data for front-end users. SAP BusinessObjects Data Services is an extraction, transformation, and loading (ETL) tool that combines two facets of data migration (i.e., data quality and data integration) in a single user interface.

Note

This information is aimed at end users and developers who are interested in best practices regarding data cleansing.

This article is based on BusinessObjects Data Services 3.2. The process also holds good for BusinessObjects 4.0. Concepts are explained based on real-time data (i.e., transactional data used by any organization in its day-to-day activities), and how you get the data cleansed and ready to load.

Data migration using SAP Best Practices for Data Migration involves the following tasks:

  • Ensure clean data in the staging database to be mapped to the source fields in the best practices job using data quality
  • Configure best practices scenarios to the requirement and execute jobs to load the data to the target system

I focus on the data quality aspect of data migration in real-time scenarios. I use vendor master – basic data load as an example to explain the various steps involved in the data migration process using the best practices.

Jeswin Davidson Ebenezer

Jeswin Davidson Ebenezer is an SAP BusinessObjects consultant with YASH Technlogies. He has about nine years of experience working on BusinessObjects implementations on ETL and reporting.

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.