Skip to content

Posts from the ‘Governance’ Category

12
Oct

Oracle OpenWorld 2009

I just arrived in lovely San Francisco for the latest edition of Oracle OpenWorld.

I’m particularly interested in the Master Data Management (MDM) track this year, as it looks as if the Oracle team has done a great job putting together a roster of Oracle employees, customers and partners to speak on its MDM products for managing master data on customers, products, financials, sites and suppliers.

I ran into several Oracle people like Pascal Laik, David Butler, and Rahul Kamath at last week’s Gartner MDM Summit conference in Los Angeles (more on that later), and as always, it was great to see them.

I’m really looking forward to this week’s sessions on the state of the art in MDM and data governance, and will be speaking myself on Thursday, Oct. 15th at 3:00 pm PDT. So if you’re interested in MDM and you’re attending OpenWorld this week, please stop by and say hello.

For that matter, if you’re in San Francisco and want to get together, send me an e-mail at powerd (at) hubdesigns (dot) com, or call my office number (781-749-8910) – it’s forwarded to my cell phone.

Hope to run into you in the City by the Bay!

15
Sep

Looking for MDM Papers for OAUG COLLABORATE 2010

As I’ve written in the past, Hub Designs is a corporate member of the Oracle Applications Users Group (OAUG), and your trusty author, Dan Power, is the OAUG Education Committee’s track manager for Master Data Management.

Believe it or not, we’ve already started planning the May 2010 conference. So we’re looking for good papers on Oracle’s current MDM productsOracle Customer HubOracle Product HubOracle Site Hub, and Hyperion Data Relationship Management.

This will be the second year where we will be combining the Customer MDM and Product MDM threads in a single Master Data Management track.  Feedback on this was very good at last year’s conference.

Here’s the scoop from the OAUG on the Call for Papers:

Share Your Knowledge at COLLABORATE 10!

Proposals are due by Tuesday, October 20.

You are invited to submit a presentation proposal and share your approach to Oracle Applications in an education session at the premier annual conference for Oracle customers — COLLABORATE 10: Technology and Applications Forum for the Oracle Community, presented by IOUG, OAUG and Quest. More than 5,000 users, technology leaders, Oracle executives and solution innovators will gather for the premiere user-driven education and networking event April 18-22, 2010 at the Mandalay Bay Convention Center in Las Vegas, Nevada.

If you are an Oracle Applications professional with an interest in Oracle Fusion, Oracle E-Business Suite, PeopleSoft, Agile, Hyperion, Oracle Communications and Siebel product families, as well as applications technology, please submit through the Oracle Applications Users Group (OAUG). Proposals are now being accepted. The deadline is Tuesday, October 20, 2009 at 11:59 p.m. EDT.

As a selected presenter, you’ll have the chance to:

  • Share your best practices and tested solutions for Oracle technologies and applications
  • Enhance your own knowledge through new conversations with your peers
  • Attend a full week of education sessions to learn from other Oracle users, experts and leaders

Get more information about presenting at COLLABORATE 10, including tracks, specific industry- or product-related areas of emphasis, presenter requirements and the presentation submission and selection processes.

Submit your proposal through the OAUG

Note These Important Presentation Submission Dates and Deadlines

  • October 20, 2009, 11:59 p.m. EDT: Presentation abstracts due.
  • December 2009: Accepted presenters notified by the OAUG.
  • January 21, 2010: Acceptance of the compliance agreement due.
  • March 9, 2010: All presentation materials including white paper and presentation slides are due.
  • April 18 – 22, 2010: We look forward to seeing you in Las Vegas!

IOUG, OAUG and Quest strive to provide top-quality content at COLLABORATE, emphasizing user-driven education sessions that truly benefit attendees and their organizations. We will monitor sessions and feedback from attendees to ensure education sessions are not focused on a sales-centered topic. Presenters in violation will be noted and may be prevented from speaking at future COLLABORATE conferences. This does not apply to any purchased vendor activities, which are clearly communicated to attendees as sponsored events.

Attention Team Oracle! All Oracle employees interested in speaking at COLLABORATE 10 are to contact Lisa Stuart at lisa.stuart@oracle.com prior to submitting papers through the official COLLABORATE 10 call for papers engine.

Connect with COLLABORATE 10 — OAUG Forum on Twitter for conference news, reminders and networking. Use hashtag #C10.
12
Aug

New Data Governance White Paper

A new white paper by Dan Power of Hub Designs is available on Siperian’s web site.

The white paper underscores the importance of a proactive data governance approach, and is designed to help organizations develop a sound and sustainable data governance initiative.

Data governance is a vital component of any master data management effort, since it defines who owns the data, who establishes policies, and who the decision-making authority is when it comes to an organization’s critical data assets. However, many companies tend to take a limited and reactive approach to data governance.

In this new report titled, “When Data Governance Turns Bureaucratic: How The Data Governance Police Can Constrain the Value of Your Master Data Management Initiative”, we outline the limitations of a reactive data governance strategy and urge organizations to adopt a proactive data governance approach, whereby master data is corrected and validated right at the source and often by the business user. This removes potential data stewardship “bottlenecks” and eliminates critical time lags that may occur between the initial entry of a new master record, its certification/ publishing, and its ultimate availability to the rest of the enterprise.

To access the full report, visit http://forms.siperian.com/content/PowerGovernancePR.

20
May

New Guest Post for Identity Resolution Daily

I’m sure regular readers of this blog have noticed the reduced frequency of new articles in the past few weeks. It doesn’t mean that I don’t care about you, the reader – honestly!

But it does mean that it’s gotten much harder for me to write for this blog, because I’m typically at a client site Monday – Thursday, and correspondingly, life seems as it’s on “fast forward” lately, as I try to squeeze everything else into weekday evenings and Friday – Sunday.

I did find time to write a guest post for Identity Resolution Daily, a great blog maintained by Infoglide Software.

Here’s a brief excerpt:

There definitely seems to be a trend lately with small companies in the master data management (MDM) and data quality space being purchased (as in the asset acquisition of Exeros by IBM) or partnering with larger firms (such as Silver Creek Systems’ OEM relationship with Oracle).

I think this is a good thing. Using the classic “build, buy or ally” strategy, it isn’t surprising that sometimes companies will conclude that it’s faster and/or cheaper to buy a technology, or partner with another company that has that technology, rather than build it themselves internally.

For the complete article, please click “The Growing Role of Identity Resolution in MDM“.

Thanks for being patient with me as I re-adapt to life as a road warrior!

11
May

Gryphon Networks

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Editor’s note: from time to time, the Hub Designs Blog profiles companies and solutions you may not have heard of yet that are relevant to master data management (MDM).

Company & location: Gryphon Networks, headquartered in Norwood, Massachusetts, provides “on demand contact governance” solutions.

Value proposition: Gryphon’s approach combines compliance and preference management, converting consumer contact preferences, compliance policies, and corporate governance into a consumer contact database, tracking the legal methods for contact. This gives you a “safe” list that expands your marketable base.

What point in MDM lifecycle: This is particularly useful when you’re using an MDM hub to support marketing activities and you’re concerned about maintaining a “single source of truth” on “Do Not Call” status, as well as opt-in / opt-out status for fax, email, and direct mail campaigns.

Relevance to MDM: Today’s hubs are evolving into “policy hubs”, where the enterprise can go beyond basic customer name & address data to tracking advanced attributes like contact preferences and managing compliance with a growing list of privacy regulations. But for a lot of industries, the current generation of MDM hubs doesn’t go far enough. That’s where Gryphon Networks comes in – it provides a real-time, on-demand contact governance capability that your MDM hub can interact with via Web Services.

