by Jodee Hale-Schmid
August 11, 2010
Authored by: Jim Whyte, Director of Solutions Consulting, Utopia, Inc.
In the data management space, a data quality tool is a must have for a sustainable enterprise information management program.
Depending on your software choice, it is a versatile tool to have deployed as it can address a number of your basic data management capability needs: extracting data, profiling, standardizing, enrichment, matching and merging and loading data across a variety of hardware and database platforms, file formats, purchased software and proprietary applications.As important as it is to have utility tools that provide the above technical capabilities it is how those capabilities can be deployed that really provides the business value to the company.The obvious use for a data quality toolset is in the area of data migration; either the one-time legacy system to the new target application ETL process, or for on-going periodic data migration as in the case of ERP to
data warehouse data transfer.Other options for this toolset is to leverage the data transform and validation routines you created for your one-time data migration process and redirect those jobs to run against your new strategic source system. Either passively, after data entry, to monitor your data quality and adherence to business and validation rules or real-time at the point of data capture to automate enforcement of data standards and ensure data integrity.A surgical use of the data quality tool is managing your “denied party” requirements. Typically, each country maintains a list of individuals and companies that are to be blocked from trade and commerce with legal entities within a given country. Data quality tools can be leveraged to access these “denied party” lists and compare to your customer and vendor files to ensure your compliance.One final suggestion with regard to the leverage and reuse of your data quality tool suite is in the area of mergers and acquisitions. Think your “one-time” data migration process now on “wash, rinse and repeat” mode. Any organization that is active in the M&A space should really be leveraging data quality tools. Data migration is usually one of the longer tracks to plan for in an M&A project.
A clean team can use the tools to evaluate your acquisition target and assess the data quality and provide estimates for the time required to convert and transform the data to your target applications using your existing business rules as its baseline.
An email has been sent to:
With more than 6,000 customers on six continents, JBS USA sells a staggering amount of meat products all over the world. To improve how payments were collected from all of...
IDEXX Laboratories, an animal health diagnostics and veterinary software innovator, prides itself on the quick turnaround of diagnostic test results for its customers. Internally, the business planning team was not...
As enterprise infrastructures become more complicated by mixtures of on-premise, cloud, and hybrid technologies, simplicity is becoming more important. An emerging need is for an enterprise cloud built on “hyperconverged”...
Please log in to post a comment.
No comments have been submitted on this article. Be the first to comment!
SAP Data Services Part 3: How to Extract, Transform, and Load Data into SAP HANA
SAP Data Services Part 2: Integrating with SAP BW on SAP HANA
Learn All About SAP SuccessFactors Employee Central Payroll: Integrations, Technology, and Implementations
See more »
SAPinsider is published by WIS Publishing, a division of Wellesley Information Services.
20 Carematrix Drive, Dedham, MA 02026 USA
Sales and Customer Service: 1(781)751-8799; email@example.com
© 2017 Wellesley Information Services. All rights reserved.
Online ISSN #2155-2444, Print ISSN #1537-145X
SAP and the SAP logo are trademarks or registered trademarks of SAP SE in Germany and other countries.