July 18, 2005 (Computerworld) -- One of the biggest myths in metadata management is that it's synonymous with master data management.
While metadata refers to data that describes other data -- like data type and field name -- master data is shared across systems like lists or hierarchies of customers, suppliers or accounts.
Mentor Graphics Corp., a Wilsonville, Ore.-based hardware and software design company, uses a master data management server from Hyperion Solutions Corp. to publish master data across its multidimensional databases and Oracle, SAP and Callidus systems, said Jan-Willem Beldman, Mentor's team lead for analytical applications and data quality.
Before the company began using the server last year, publishing changes in product master data was a manual process, he said.
"Doing synchronization manually would obviously pose problems because you may have had a change in one system [that] is not made in the next system," he said.
The company has since begun using the server for its sales organization hierarchies, and it's now deploying the system for its general ledger processes, Beldman said.
"You can be guaranteed that a few minutes after you make the change, all the systems reflect the change ... without manual intervention and without people forgetting," Beldman said. "That really helped us get concise data -- especially around the end of quarter when we reload our data warehouse every four hours."
In addition, the server can help the company through a Sarbanes-Oxley Act compliance audit, he added. "It is very easy for us to show how the process works and explain when we make a change it gets made consistently across the board," Beldman said.
The Hyperion server launches a workflow process asking for the required approval for any master data changes, and it checks to make sure the change meets standards like naming-convention rules, said John Kopcke, Hyperion's chief technology officer.
The changes are pushed out to all ERP systems and data warehouses while recording the history and audit trail of those changes, he added.
Hyperion acquired its master data management server through its January purchase of Razza Solutions Inc.
Unilever Latin America began using Kalido Ltd.'s 8M master data management software six months ago to help ease a data-integration project to link human resources data from SAP, PeopleSoft and Siebel systems, said Monica Parisi, Unilever's information architecture manager.
The company is also using the tool to more quickly produce its financial reports each quarter.
"Sometimes the business wants to see the data in a way that we don't have it in the transactional system," Parisi said. "It is easy to create a new hierarchy with Kalido and create the governance to maintain this hierarchy. Until today, we didn't have a tool to maintain these hierarchies, and customizing a transactional system was expensive."
Unilever this week will begin planning a new project in which Kalido will be used to globally synchronize information about new products.
Though master data management is separate from metadata efforts, Stuart Carty, founder and principal of Gavilan Research Associates, suggested that the latter can often help companies prepare for master data management projects.
"Sometimes, no matter how much you try to protect your computer, you need to get down and dirty with the..."
Read more...
"Oooh, it's IT Blogwatch: in which OpenOffice.org 3.0 breaks cover, to delight and frustrate in equal measure. Not to mention..."
Read more... Read more Desktop Applications posts or See all Blogs
Mistakes such as putting down co-workers or burning bridges when you resign are surefire ways to darken your career prospects. Here's how to avoid them
Computerworld editors share stories of their first PCs, including some classics and some real clunkers -- then we ask readers to share their early-PC tales.
Download this Computerworld Report, free, compliments of HP. (Source: Computerworld) Data Storage has emerged from the back room to become a key part of regulatory compliance, disaster recovery and strategic tecnhology plans. Learn more in this new this Computerworld report, a $49.95 value, available free for a limited time, compliments of HP.
Download this executive briefing
E-Mail As a Service: Time for Another Look?
E-Mail As a Service: Time for Another Look?
Download this webcast, compliments of Google.
Go to the webcast
3 Building Blocks for a Profitable Green IT Strategy
Get this white paper now! (Source: Verdiem) This practical white paper compares "greening" your IT department to "greening" your home: the key to a lasting return is starting with small steps. Learn how to create an IT carbon footprint baseline, draft a list of objectives, and implement for the best ROI.
Download this white paper
White Papers
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
How Operating Systems Create Network Efficiency Lake Partners Strategy Consultants conducted research to understand the efficiencies created by different operating systems. Read the whitepaper to learn about the findings, including how in specific network areas JUNOS software creates significant operational efficiencies. Download this
white paper now!