If you’re in an industry like financial services, hotels, healthcare, telecommunications, insurance, etc. where there’s a need for a lot of outbound marketing activities and at the same time, strict privacy regulations around “Do Not Call” and opt-out status for e-mail, fax and direct mail marketing, your MDM strategy should probably include integration with Gryphon Networks’ platform.

For more information, contact Bob Hadden at rhadden@gryphonnetworks.com.

7
May

OAUG COLLABORATE 09

digg this | del.icio.us | Reddit | Stumble It!

The  Oracle Applications Users Group (OAUG) COLLABORATE 09 conference has wrapped up, and this year was a good one.

Attendance was down overall, from about 7,500 people last year to roughly 4,500 this year (caution, these are unofficial “word of mouth” numbers). But given the gloomy economic picture over the last 6-8 months, I was just happy the conference wasn’t canceled altogether. And I noticed that the people who were there were more engaged. These are the folks who had to fight to attend, so once they got there, they were more focused on getting the most out of it.

On the Master Data Management front, we had a great roster of presentations this year.

I particularly enjoyed Bob Barnett on “Design Guidelines for Oracle PIM MDM Processes”, Shyam Kadigari on “Oracle Customers Online Implementation”, Mani Kumar Manda on “Golden Rules to Tame the MDM Beast” and William McKnight on “Top 10 Mistakes Companies make in forming Enterprise Data Governance”.

I thought Pascal Laik, VP of MDM Product Strategy at Oracle, did a great job on “Rapid ROI with Oracle Master Data Management”. He did a demo of the ROI Analysis tool that Oracle has created, which looked very comprehensive and should save MDM teams a lot of time. Oracle customers can get access to this through their Oracle sales team.

There were a couple of presentations I was looking forward to but had to miss, including Bill Swanton from AMR Research on “Master Data Management for ERP Suites – It’s Different” and Brent Zionic from Sun Microsystems on “The Lunatic, the Lover & the Poet – Beyond Imagining Data Management”. Word of mouth feedback on these presentations was very good.

The OAUG is planning to offer a number of eLearning webinars over the rest of 2009, so we’re inviting all of the presenters (and anyone else interested in doing an eLearning session) to submit their ideas at http://secure.meetingexpectations.com/oaug/elearning/elSubmission.aspx.

I’ve been a member of the OAUG’s Education Committee for several years, and with the aid of the OAUG Special Interest Group (SIG) coordinators for Customer Data Management and Product Lifecycle Management / PIM, I’ve been planning the MDM track at each year’s conference. So if you’re interested in presenting at a future OAUG COLLABORATE conference, please sign up for Hub Designs’ newsletter, so I can keep you posted on the next Call for Papers.

18
Apr

Modeling the MDM Blueprint – Part 5

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

er_modelIn this series, we’ve discussed developing the MDM blueprint by creating the Common Information (Part 2), Canonical (Part 3), and Operating (Part 4) models in our work streams. We’ve introduced the Operating Model into the mix to communicate with the business how the solution will be adopted and used to realize the expected benefits. And hopefully we’ve set reasonable expectations with our business partners as to what this solution will look like when deployed.

Now, it’s time to model and apply the technical infrastructure or patterns we plan on using. The blueprint now moves from being computation and platform independent to one of expressing intent through the use of more concrete platform-specific models.

Reference Architecture

After the initial (CIM, Canonical, and Operating models) work is completed, then, and only then, are we ready to move on to the computation and platform specific models. We know how to do this – for example see Information ServicePatterns, Part 4: Master Data Management architecture patterns.

At this point, we now have enough information to create the reference architecture. One way (there are several) to organize this content is to use the Rozanski and Woods extensions to the classic 4+1 view model introduced by Philippe Kruchten. The views are used to describe the system in the viewpoint of different stakeholders (end-users, developers and project managers). The four views of the model are logical, development, process and physical view. In addition, selected use cases or scenarios are used to demonstrate or show the architecture’s intent. Which is why the model contains 4+1 views (the +1 being the selected scenarios).

41views1

Rozanski and Woods extended this idea by introducing a catalog of six core viewpoints for information systems architecture: the Functional, Information, Concurrency, Development, Deployment, and Operational viewpoints and related perspectives. This is elaborated in detail in their book titled “Software Systems Architecture: Working with Stakeholders Using Viewpoints and Perspectives”.  There is much to learn from their work, I encourage you to visit the book’s web site for more information.

What we are describing here is how MDM leadership within very large-scale organizations can eventually realize the five key “markers” or characteristics in the reference architecture to include:

  • Shared services architecture evolving to process hubs;
  • Sophisticated hierarchy management;
  • High-performance identity management;
  • Data governance-ready framework; and
  • Registry, persisted or hybrid design options in the selected architecture.

This is an exceptional way to tie the technical models back to the stakeholders needs, as reflected in the viewpoints, perspectives, guidelines, principles, and template models used in the reference architecture. Grady Booch said “… the 4+1 view model has proven to be both necessary and sufficient for most interesting systems”, and there is no doubt that MDM is interesting. Once this work has been accomplished and agreed to as part of a common vision, we have several different options to proceed with. One interesting approach is leveraging this effort into a Service Orientated Modeling Framework introduced by Michael Bell at Methodologies Corporation.

Service-Oriented Modeling

The service-oriented modeling framework (SOMF) is a development life cycle methodology. It somf_v_2_0offers a number of modeling practices and disciplines that contribute to a successful service-oriented life cycle management and modeling. It illustrates the major elements that identify the “what to do” aspects of a service development scheme.

These are the modeling pillars that will enable practitioners to craft an effective project plan and to identify the milestones of a service-oriented initiative—in this case crafting an effective MDM solution.  SOMF provides four major SOA modeling styles that are useful throughout a service life cycle (conceptualization, discovery and analysis, business integration, logical design, conceptual and logical architecture).

These modeling styles: Circular, Hierarchical, Network, and Star, can assist us with the following modeling aspects:

  • Identify service relationships: contextual and technological affiliations
  • Establish message routes between consumers and services
  • Provide efficient service orchestration and choreography methods
  • Create powerful service transaction and behavioral patterns
  • Offer valuable service packaging solutions

SOMF Modeling Styles

SOMF offers four major service-oriented modeling styles. Each pattern identifies the various approaches and strategies that one should consider employing when modeling MDM services in a SOA environment.

Circular Modeling Style: enables message exchange in a circular fashion, rather than employing a controller to carry out the distribution of messages. The Circular Style also offers a way to affiliate services.

Hierarchical Modeling Style: offers a relationship pattern between services for the purpose of establishing transactions and message exchange routes between consumers and services. The Hierarchical pattern enforces parent/child associations between services and lends itself to a well known taxonomy.

somf_stylesNetwork Modeling Style: this pattern establishes “many to many” relationship between services, their peer services, and consumers similar to RDF. The Network pattern accentuates on distributed environments and interoperable computing networks.

Star Modeling Style: the Star pattern advocates arranging services in a star formation, in which the central service passes messages to its extending arms. The Star modeling style is often used in “multi casting” or “publish and subscribe” instances, where “solicitation” or “fire and forget” message styles are involved.

There is much more to this method, so I encourage you to visit the Methodologies Corporation site and download the tools, power point presentations, and articles they’ve shared.

Summary

Based on my experience, we have to get this modeling effort completed to improve the probability we’ll be successful. MDM is really just another set of tools and processes for modeling and managing business knowledge of data in a sustainable way. Take the time to develop a robust blueprint to include the Common Information (semantic, pragmatic and logical modeling), Canonical (business rules and format specifications), and Operating Models to ensure completeness. Use these models to drive a suitable Reference Architecture to guide design choices in the technical implementation.

