Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Customer/product master data

Customer/product master data

Customer/product master data


I was wondering of what others have done to address master data scenarios such as this one:

there are a handful of systems all containing customer and product information which is buried into the transaction data. there are a few systems to track sales and products, and others for financials and billings. over a couple dozen systems in total across a few geographies. the company has been around for a while so theres a lot of data and its scattered about.

How can this be consolidated or managed in a way that addresses system/data sprawl issues, the need for consolidated reporting, and the need for accurate information? i am thinking a data warehouse? or ODS? or combination? but what would this look like -- eg. would these legacy systems feed a new db such as a DW but still keep its copy of the data? or would it all just be linked informally?

Any ideas ideas and discussion are much appreciated!

RE: Customer/product master data

You need to assemble a superset of all the customer attributes, and a superset of all the product attributes.  Then determine the system of record for each attribute - who maintains that field.  Then, an ODS can pass the changed date back and forth to the other systems and thus insure consistency.  If a particular system does not have or need some particular attribute, it need not be enhanced to handle the unnecessary field.  

The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close