Home > Data management / BI News > Microsoft's must-have customer data integration feature
Data management / BI News:
EMAIL THIS

Microsoft's must-have customer data integration feature

By Hannah Smalltree, News Writer
26 Jul 2006 | SearchDataManagement.com

News on data management trends and technology
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Relationships can be complex -- even in business.

As companies merge, acquire, restructure and spin off subsidiaries, it's hard to keep track of the hierarchies and relationships among legal entities. Also, companies can now have multiple relationships with one entity -- perhaps recognized as a customer in one context, a supplier in another, and a partner in a third. And, in today's business climate, those relationships can all change rapidly. Using customer data integration (CDI) tools to understand organizational hierarchies can help sales, marketing, finance reporting, risk analysis and compliance efforts, according to John Radcliffe, research vice president with Stamford, Conn.-based Gartner Inc. It's especially important in business-to-business (B2B) relationships, he said.

"If you don't have proper information about your business customer, then you're in no position to manage the relationship," Radcliffe said. "You don't know the totality of the business you're doing together. They're complex and you're complex, and you're fragmented on both sides."

Companies have tried to solve the problem by building homegrown systems or relying on hierarchy data from a third-party provider such as The Dun & Bradstreet Corp., based in Short Hills, N.J. Now, many companies, including Microsoft, are using CDI tools to better understand organizational hierarchies and relationships.

Microsoft's unique challenges

Microsoft has a massive infrastructure, a variety of products and services, and approximately 75 million B2B and 300 million business-to-consumer (B2C) relationships across many countries. So, the technology giant considered hierarchy management a critical capability when it evaluated tools for its internal CDI project, according to Richard Clements, senior director of product marketing with Chicago-based CDI vendor Initiate Systems Inc. Microsoft chose Initiate's Identity Hub because of the performance and scalability of its newly developed B2B hierarchy management capabilities.

"We evaluated a number of other options, and Initiate Systems was the best CDI solution that could provide the B2B hierarchy management we needed and meet our accuracy, performance and scalability requirements," said Tony Ulkekul, senior director of sales operations at Microsoft. "Initiate's advanced matching technology, combined with its ability to integrate with enterprise-class Microsoft products, created a global solution for our CDI needs."

One of Microsoft's unique challenges is rationalizing multiple, potentially differing hierarchies, according to Initiate's Clements. Microsoft gets its hierarchy information primarily from Dun & Bradstreet and augments it with other third-party and internal information, he said. When hierarchies from multiple sources are different, Initiate uses matching algorithms to automatically determine the correct hierarchy. Then, Microsoft's data stewards can use a tool developed by Initiate to review the hierarchies and manually correct the information. Microsoft is starting with B2B relationships, Clements said, but plans to extend the capability to B2C relationships.

Microsoft rolled out Initiate's system in April, including the first version of its B2B organizational hierarchy management feature, Clements said. Initiate plans to make the capability generally available in September.

Approaches to organizational hierarchy management

Hierarchy management is not unique to Initiate's tool. Both Gartner and Forrester evaluate the capability during CDI studies, and several vendors offer it, according to analysts at both firms.

For more on customer data integration

Listen to our 15-minute data management briefing podcast on customer data integration, featuring Jill Dyche

Learn more in our customer data integration learning guide

Some companies have also tried -- with limited success -- to custom-build hierarchy management systems, according to Jill Dyche, partner and co-founder of Baseline Consulting Inc. and author of Customer Data Integration: Reaching a Single Version of the Truth (Wiley 2006).

"[Hierarchy management] is harder than people think. The logic required not only to build that code, but more importantly to maintain it, is huge," Dyche said.

The good news for customers is that CDI vendors are addressing the issue, she said.

But naturally, different vendors have different takes.

  • IBM is the sole leader in the 2006 Gartner CDI Magic Quadrant, based on its acquisition of Atlanta-based DWL Inc. IBM has had organizational hierarchy management capabilities since DWL's version 5.5 product, released in spring of 2005. IBM promotes a service-oriented architecture (SOA) approach so that operational systems can make use of relationship data, according to Bruce McPherson, director of strategy for enterprise master data solutions at IBM.
  • San Mateo, Calif.-based Siperian Inc. has a Hierarchy Manager (HM) tool as a module of its CDI hub. It's been out for about a year and is used by 30% of its customers, said Ramon Chen, Siperian's director of product management. Siperian is now developing more features to enrich relationship data with product data. The features would mesh data about purchased goods and services into the context of organizational hierarchies, Chen said.
  • Cary, N.C.-based DataFlux Corp. does not offer an "out of the box" tool and instead provides a framework for companies to build out customized organizational hierarchy management processes, including a flexible data model, workflow templates, and an underlying, SOA-based data management platform, according to Ron Agresta, solutions manager at DataFlux.
  • Redwood City, Calif.-based Purisma Inc. touts flexibility in organizing and managing extremely complex relationships -- enabling traditional parent/child hierarchies and attribute-defined groupings such as organizing entities by location, said Paul Friedman, Purisma's co-founder and chief technology officer.

Evaluating organizational hierarchy management features

Relationship hierarchy mapping and management capabilities are important features of a CDI tool, according to R. "Ray" Wang, senior analyst with Cambridge, Mass.-based Forrester Research Inc. For a fall 2006 CDI study, Wang is evaluating vendors' capabilities in this area, including how tools handle B2B relationships, how they support "house-holding" or modeling individual relationships, and how they manage overlapping hierarchies -- that is, when an individual belongs to multiple hierarchies, perhaps at home, at work and at another organization.

"The three key features to look for are the ability to model complex relationships, the ability to handle overlapping hierarchies, and having a visual hierarchy management tool, so it's easy to administer," Wang said.

Tags: Customer data integration softwareVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Customer data integration software
Six criteria for master data management (MDM) tool evaluation
What's the cost of developing PIM software internally vs. externally?
Top 13 master data management (MDM) buzzwords and definitions
Evaluating and selecting a master data management (MDM) vendor
MDM vendors improve data quality, stewardship, according to Gartner
Tips for planning a data governance strategy and MDM strategy
In customer data integration, is a "customer" always an individual?
EMR systems bring need for data integration, data quality into focus
What is driving MDM investments in the current economy?
Designing the MDM team for an SAP MDM implementation project

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Data Management: Business Intelligence, Data Integration, Data Compliance
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts