CIOs, CFOs, and CEOs and Data Cleansing

This is my last full day in Las Vegas for Collaborate 12

I certainly didn’t win at the tables but I did win at the Collaborate 12 conference.

Old friends, new friends, new contacts, hopefully future customers.

MDM is on the rise and it is apparent at the conference.

Thank you to all the Oracle users that had questions this week.

One thing I did observe yesterday was a lot of people had full support from the CIO but…..

The CEO, COO, and the CFO didn’t feel the same passion.

MDM is going to save those people a lot of money and prevent a lot of headaches but they just don’t understand how important it is for them to figure out “what the heck MDM means”.

MDM doesn’t work without great defined business driven data governance coming from those people.

What doesn’t happen is the realization of how important MDM data is to an enterprise.

I saw many industries asking common questions this week.

Oracle Product Data Quality (formerly SilverCreek) was compared to Informatica a lot.  I don’t really know how the Informatica product compares to the Oracle product.  I do know that the Oracle product has had years of building universal product cleansing rules that would work for all product data.  I am assuming the same for Informatica.

Product data cleansing is different than customer data cleansing.   I can go into detail but you need to inquire about the differences yourself.  But at the highest level, you should take a look at the fact that customer relationships and data structures are far more static than product data.  Customer data content is typically the same basic core structure.  Product data can depend completely on the industry, the development processes, the definition of the product, the market channels, regional and global details, etc.  Product data can actually be defined as a result of a good MDM initiative where the customer data is typically cleansed and related in a good MDM initiative.

Experts will agree, disagree, elaborate, or admonish my opinions above.  Either customer or product MDM initiatives are not harder or easier than the other as a general rule.

As a consultant I would advise my client to run any data cleansing and data governance tool through a real test with actual product data.  Whether you pay for this test or whether you get it done during product selection is on you.  But, I would run my data through the tool and see which one gives you the desired results.  The one the does the best job wins.  Ensure that there is no real development effort in this endeavor so that the tool provides a means for business product expert to adjust without code.

Don’t buy a tool that is not easy to setup and use with your data.  It is not the software vendor’s responsibility to extract your data from your legacy system.  Once you have the data extracted into a modern file format like txt, csv, etc, then the tool should be able to pull the data in and analyze.  The tool should suggest changes and accept your feedback.

What is fantastic is if the tool will then deliver the product data cleansed into your PIM Data Hub instance without more code to be written.  Then it can be distributed in a manner that is according to the intense data governance policies that business has instilled into the entire organization.



















About oraclepim

Bob Barnett is an authority on the Oracle E-Business Suite and PIMDH. He has been delivering the Oracle manufacturing and product item master functionality for over 15 years.
This entry was posted in Extending Oracle PIM Data Hub Functionality, Oracle PIM, Oracle PIM Data Hub, Oracle PIM Data Hub Interface, Oracle PIM Implementation Activities, Oracle Product MDM, PIM Data Hub Infrastructure and tagged , , , , , , , , . Bookmark the permalink.

Leave a Reply

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

You are commenting using your 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