This is hard, difficult work. Anything worthwhile usually is. Why put the business at risk to solve this important and urgent need without our stakeholders understanding and real enthusiasm for shared success? A key differentiator and the difference between success and failure on an MDM journey is taking the time to model the blueprint and share this early and often with the business. This is after all a business project, not an elegant technical exercise. Creating and sharing a common vision through our modeling efforts helps ensure success from inception through adoption by communicating clearly the business and technical intent of each element of the MDM program.

In the last part of the series, I’ll discuss where all this fits into the larger MDM program and how to plan, organize, and complete this work.

Continue with Part 6 or go back to Part 4.

14
Apr

SmartCo

Editor’s note: another in an occasional series where the Hub Designs Blog profiles companies and solutions you may not have heard of that are relevant to master data management (MDM).

SmartCo Logo

Company & location: SmartCo, headquartered in Paris, France, with an office in Boston MA, provides a product called the SmartCo DataHub, a master data management solution for financial institutions.

Value proposition: SmartCo DataHub consists of several data management modules including a Security Master, which handles every type of asset class and manages reference data, market data and corporate actions data. The product can receive information from many different internal or external sources, and then cleanse it, enhance it and distribute it to all departments and systems, so everyone shares the same data.

SmartCo DataHub also provides other modules such as Indices and Benchmarks, and Business Entity Management, which centralizes and consolidates all information about third parties with which the financial institution is directly or indirectly in business. This is linked to the Security Master for monitoring and mitigating credit and operational risks.

SmartCo DataHub has built-in connectors to data sources like Bloomberg, Thomson/Reuters, Factset, Interactive Data, Markit, Six Telekurs / Fininfo, and several others. SmartCo DataHub is designed using the latest SOA technology in order to provide users with more flexibility.

What point in MDM lifecycle: this would be most appropriate for banks and other financial institutions looking to replace one or more internally built security masters. Most financial services companies don’t regard creating their own custom security master as a competitive advantage any more. So a “commercial off-the-shelf” (COTS) solution might be a good fit for companies looking to reduce the number of security masters they’ve got to maintain, and save money vs. developing a new security master internally.

Relevance to MDM: the financial services industry is going through its biggest upheaval in more than 75 years. But consolidating multiple custom built systems that are expensive to maintain can save a lot of money and provide a very strong return on investment.

If you’re in the financial services industry and are investigating master data management as a strategy for cost savings, revenue enhancement or regulatory compliance, SmartCo is an interesting company that is growing its presence in the North American market.

13
Apr

Silver Creek Systems

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Editor’s note: another installment in an ongoing series where the Hub Designs Blog profiles companies and solutions which are relevant to master data management (MDM).

Silver Creek Systems

Company & location: Silver Creek Systems, headquartered in Westminster, Colorado, provides automated data mastering solutions which enable enterprise-wide standardization and integration of product information.

Value proposition: I recently had a briefing with several Silver Creek people. Their core product, DataLens™, applies semantic technology to standardize, enrich, match, repurpose and govern product information. I think of it as data quality for product information on steroids.

The semantic approach makes a lot of sense. I remember from my ERP days how painful dealing with product information can be (requiring endless massaging in Excel or complex SQL queries to extract and reformat it). Silver Creek seems to have an intelligent solution to one of the thorniest issues in MDM.

What point in MDM lifecycle: if your MDM initiative involves product information, you’ll quickly find out that Product MDM is very different from Customer MDM. It’s common for product data to have dozens or even hundreds of required attributes. The hierarchy management requirements for product data are typically more complex. And because a lot of product data is unstructured or semi-structured, you need a specialized parsing engine if you want to automate the standardization of your data.

Relevance to MDM: data quality tools designed for customer information have a hard time handling the widespread variability of product data, its relative lack of structure, the dearth of referential data from third-party sources, the overloading of the “description” field, the classification and categorization requirements and the added complexity in hierarchy management.

As I do more work in the Product MDM area, I’m impressed with Silver Creek Systems and its DataLens solution.

Update on 04/14/09: Silver Creek Systems announced today that its DataLens™ System was named the top Data Quality product by SearchDataManagement.com’s 2008 Products of the Year program. The awards were judged by a team of industry analysts and consultants and presented by the editors of TechTarget’s Enterprise Applications Media Group. For more information, please visit http://www.silvercreeksystems.com/PR_SDMPOY2008/.

30
Mar

Modeling the MDM Blueprint – Part 4

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

optionIn Part 2 and Part 3 of this series, we discussed the Common Information and Canonical Models. Because MDM is a business project, we need to establish of a common set of models that can be referenced independently of the technical infrastructure or patterns we plan on using. Now it is time to introduce the Operating Model to communicate how the solution will actually be deployed and used to realize the expected benefits.

This is the most important set of models you will undertake. And sadly, not widely accounted for “in the wild”, meaning rarely seen, much less achieved. This effort describes how the organization will govern, create, maintain, use, and analyze consistent, complete, contextual, and accurate data values for all stakeholders.

There are a couple of ways to do this. One interesting approach I’ve seen is to use the Galbraith Star Model as an organizational design framework. The model is developed within this framework to understand what design policies and guidelines will be needed to align organizational decision making and behavior within the MDM initiative.

The Star model includes the following five categories:

Strategy: Determine direction through goals, objectives, values and mission. It defines the criteria for selecting an organizational structure (for example functional or balanced matrix). The strategy defines the ways of making the best trade-off between alternatives.

Structure: Determines the location of decision making power. Structure policies can be subdivided into:
- specialization: type and number of job specialties;
- shape: the span of control at each level in the hierarchy;
- distribution of power: the level of centralization versus decentralization;
- departmentalization: the basis to form departments (function, product, process, market or geography).

In our case, this will really help when it comes time to designing the entitlement and data steward functions.

graph_galbraith_star-model1Processes: The flow of information and decision processes across the proposed organization’s structure. Processes can be either vertical through planning and budgeting, or horizontal through lateral relationships (matrix).

Reward Systems: Influence the motivation of organization members to align employee goals with the organization’s objectives.

People and Policies: Influence and define employee’s mindsets and skills through recruitment, promotion, rotation, training and development.

Now before your eyes glaze over, I’m only suggesting this be used as a starting point. We’re not originating much of this thought capital, only examining the impact the adoption of MDM will have on the operating model within this framework. And more importantly, identifying how any gaps uncovered will be addressed to ensure this model remains internally consistent. After all, we do want to enable the kind of behavior we expect in order to be effective, right?

A typical design sequence starts with an understanding of the strategy as defined. This in turns drives the organizational structure. Processes are based on the organization’s structure. Structure and Processes define the implementation of reward systems and people policies.

The preferred sequence in this design process is composed in the following order: (a) strategy; (b) structure;  (c) key processes; (d) key people; (e) roles and responsibilities; (f) information systems (supporting and ancillary); (g) performance measures and rewards; (h) training and development; (i) career paths. 

The design process can be accomplished using a variety of tools and techniques. I have used IDEF, BPMN or other process management methods and tools (including RASIC charts describing roles and responsibilities, for example). What ever tools you elect to use, they should effectively communicate intent and be used to validate changes with the stakeholders, who must be engaged in this process.

Armed with a clear understanding of how the Star model works we can turn our attention to specific MDM model elements to include:

Master Data Life Cycle Management processes
- Process used to standardize the way the asset (data) is used across an enterprise
- Process to coordinate and manage the lifecycle of master data
- How to understand and model the lifecycle of each business object using state machines (UML)
- Process to externalize business rules locked in proprietary applications (ERP) for use with Business Rules Management Systems (BRMS) (if you’re lucky enough to have one )
- Operating Unit interaction
- Stewardship (Governance Model)
- Version and variant management, permission management, approval processes
- Context (languages, countries, channels, organizations, etc.) and inheritance of reference data values between contexts
- Hierarchy management
- Lineage (historical), auditability, traceability

