Service Oriented Data Quality

puzzle

Service Oriented Architecture (SOA) has been a buzzword for some years.

In my opinion SOA is a golden opportunity for getting the benefits from data quality tools that we haven’t been able to achieve so much with the technology and approaches seen until now (besides the other SOA benefits being independent to technology).

Many data quality implementations until now have been batch cleansing operations suffering from very little sustainability. I have seen lots of well cleansed data never making it back to the sources or only being partially updated in operational databases. And even then a great deal of those updated cleansed data wasn’t maintained and prevented from there.

Embedded data quality functionality in different ERP, CRM, ETL solutions has been around for a long time. These solutions may serve their purpose very well when implemented. But often they are not implemented due to bundling of distinct ERP, CRM, ETL solutions and consultancies with specific advantages and data quality tools with specific advantages, which may not always be a perfect match. Also having different ERP, CRM, ETL solutions then often means different data quality tools and functionality probably not doing the same thing the same way.

Data Quality functionality deployed as SOA components have a lot to offer:

Reuse is one of the core principles of SOA. Having the same data quality rules applied to every entry point of the same sort of data will help with consistency.

Interoperability will make it possible to deploy data quality prevention as close to the root as possible.

Composability makes it possible to combine functionality with different advantages – e.g. combining internal checks with external reference data.

During the last years I have been on projects implementing data quality as SOA components. The results seem to be very promising so far, but I think we just started.

Bookmark and Share

4 thoughts on “Service Oriented Data Quality

  1. Jax 13th July 2009 / 06:42

    Interestingly, this was the tack Mastersoft took two year ago, with the same thinking. In Australia, the benefits are not as well understood as one would hope 🙂 Far too much legacy.

  2. wesharp 6th August 2009 / 02:23

    Agreed. The more we open up solutions the more we can integrated other open services. Finally data services consultants can provides data web services as a solution!

  3. Baljeet Dogra 14th August 2009 / 15:33

    I am actually working on this requirement at the moment. Good to see that there are other eyes seeking a similar solution. We are providing reference data and the validation rules as services so that they can be consumed by multiple projects accross the organisation.

  4. Patrick Mullen 29th November 2009 / 19:41

    I am thankful for the new things I learned reading your post. Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s