Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
Computerworld 2007Subscribe to Computerworld
40 years of the most authoritative source of news and information for IT leaders.

Sidebar: Master Data Needs Managing Too

Can automate updates of multiple apps, databases
 

Sign up to receive Security Resource Alerts

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.




Print this Story Send Us Feedback E-mail this Story Digg! Digg this Story Slashdot this Story
Sidebar: Master Data Needs Managing Too
Metadata management returns to the fore
Sidebar: Intel Finds Huge ROI in Managing Metadata
"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
Update: Microsoft to appeal $1.3B EU fine
XP SP3 cripples some PCs with endless reboots
Windows Vista more secure than XP, says security company
More top stories...
Microsoft grows DAISY for blind computer users while Adobe wilts
Sun's JavaOne show re-dubbed 'VomitOne' after stomach bug hits
Leopard at six months: Does it live up to the early hype?
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
Hype and promises abound in the IT world, but these six breakthroughs really will change your life, says author and former IT manager John Brandon.
Baby boomers are retiring and taking their knowledge with them. Why do so few in IT seem to care?
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.
Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS.
Four years from now, the IT field will be a vastly different place. Will you be ready?
All Zones
Application Performance Zone
Enterprise-Class Security Zone
Enterprise Solutions Zone
The File Data Management Zone
Grid Computing on Windows Zone
Security Management Zone
ITIL Best Practices Zone
The SAS Zone
Storage Virtualization Zone
The Data Center Management Zone

Ads by TechWords

See your link here
Computerworld Report: Storage Gets Strategic
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 download
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 go
White Papers
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
New Fujitsu High-End Itanium Windows- and Linux-Based PRIMEQUEST Servers Offer the Utmost in High Availability
New Fujitsu High-End Itanium-Based PRIMEQUEST Servers Offer Industry-Leading System Management for Linux and Windows
Symantec State of the Data Center Report 2007
View more whitepapers