I know this seems like a lot of work. Ensuring success and widespread adoption of Master Data Management mandates this kind of clear understanding and shared vision among all stakeholders. We do this to communicate how the solution will actually be deployed and used to realize the benefits we expect.

In many respects, this is the business equivalent to the Technical Debt concept Ward Cunningham developed (we’ll address this in the next part on Reference Architecture) to help us think about this problem. Recall this metaphor means doing things the quick and dirty way sets us up with a technical debt, which is similar to a financial debt. Like a financial debt, the technical debt incurs interest payments, which come in the form of the extra effort we have to do in future development because of the quick and dirty design choices we have made. The same concept applies to this effort. The most elegant technical design may be the worst possible fit for the business. The interest due in a case like this is, well, unthinkable.

Take the time to get this right. You will be rewarded with enthusiastic and supportive sponsors who will welcome your efforts to achieve success within an operating model they understand.

Continue with Part 5 or go back to Part 3.

22
Feb

Governing Unstructured Data Gets Easier

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

I first discussed Varonis on this blog last August in Governing Unstructured Data.

Varonis is a very interesting software company whose flagship product, the Varonis® Data Governance Suite, focuses on governing unstructured information.

Unstructured data (i.e. data that’s not stored in a structured form such as a database and which either doesn’t have a data model or has one that is not easily readable by a computer) accounts for as much as 80% of all business information. So governing and securing it properly is a huge challenge that is only made harder by the predicted annual growth rate of more than 60%, roughly three times faster than the growth rate for structured data.

And the security threat environment is getting more challenging, with examples like Heartland Payment Systems, a large credit card processing company, which was breached in an attack in late 2008 that may have compromised more than 100 million accounts.

And serious data breach incidents are increasing, according to a study by Enterprise Strategy Group, up from 30% of large organizations (1,000 or more employees) in 2005-2007, to 56% of large organizations in 2008.

So I was interested when Varonis let me know recently they’ve released version 4.0, a major new release of Varonis DatAdvantage and Varonis DataPrivilege. The increased automation and integration means that a business can get up and running with a framework for managing, protecting and monitoring their unstructured data within hours. The product can recommend and enforce permission revocations, taking the guesswork out of assigning and revoking permissions so companies can start controlling access with consistency and regularity.

What do you think? Are you including unstructured data in the scope of your efforts to govern, manage and secure your enterprise’s information? Please let us know by commenting here or on the MDM Community.

17
Feb

Top 5 Reasons Not To Master Your Data in SAP ERP

digg this | del.icio.us | Reddit | Stumble It!

We had a very successful webinar on Feb. 5th with Siperian, on the “Top 5 Reasons Not To Master Your Data in SAP ERP”.

A lot of organizations use SAP Enterprise Resource Planning (ERP) for their transaction processing, but struggle to manage their non-transactional (or master) data on customers, products, suppliers, etc.

These types of data typically require a separate Master Data Management (MDM) system – to streamline business processes, reduce costs, and increase revenue by creating a single view of the customer, product, or supplier.

To view the replay, please click here.

29
Jan

MDM and Enterprise Architecture

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Editor’s Note: Another great guest post by Joan Lawson, a talented enterprise architect who worked for one of my clients in the software industry in 2003. For more information on Joan, please see her LinkedIn profile — Dan Power

Master Data Management (MDM) may be one more Three Letter Acronym (TLA), but it’s a central point in the practice of Enterprise Architecture. Together with SOA-based applications and a robust middleware platform, an ideal architecture is readily achievable.

Let’s take an example using party data including customers and prospects. Party data may have a “system of initial record” in any of the many ERP or CRM applications that a company may have.

A message with new party data can be written to the integration platform from the CRM application. Based on business rules, a Business Process Execution Language (BPEL) system can orchestrate the data management services in the MDM hub, write the clean party data into the MDM hub, and then message the clean data to the other ERP and CRM applications.

Ditto with product master data.

In this example, customer and product dimensions in the data warehouse are managed by the “source of truth” – the MDM hub. And the fact data for the warehouse (such as quotes, orders, and service events) can be sourced from the OLTP applications.

For those interested in real time monitoring of transactional data, consider placing that data on the integration platform as well. A Business Activity Monitoring (BAM) platform taps into that data to monitor it against KPIs. And once again, the MDM hub provides the “source of truth” for the master data.

The end result? Clean, consistent master data, whether used in the business applications, the data warehouse and business intelligence platform, or in real time business activity monitoring.

Please let us know by commenting here or on the MDM Community if you’re using MDM as part of your enterprise architecture.

26
Jan

Webinar: Top 5 Reasons Not To Master Your Data in SAP ERP

digg this | del.icio.us | Reddit | Stumble It!

Siperian, an innovative provider of Master Data Management (MDM) solutions, is teaming up with Dan Power from Hub Solution Designs on a webinar titled “Top Five Reasons Not To Master Your Data in SAP ERP”.

A lot of organizations use SAP Enterprise Resource Planning (ERP) for their transaction processing, but struggle to manage their non-transactional (or master) data, including customer, product, and supplier information. These types of data require a separate Master Data Management (MDM) system – to streamline business processes, reduce costs, and increase revenue by creating a single view of the customer, product, or supplier.

Dan Power will discuss the following topics during this 45-minute webinar:

  • Why SAP ERP is not the right place to master data
  • Why a separate MDM system is required for streamlining business operations
  • How MDM and SAP ERP coexist
  • The technical attributes, strengths and weaknesses of SAP and Siperian MDM products
  • The requirements of an effective MDM system and best practices for implementation

This free webinar will be held on Thursday, Feb. 5, 2009 at 11:00 AM Pacific (y:00 PM Eastern), and will include a live question & answer session.

To register, please visit http://forms.siperian.com/content/5Reasons-SAP.

14
Jan

MDM Institute Survey

digg this | del.icio.us | Reddit | Stumble It!

Please participate in a short but important survey at http://0036f23.netsolhost.com/1q2009_mdm_update.htm

The MDM Institute is surveying people at Global 5000 enterprises with active MDM or Data Governance initiatives — e.g., enterprise architects, VPs of infrastructure, corporate data governance managers, et al within enterprises of annual revenues greater than US $1 billion.

The survey can be done in less than 5 minutes, and all respondents completing it by end-of-day Friday, January 30th will receive a scorecard report that participants can share with IT and business management during early February 2009.

Thank you on behalf of The MDM Institute team!

9
Jan

2009 Predictions

digg this | del.icio.us | Reddit | Stumble It!

In November, I attended Gartner’s second MDM Summit conference in Chicago.

One of the topics people were talking about at that conference was how well the Master Data Management market would fare in an economic downturn.  

Certainly, companies that were just “testing the waters” on MDM may cancel or slow down their initiatives, and anyone making the front pages or the nightly news (and not in a good way) is probably going to see some disruption to their Master Data Management efforts. 

But I’ve been pleasantly surprised by how much interest and activity we’ve seen, particularly since 2009 started. 

Friends in the MDM space report getting a slew of new opportunities recently, especially in the healthcare and pharmaceutical industries. Industries like that are doing relatively well, and even in affected industries like retail, some companies are “swimming against the tide” and investing into the downturn, looking to take market share and revenue from their competition who are cutting investments and going into hibernation mode. 

Barney Beal on SearchDataManagement.com described the picture at BJ’s Wholesale Club:

[John Polizzi, senior vice president and CIO] “Our plan was not an investment in a master data management (MDM) system, or an ERP implementation, or a point of sale (POS), but rather all of them — and more.  BJ’s is embarking on a five-year transformation of its IT infrastructure and systems.”

