Data Watch and Repair for Master Data Management

Some happy news on the data quality front (yes I'm harping on that quite a bit these days...). We just completed the new Data Watch and Repair solution using the entire OWB technology stack. One of the things we phased when looking at our MDM products was that we need more emphasis on quality of the data. How do we empower the data steward to take charge of data quality.

So we combined forces and worked on something called data watch and repair for master data management. It is a solution using the some exising technology from OWB (the data quality option for data profiling, data rules, data corrections and data auditors) and a new piece, a connector for the MDM products (for CDH, UCM and PIM). The latter is now officially available for OWB (it is part of OWB 11.1.0.6).

Now what makes this so interesting (in my humble opinion)? DWR - don't you love those acronyms! - allows you to leverage the technology we had in house with pre-defined data rules and pre-defined data corrections. This makes your time to market a lot shorter and your data a lot better. The solution follows our best practices and uses the generated corrections to write back data for the master data applications reducing the need to hand code any routines. The DWR solution also ensures you concentrate your effort on profiling and on data rules. These data rules now drive the entire implementation of data quality enabling the previously mentioned generated data corrections.

You will see more and more information appearing. For a first quick glance at DWR take a look at this paper. You will get an idea of best practices around a data quality solution and how DWR first within that picture.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today