Top Five Reasons Not To Master Your Data in SAP ERP


Share on LinkedIn

Over the past two years, the demand for Master Data Management (MDM) has remained strong, despite the economic downturn. This isn’t surprising, since an effective MDM implementation is one of the few IT initiatives companies can pursue to realize near-immediate business process improvements across many different areas within the enterprise. However, the question confronting IT and business decision-makers is which MDM solution and methodology will work best to resolve their master data challenges? One possible route for many large organizations with extensive SAP implementations is to make their SAP enterprise resource planning (ERP) application suite the focus of their MDM initiatives. It seems like an enticing proposition, given the possibility of capitalizing on existing IT infrastructure, investment, institutional knowledge and so forth. Yet SAP ERP systems are not designed to support master data management, and are simply not the right place to master data.

Why Not Master Your Data in SAP ERP?
Clearly, many companies across multiple industries can benefit from MDM. But the question is how can they implement an MDM solution to achieve both long term value and advance their business initiatives? As we’ve seen in multiple MDM implementations over the last few years, successful MDM projects hinge on providing top-notch capabilities in four primary areas:

• Data modeling
• Data cleansing, matching and enrichment
• Consolidating data from multiple sources
• Managing complex corporate or product hierarchies

In a typical MDM implementation, data stewards should be able to automatically merge duplicate records, and handle survivorship of data attributes into a single “golden record.” The hub should have integrated data quality capabilities so that data cleansing continues after the implementation. It’s also critical that the hub vendor be able to provide multiple proof points, demonstrating that its product can handle more than one area of data—not just customer or product data, for instance. This kind of multiple data type capability is crucial for achieving expected ROI, as expanding the use of the hub to solve business problems beyond the scope of the original implementation area is almost always required.

Using SAP’s ERP suite as the foundation technology for an MDM implementation is problematic because, despite all the positives of ERP, flexibility is usually not associated with SAP systems. SAP ERP doesn’t offer the tools to manage master data in the ways required by today’s complex organizations. Although it excels at transaction processing, SAP ERP isn’t designed for active management of critical master data. Specifically, SAP’s data matching capabilities are too basic. Its search functions might be good at “exact match” but they are not as strong at the kind of “fuzzy searching” that is so important in uncovering duplicate entries with subtle differences. For the same reason, users are far more likely to create new duplicate customer records in SAP, and there’s no way to create a “golden copy” of master data for use across multiple heterogeneous systems, or to maintain survivorship rules for overlapping data from multiple systems.

These problems are all compounded when you have more than a single SAP instance, or different ERPs altogether, which is a very real occurrence within large corporations that have grown through mergers & acquisitions. Even without multiple ERP instances, most mid-size and larger national firms are likely to pull data from many different systems. In fact, 10 to 30 source systems is not uncommon, and heterogeneous environments are now the norm. The siloed approach to data management whereby customer-facing data is in one system, product data in another, asset data in a third, and so forth, really complicates the integration of processes, data and workflow. For these reasons, “spaghetti code” for point-to-point integration is, unfortunately, very common today.

Why Use a Separate MDM Hub?
A dedicated MDM hub provides a multitude of benefits not attainable with an SAP ERP-based master data approach. First, a dedicated MDM system is just that — dedicated to delivering the best possible manageability of your master data across the enterprise, and not just within your ERP technology stack. The focus of any high-quality, enterprise-grade MDM hub implementation is going to be on getting master data right; creating a single source of truth, with each distinct customer, product, etc. represented only once in the hub. This means you can maintain accurate, complete, timely and consistent master data through both data governance and hub technology, with robust data quality and matching capabilities.

Firms who have implemented hub-based MDM find that the hub quickly becomes the critical place for stewardship of master data between both transactional systems and analytic systems. In other words, it becomes possible to “fix it once” and then use that corrected data in back office systems, data warehouses, analytical systems, or wherever else that data is needed downstream. Further, having a standalone MDM hub helps get you away from costly point-to-point interfaces, connecting every major system to every other major system within the company (i.e. the N2 integration problem). With an MDM hub, rather than developing an interface, the organization would create a connection to an enterprise service bus. There are huge cost savings here, as the initial cost of developing conventional point-to-point interfaces is typically only one-eighth of their total cost over time.

Having pointed out the strengths and weaknesses of hub-based vs. SAP ERP-based MDM approaches, it’s important to note that these are not mutually exclusive technologies. MDM and ERP need to coexist for instance as one solution does not replace the other. From an investment perspective, it is important to leverage existing technologies such as data quality, extract-transfer-load (ETL) and data integration tools, middleware, business process management and workflow.

Investing in a Flexible MDM Platform Today is a Smarter Option
To recap, the top five reasons not to master your data in SAP ERP are:

1. SAP ERP isn’t flexible enough.
2. Master data is different and can’t be proactively managed within an SAP ERP system.
3. SAP’s ERP products weren’t designed for active management of master data.
4. Mastering data in an ERP system is much more difficult with more than one instance or when different ERPs are used together.
5. An MDM hub creates a workspace between an organization’s transactional and analytic systems meaning they fix it once and then extend it for use in back office systems and the data warehouse.

SAP tends to be “monolithic” in terms of supporting its own technology stack first, but is weaker in supporting widely used non-SAP technology. Some SAP customers are very loyal and will only buy applications from SAP. Despite the shortcomings of the current SAP MDM products they’re willing to begin adopting what’s available and will wait for the situation to improve over time. It must be said, though, that such a reactive strategy in today’s business environment undoubtedly leads to competitive disadvantage and increased costs.

Alternatively, there are quite a few SAP customers that would appreciate not being completely locked into SAP’s enterprise technology roadmap and will be more open to implementing a standalone MDM hub. Implementing master data management within the context of an SAP ERP instance might convey some modest benefits in the short term, yet to realize the full capabilities, benefits and value of master data management, a dedicated MDM is the best option. In either case, MDM is a required part of streamlining, simplifying and automating core processes within today’s complex IT environments. Given the necessity of MDM, doesn’t it make sense to chose the course that will provide greater IT and business benefits, both in the short term and the long term? Many analysts and influencers think so. In fact, wise business decision-makers are already working to define their MDM requirements and planning a thorough selection process for picking the dedicated MDM hub that’s the best fit for the business.

Ravi Shankar
Ravi Shankar is Senior Director, MDM Product Marketing, Informatica. Shankar is responsible for product and technical marketing activities for master data management (MDM) as part of the Data Quality business unit at Informatica. Shankar joined Informatica following the Siperian acquisition, where he ran product marketing. He helped position the company as a proven leader in multidomain MDM.


Please use comments to add value to the discussion. Maximum one link to an educational blog post or article. We will NOT PUBLISH brief comments like "good post," comments that mainly promote links, or comments with links to companies, products, or services.

Please enter your comment!
Please enter your name here