Philip Lay, managing director of TCG Advisors, who spoke at the Gartner conference, said “now is the time to buck conventional wisdom and ‘think like a contrarian’ when it comes to MDM.”  Lay advised the attendees “the key to making a successful business case for MDM is to tie MDM to specific, broken business processes” and quantify that impact. 

I wrote an article for DM Review on “Easing into Master Data Management” which describes how to get started by building a data governance program first, with existing resources and applications, and tackling data quality and data integration as predecessor steps to MDM.

Certainly, one of the classic drivers for MDM has always been reducing costs – and that’s even more important in a recession (look for a guest post on this topic in a few days from Ravi Shankar at Siperian). 

But even more important is to grow the “top line” – to increase revenue and pull customers away from your competitors, through better information, better customer service, better products, better pricing, you name it.

In 2009, I predict the MDM market will be affected somewhat by the recession, but it will still be one of the fastest-growing software segments, as Gartner has been predicting too.

But let’s tap into YOUR collective intelligence – what do you think? Please comment here or on the MDM Community.

2
Jan

New Year’s Resolutions for Hub Designs Blog

digg this | del.icio.us | Reddit | Stumble It!

Courtesy of Sally M.

Courtesy of Sally M.

Although 2008 was a tough year for many people, it was a great year for this blog. 

We wrote some well-received articles, and learned a lot about Master Data Management, Data Governance, blogging and social networking. We had almost 13,000 page views for the year, growing more than 20% per month.

In 2009, I’d really like to keep improving this blog. But to do that, I need your help.

Here are the top three New Year’s resolutions for the Hub Designs blog.  If you think there’s something I should add, please let me know by commenting here.

(1) More and Better Posts! Content is king for a blog. I’ve gotten a lot of great feedback, and the blog has surely gotten better over the past year, but there’s plenty of room to improve. We can share our perspective on MDM news and announcements, provide more “MDM 101″ articles on core components of MDM technology, and share more insight on the “people” and “process” aspects of Master Data Management and Data Governance.

(2) More interaction with the MDM community – We’ve got the Hub Designs web site (which you can join using Google Friend Connect), this blog, our monthly newsletter, our articles & presentations, and we participate regularly on Twitter.  We recently started an MDM Jobs Board and an online MDM Community. We also maintain a Twitter Group and a Squidoo Lens on MDM, and we try to be active in the relevant LinkedIn Groups.

But there’s more I could do. Two ideas I had recently were an “MDM People” section, where individuals looking for new positions could list themselves for free, and “office hours”, where I’d make myself available for 1-2 hours per week to answer questions on MDM and Data Governance (I’d probably use the MDM Community’s online chat function for that).

(3) More thought leadership — I spend a considerable amount of time staying current on trends in MDM, and trying to “look around the corner” to envision changes and disruptions that may be coming in the next few years. In addition to sharing them with our consulting clients, we’ll try to include more of that here, so you’ll be able to stay on the cutting edge as well.

So that’s my starting point on what we can do to improve in 2009. What should do more of? Less of? What should we change? Please give us your thoughts by commenting!

15
Dec

Top Posts for 2008

digg this | del.icio.us | Reddit | Stumble It!

I thought I’d recap our “Top 10 blog posts for 2008″ for anyone who might have missed some of them. 

  1. Ten Best Practices for Master Data Management – by far our most popular post (with thanks to MDMSource.com for featuring it)
     
  2. Our MDM Partnership Strategy — discusses our vendor-neutral strategy for partnering with the MDM hub vendors
     
  3. Different Styles of MDM Hub — outlines differences between Registry, Transaction and Hybrid style hubs
     
  4. MDM Business Case Creation & ROI Analysis — links to a “one-pager” on our Business Case Creation & ROI Analysis service
     
  5. How Master Data Management is Similar to ERP – talks about the similarities in organizational disciplines and processes between ERP and MDM
     
  6. Metadata and Master Data Management — discusses what metadata is and different approaches to managing it in the context of MDM
     
  7. Critical Data Quality Questions – outlines four “hard questions” relating to data quality and MDM and suggests ways to answer them
     
  8. Building a Data Governance Organization – five points to keep in mind as you build your data governance organization
     
  9. Five Essential Elements of MDM — technology (hub, integration, data quality, external content) and organization/process (data governance) required to succeed with MDM
     
  10. Importance of Integration to MDM — piece urging MDM project champions to think about the role and importance of data integration

These have all been read 100-800 times in 2008.  If you’re interested in my articles in DM Review and speaking engagements, they’re outlined on the Publications page of our web site. If you use Twitter, you can follow me here.

Thank you all for reading this blog!

13
Dec

MDM: Buzz-Worthy But Not A Back-Breaker

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

I saw an interesting post by Thomas Wailgum the other day called “MDM: Buzz-Worthy Since 2000, But Still a Back-Breaker”.

While I don’t agree that “there’s ongoing uncertainty as to when to take [MDM] seriously”, he does make some good points.  The software vendors who’ve flocked to MDM and put the MDM label on everything under the sun have certainly confused the market.  

Even so, the MDM software market grew 24% from 2007 to 2008.  In spite of the tough economic times we’re currently in, that rapid growth rate should continue for the next several years. 

One area I don’t agree with is the statement “it’s just plain hard to do … and even harder to do well”.

Don’t get me wrong, I’m not saying Master Data Management is easy.  But I think it’s eminently “doable” if you:

  • get yourself and your team educated on what MDM is all about and what it can do for your company
  • develop a compelling MDM strategy that aligns well with your organization’s long term strategy
  • get folks from the business and management on board through education, communication and evangelization
  • create a strong business case and use it to manage expectations throughout the lifecycle of the project
  • thoughtfully select the essential components (hub, integration, data quality, external content) and plan for data governance
  • after starting your data governance program and selecting the technology components, follow some best practices for MDM implementation

Of course, there are going to be some failures along the way.  But I come from the Enterprise Resource Planning (ERP) world, where a typical project was 1-2 years in length and cost in the tens of millions of dollars.  To me, MDM doesn’t seem like a back-breaker.  It seems like a great way of breaking down the walls of the typical corporate silos, complying more easily with ever-growing government regulations, increasing revenue by becoming more customer-centric (which in a recession, can make a big difference), and saving money through more efficient processes and consolidating out-dated systems.  

What do you think? Please let us know via a comment here.

6
Dec

MDM Jobs

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

After discussing it with a few friends involved in Master Data Management, I decided to add an “MDM Jobs Board” to this blog. 

Right now, there is no comprehensive source of information on MDM and Data Governance opportunities. MDM Jobs will be that source. 

This blog is getting about 2,000 visits per month right now, and it’s been growing an average of 23% every month over the last year. Our readers are business and IT professionals who are passionate about MDM and Data Governance. 

Each job posted on MDM Jobs will also be featured in our “Best Practices in Master Data Management” newsletter, which goes out each month to more than 3,350 people. 

To post a job, just send an e-mail to mdmjobs@hubdesigns.com.  We’ll send you a simple template to fill out and return. The cost is $100 per month for each position listed, and we accept PayPal, American Express and company checks. 

Please let me know by commenting here what you think of this idea – I’d love to get your feedback!

To give you an idea of our reach in this area, this article has been read 460 times since I wrote it on Saturday Dec. 6th.  And it’s listed #5 on Google, #1 on Yahoo and #1 on Microsoft Live Search for the search “MDM Jobs”.

26
Nov

November Column in DM Review

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Here’s a brief excerpt from my latest “MDM Insights” column in DM Review.

In the past, I‘ve outlined the five essential elements of master data management: (1) an MDM hub of some type, (2) data integration or middleware, (3) data quality capabilities, (4) external content and (5) data governance.

