×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

(OP)
Hello,

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