One of the challenges of MDM is trying to make progress in all five of these areas at once, while simultaneously working across the spectrum of people, process, technology and information.

Think of it as the “big bang” approach to MDM. You evaluate and select an MDM hub, and in the process, you discover that your organization doesn’t have adequate data integration or data quality tools available. And while working with the business on what internal source systems and external content providers need to be integrated with the new hub, you realize that your organization finally needs to get serious about data governance as well. It can be a little overwhelming.

Click on “Easing Into Master Data Management” to continue reading.

As always, please let us know what you think by commenting here …

25
Nov

MDM Community

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Recently, I created an online community for everyone in the MDM community. 

After attending the Fall 2008 MDM Summit in New York, and the Gartner MDM Summit in Chicago, I was looking for a way to keep that feeling of community alive. 

Conferences like these are a great way to see old friends and to meet new people, to learn from our colleagues, to exchange best practices and lessons learned, and to investigate vendors of Master Data Management and related technologies. 

The MDM Community is an effort to keep that going after everyone heads home. 

To join, just click here. And please let me know what you’d like to see there.  And I’ll need your help to make it a place that adds value for everyone.

19
Nov

Day 2 of Gartner MDM Summit

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

I started out yesterday attending the MDM Excellence Award Finalist presentations. Asian Paints, Johnson & Johnson Health Care Systems and State Street Bank presented, and each of them told an impressive story.

It was very significant that J&J and State Street are both committed Siperian MDM customers. The announcement of the winner will be at 4:00 pm today. I’ll be heading to the airport just after the announcement, but I’ll announce it here via my phone.

I also attended a VIP session where Gartner had DataFlux speaking about the benefits of exhibiting at the conference, and had Rick Woodand from State Street Bank and Ken from W.W. Grainger gave their perspectives as attendees.

I had a great briefing with Lorita Vannah and John Evans from Kalido, and walked away from it much more aware of Kalido’s product features and their approach to analytical MDM.

I spent some time in the Solutions Showcase, and was talking with Steve Meister and Ken Kotansky from AMB Predictive Data Management. We recently signed a Service Partnership agreement with AMB, and will be using their data profiling and data quality tools on client engagements going forward. I’ve been very impressed with their product’s capabilities and by how flexible and easy it is to work with the company.

Then, I met with Julie Langenkamp, the editor-in-chief of DM Review magazine, and her colleauge David Boone. I will be writing a monthly column in the print edition of DM Review, beginning with the January issue, and we brainstormed a number of other ideas on how we can work together more closely going forward.

Towards the end of the day, I hung out at the Siperian hospitality suite. I’ve been impressed for a while now with Nancy Ellickson, Siperian’s Senior Director of Corporate Marketing.  The gathering was very well attended and a number of Siperian people were on hand, chatting with customers and potential customers. I had a great time and thought the understated, classy “California Picnic” theme was the perfect way to end the day.

I had dinner with a good friend from D&B/Purisma, catching up on things and chatting about the MDM market in general and how well Purisma in particular has been doing in 2008.

So look for the update after 4:15 or so today with the announcement of the MDM Excellence award winner!

17
Nov

Day 1 of Gartner MDM Summit

digg this | del.icio.us | Reddit | Stumble It!

First, I want to encourage everyone who reads this blog to join the free MDM Community at http://mdmcommunity.ning.com.

I’m in Chicago attending Gartner’s second Master Data Management Summit

I didn’t make it to last year’s event in Hollywood, Florida, but I’m attending this one to investigate exhibiting at next year’s event, and to keep my finger on how the MDM market is doing in the current economic climate

The first keynote session, by John Radcliffe and Andrew White, was on “Where is MDM Going Over the Next Five Years”.  Their lead-in was that MDM is more relevant than ever in today’s econonic meltdown. 

Projects will need to offer incremental value, without being too tactical. Developing a data stewardship culture doesn’t hit the capital expense budget. They recommended people focus on the “hard benefits”, efficiencies and compliance requirements, while preparing for the (eventual) upturn. And they strongly suggested developing the metrics to quantify and communicate the value of your MDM program. 

They presented the “MDM Hype Report Card”, saying that the hype cycle is at or near its peak. The links between MDM, business process management, service-oriented architecture and business intelligence remain unclear to many users.  And external service providers (in their opinion) are finally starting to add some value to MDM programs.  And they predicted that by 2012, 70% of SOA projects will fail to yield expected results unless they include Master Data Management. 

Andrew and John covered Gartner’s “Seven Building Blocks”: vision, strategy, metrics, governance, organization, process and technology, and recommended a business-driven, holistic approach to MDM, which I’ve been recommending for a couple of years now. 

I also really enjoyed “Building the Business Case for MDM” by Michael Smith.  It was an engaging but thorough review of Gartner’s recommended steps for creating a thorough business case for your MDM initiative. 

After covering the process for developing an effective business case, Michael Smith discussed how metrics can be used to quantify the benefits, and how to use the business case to manage the initiative through the entire lifecycle. 

The main argument for taking the time to create a detailed business case is the fact that without one, IT projects in general seem to have only a 50% success rate, but when the time to create a robust business case is invested, the success rate goes up to as high as 75%.  If your total project budget is high enough, that higher success rate can translate into some serious savings. 

I attended the IBM session highlighting Nationwide’s “Transformation to a Customer-Centric Organization”, and I really enjoyed the remarks by Tara Paider, their Lead Architect for Customer Information Management. 

The attendees and exhibitors I spoke to in the Solution Showcase all commented on the power of Gartner’s brand and that the 1st day of the conference was well-attended and full of good content. 

I’m a big fan of Aaron Zornes at The MDM Institute and the MDM Summit conference he puts on twice a year in the U.S. with SourceMedia. I’ve attended all six events they’ve done together in the last three years, and have spoken at five of them. 

But I see the appeal of the Gartner MDM event as well. At this stage in the development of Master Data Management, competition is a good thing – between software vendors, services firms, and conferences. It makes us all better to have another entry in the market to measure ourselves against and to strive to outdo. 

If you’re attending as well, I’d love to hear your comments here.

17
Nov

Announcing Representation Agreement with D&B

digg this | del.icio.us | Reddit | Stumble It!

BOSTON, 17-NOVEMBER-2008: Hub Solution Designs, a management and technology consulting firm that specializes in Master Data Management and Data Governance, announced today that it has signed a non-exclusive representation agreement with D&B.

Dan Power, founder & president of Hub Solution Designs, noted “Our clients typically include D&B in their Master Data Management and Data Governance initiatives, due to the accurate, complete, timely and consistent information that D&B provides.” 

“This representation agreement will allow us to license D&B information to our clients as part of their MDM initiatives, and will benefit our clients by allowing our consultants to more tightly integrate D&B information with our clients’ MDM platforms.”

About Hub Solution Designs, Inc.

Hub Solution Designs, Inc. is a management & technology consulting firm which specializes in developing and executing high impact Master Data Management and Data Governance strategies. For more information, please visit www.hubdesigns.com or blog.hubdesigns.com.

About D&B

D&B (NYSE: DNB) is the world’s leading source of commercial information and insight on businesses, enabling companies to Decide with Confidence® for 167 years. D&B’s global commercial database contains more than 130 million business records. The database is enhanced by D&B’s proprietary DUNSRight® Quality Process, which provides its customers with quality business information. This quality information is the foundation of D&B’s global solutions that customers rely on to make critical business decisions. For more information, please visit www.dnb.com.

###

Contact(s):

Dan Power
Hub Solution Designs, Inc.
+1 (781) 749-8910
powerd@hubdesigns.com

14
Nov

Alliance with AMB New Generation Data Empowerment

digg this | del.icio.us | Reddit | Stumble It!

BOSTON, 14-NOVEMBER-2008: Hub Solution Designs, a consulting firm that specializes in Master Data Management and Data Governance, announced that it has been accepted as a Services and Reseller Partner by AMB, the leader in In-Stream profiling and the source for SOA-based data governance and CDI/MDM Discovery solutions.

Steve Meister, president of AMB, stated, “It is satisfying that organizations such as Hub Solution Designs recognize AMB’s technological leadership in MDM discovery and management technology. Our SOA-based approach to delivering In-Stream profiling and Visual Match/Merge capabilities provide a unique differentiator for architecting, planning and implementing Master Data Management implementations”.

AMB’s solution’s quick installation and ease of use makes consulting firms and professional services companies gravitate to its use on large and small engagements for CDI/MDM, Data Warehouse, ERP, CRM and other Data Management projects.

Dan Power, founder & president of Hub Solution Designs, noted “Our clients are looking for robust data quality and profiling solutions with a short learning curve and a fast time-to-value. AMB provides that and allows us to quickly teach our clients how to profile and improve their data quality, as part of their Master Data Management and Data Governance initiatives.”

About Hub Solution Designs, Inc.

Hub Solution Designs, Inc. is a management & technology consulting firm which specializes in developing and executing high impact Master Data Management and Data Governance strategies. For more information, please visit www.hubdesigns.com or blog.hubdesigns.com.

About AMB-PDM New Generation Data Empowerment™

AMB Predictive Data Management™ provides organizations a complete suite of tools to identify and remediate data anomalies. Through the delivery of the core PDM™ engine, SOA-enabled through the InfoExpose client toolkit, AMB allows technical and non-technical personnel to compare profiling results to a baseline, identify changes against the baseline to identify anomalies, drill to source data to quickly identify and plan source remediation opportunities, and report through Excel and other desktop tools organizations are already familiar with, sourcing data from its open repository. Unique to the industry is AMB’s ability to find anomalies in both textual and numeric data, thereby being the only complete suite in the marketplace to address the data quality opportunities organizations must address. For more information, visit www.predictivedatamanagement.com, e-mail info@predictivedatamanagement.com or call 1-800-928-0365.

###

Contact(s):

Dan Power
Hub Solution Designs, Inc.
+1 (781) 749-8910
powerd (at) hubdesigns (dot) com

31
Oct

Keynote at Oracle BI SIG Conference

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

The Oracle Business Intelligence Special Interest Group, which is part of the Oracle Applications User Group, is hosting Desktop Conference 2008, its annual online conference, in mid-November.  

Here’s a brief description: 

“Join the Oracle Business Intelligence community in the only global, online business intelligence conference that addresses business intelligence and data warehousing topics related to the Oracle technology stack.”

The SIG president, Faun deHenry of FMT Systems, asked me to do one of the keynote sessions. 

It’s titled “Master Data Management 101″ and will be covering: 

  • what is Master Data Management (MDM)? 
  • some useful MDM and Data Governance best practices
  • what works and what doesn’t
  • importance of a holistic approach to MDM
  • how to get the political aspects right
  • the relationship between MDM and Business Intelligence

The session will be held online on Wed. November 12th at 2:45 pm Eastern, 11:45 am Pacific. Click here to see the agenda and here to register.

29
Oct

Importance of Metrics in Data Governance

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

A critical component of any Data Governance program is the tracking of data quality metrics over the life cycle of the data. When a new record enters a Master Data Management system, it does not stay static; it undergoes updates until the last transaction (and beyond).

After the last transaction, at some point, it should be purged to maintain the freshness of the data. At all these stages, the information’s quality, security and compliance can be prone to compromise. A good data governance program should address measurement at these various stages of the data life cycle. Efforts must be made to build suitable metrics, as the organization progresses through the maturity levels of its data governance program.

Here’s an example. As part of the Data Governance program, a company identified one key metric as the “number of validated Ship To addresses”. Why? Because for a significant number of deliveries, FedEx would return the package and charge the company for giving an undeliverable address. And FedEx, as part of its business process, would not let the company know what was wrong with the address or where the correction was needed.

If a company does a large volume of shipments, even a small percentage of returns amounts to a substantial cost. When a data governance program was instituted, the company ensured that for all new customers’ Ship To addresses, the Customer Hub validated the new addresses via FedEx’s web services. FedEx has an elaborate address validation and other shipment-related web services available on its web site.

The company also ensured that any other projects that touched the customer master were aware of this integration. This was published as an official data governance policy. If any other program or user attempted to update the validated address, an approval workflow was initiated. Periodic system refreshes were also developed that would end-date the validated address and create a new validated Ship To address, using U.S. Postal Service’s National Change of Address service.

For historical customer addresses, the company started doing validations of the “defective” FedEx addresses first and after that set was processed, the remaining addresses were cleansed and validated.

The most important thing to remember is that unless visibility is provided thru a data governance metric, it’s easy for management to lose sight of your accomplishments. Therefore, it’s critical to build the data governance metrics first, even before embarking on an MDM project.

28
Oct

October Column in DM Review

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Here’s a brief excerpt from my latest “MDM Insights” column in DM Review.

A recent article in the Boston Globe titled “Tougher Consumer Data Rule Adopted: Businesses Must Improve Safeguards,” described how “state regulators released new rules … ordering businesses to better safeguard consumers’ personal information.” This got me thinking about the often-overlooked relationship between master data management (MDM), data governance and data security.

Companies that don’t have MDM capabilities yet usually don’t have a data governance organization either. But it’s a critical best practice to implement MDM technology in concert with developing a data governance organization (if not already in place).

Click on “Data Security in Master Data Management” to continue reading.

And please let us know your thoughts by commenting here …

27
Oct

Business Process Execution Language and MDM

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

Most IT organizations have to support a wide variety of enterprise software.  The legacy applications have proven their reliability over time, in spite of some performance or support issues. The new breed of Java or .Net applications can be complex to code, mostly because their business rules are not well-documented.

The end result is that to support a single business process like “Order to Cash”, multiple applications spread across multiple operating systems and databases are a reality for most IT organizations.

These applications can talk to each other either through point-to-point (tightly coupled) integration or through an Application-to-Application (A2A) (loosely coupled) integration. The latter is emerging as a new trend and is gaining ground among many leading IT shops.

Business Process Engineering Language (BPEL) enables an IT organization to build a single business process, spanning multiple applications thru A2A integration and maintaining the state of each business process instance. This is accompanied by a tool called Business Activity Monitoring (BAM), where one can monitor each activity for a given business process.

To connect BPEL to multiple applications, several approaches can be used. One is to use web services, another is simple file transfer, and a third approach is to use message queues to exchange XML messages. For connectivity to popular CRM and ERP systems, the leading BPEL vendors have come out with “adapters” that can connect their BPEL server to some popular platforms (like SAP, Oracle E-Business Suite, Siebel CRM, JD Edwards, etc.).

In any case, these servers provide tools to convert a native message into an XML message as well as perform transformations on XML messages.

The logic related to the business process resides in the BPEL server. If the business requires frequent changes to the logic, some BPEL vendors provide integration to a separate rules engine. The idea is that the business user must be able to change these rules in the rules engine using a simple interface. The changes then take effect directly in the BPEL engine. For working with external organizations, BPEL vendors are continually providing support for EDI, HIPAA and other standard formats.

The availability of Business Process Execution Language technology and its aggressive pricing has a huge implication for MDM adoption. It dramatically reduces the cost to integrate a new MDM hub with existing source systems.

Complex logic based on the source systems can now reside in the BPEL server and an entire business process (such as creating a new customer across multiple applications) can now be visible to the Data Stewardship organization. This is an exciting event! Please comment here about what other implications BPEL might have on MDM and its adoption.

23
Oct

Trip Report on Fall 2008 MDM Summit

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

The Fall 2008 MDM Summit conference ended a couple of days ago.  Here’s a quick trip report summarizing it. 

I’ve attended the last six MDM Summit events in the U.S. and have spoken at five of them.  I always enjoy them, because of the great job that SourceMedia and The MDM Institute do, because I enjoy seeing everyone I’ve come to know in the MDM world, and because of the new people I meet and the new ideas I pick up. 

This year, I arrived via the Acela Express train from Boston, went straight to the Hilton New York, and attended Evan Levy’s pre-conference workshop on “Best Practices for MDM Delivery: Lessons from the Trenches”. 

Most people who attended one of the pre-conference workshop came to the Experts and Analysts Panel, with Jill Dyché, Aaron Zornes and myself, moderated by Jim Ericson, Editorial Director of DM Review.  The panel was a lot of fun.  I’ve known Aaron for several years and continue to appreciate the quality and depth of his analysis.  Jill’s insights were right on the money as usual, and Jim did a great job moderating and guiding the discussion. 

After the opening night reception in the exhibit hall, I ran into a friend and fellow consultant, Mani Kumar Manda from Rhapsody Technologies.  We went to dinner with Christopher Dwight, Director MDM Field Strategy from Oracle’s Master Data Management team.  We had a great time, and talked about Oracle’s Hyperion Data Relationship Management solution and the upcoming Oracle Applications Users Group COLLABORATE 09 conference.  Mani and I are involved in planning the MDM track of that conference. 

The next morning, I attended Aaron Zornes’ keynote “Milestones on the MDM Road for 2008-2009″, which I particularly like as a way to stay current on developments in MDM over the past six months.  

Tony Fisher from DataFlux gave a great talk on “Stop Kicking the Tires and Start Your Master Data Engine”.  I first met Tony at the Fall 2006 event, and I chatted briefly with him afterwards about Hub Solution Designs’ interest in becoming a DataFlux partner. 

Next was Pascal Laik, VP of MDM Product Strategy at Oracle. I’ve known Pascal for several years, since he took over for Ronda Krier in that position. Pascal laid out Oracle’s strengths in the manufacturing, telecommunications, retail and financial services industries, and included an interesting but apocryphal story about the “Battle of Ulm”, where the Russian army showed up 12 days late for the battle due to the difference between the Gregorian and Julian calendars.

Bence Gazdag also spoke about Oracle’s internal MDM efforts, and I later bumped into my friend Bill Miller, Oracle’s Director & Global Solution Owner for Data Quality Management, who was supposed to deliver that part of the presentation. 

The last keynote before lunch was by Chris Lucas from D&B and Kim Fahey, Senior Director of Information Architecture at R.R. Donnelley. Kim did a great job describing Donnelley’s MDM journey and the growing value they’ve gotten from their implementation of Purisma

I had a quick lunch, then headed off to a session on “Best Practices in DG, DQ & Identity Resolution” by Alex Bentley from Initiate Systems and Scott Drummond from Grange Insurance.  This one I really enjoyed – down-to-earth delivery by Scott, and lots of good “lessons learned”. 

I spent a fair amount of time Monday in the exhibit hall, talking to the different vendors, gathering more information, and seeing old friends working for various companies. I went to the end-of-day reception again, then headed out to a great dinner at the Blue Water Grill with Initiate Systems. 

Tuesday was a bit of a blur. I had a couple of meetings in the morning, then went to lunch with Siperian at a great Venetian restaurant named Remi near the Hilton. 

In the afternoon, I caught the “Global B2B Hierarchy Management in the High-Tech Industry” session by Jesse Weissman from EMC.  Jesse did a great job describing the challenges and corresponding benefits of managing complex corporate hierarchies in EMC’s MDM environment. 

The last session I caught was Eric Hansen from Nationwide Insurance, talking about “Data Governance and MDM – The Nationwide Experience”.  This one was very well done too, with lots of good insights into the process of developing a vision for data governance in a large-scale Financial MDM project.  

Aaron Zornes would want me to remind you about the virtual MDM Summit, which starts on Nov. 11th. 

I don’t know the dates yet for next spring’s MDM Summit, but it’s usually in San Francisco and it’s one of my favorite events of the year. 

If I met you, spoke to you, had lunch or dinner with you, or learned new things from you – thank you for making the Fall 2008 MDM Summit such a great experience!

16
Oct

MDM Summit

digg digg this | del.icio.us del.icio.us | reddit Reddit | StumbleUpon Stumble It!

In a few days, I’ll be heading to the Fall 2008 MDM Summit in New York (Sunday, 10/19/08 through Tuesday, 10/21/08).  It will be the 6th MDM Summit I’ve attended and the 5th one where I’ve spoken. 

I’ll be on an “Experts and Analysts Panel” with Jill Dyché, Partner & Co-Founder of Baseline Consulting and Aaron Zornes, Chief Research Officer of The MDM Institute.  The panel is on the first day of the conference (Sun. 10/19) from 5:15 – 6:00 pm.  For more information, go to www.mdm-summit.com/MDM/agenda.html

If you’re interested in meeting, just drop me a note at www.hubdesigns.com/contact_us.html.  

It’s always fun to meet the great people who read this blog!

10
Oct

Share Your Knowledge at OAUG COLLABORATE 09

digg this | del.icio.us | Reddit | Stumble It!

Hub Solution Designs is a member of the Oracle Applications Users Group (OAUG), and I’m the OAUG Education Committee’s track manager for Master Data Management. 

We’ve started planning next May’s conference, and we’re looking for strong papers on Oracle Customer Hub, Oracle Product Hub, and Hyperion Data Relationship Management

Here’s the latest reminder from OAUG on the Call for Papers, which ends October 31st

Oracle Applications Users Group (OAUG)

Share Your Knowledge at COLLABORATE 09!

The Independent Oracle Users Group (IOUG), Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest) invite you to share your Oracle knowledge at the premier annual conference for Oracle customers — COLLABORATE 09: Technology and Applications Forum for the Oracle Community, taking place May 3-7, 2009, Orange County Convention Center West, Orlando, Florida.

Submit a presentation proposal by Friday, October 31 to be considered to speak at this leading user-driven event and have the chance to:

  • Share best practices and tested solutions for Oracle technologies and applications.
  • Enhance your own Oracle knowledge through the peer networking and exchange.
  • Learn from Oracle experts and leaders through other education sessions.

If you are an Oracle Applications professional with an interest in Oracle E-Business Suite, Hyperion, Agile, PeopleSoft, Siebel, Oracle Retail, Communications Billing and Revenue Management and MetaSolv Software, as well as applications technology, we invite your proposals for the COLLABORATE 09 — OAUG Forum.

For more specific information about COLLABORATE 09 — OAUG Forum, including tracks, specific industry- or product-related areas of emphasis, presenter requirements and the presentation submission process, please refer to the call for presentations on the COLLABORATE 09 OAUG conference Web site.

Attention Team Oracle! All Oracle employees interested in speaking at COLLABORATE 09 are to contact Michael Neuendorff at michael.neuendorff@oracle.com. Do not submit papers through the official COLLABORATE 09 call for papers!

We look forward to seeing you in Orlando!

Important Paper Submission Dates and Deadlines

  • October 31, 2008, 11:59 p.m. EDT: Presentation abstracts due.
  • January 12, 2009: Accepted presenters notified by the OAUG.
  • January 23, 2009: Acceptance of the compliance agreement due.
  • March 8, 2009: All presentation materials including white paper and presentations are due.
Follow

Get every new post delivered to your Inbox.

Join 2,554 other followers