Putting to Rest ERP Integration Nightmares

Updated: April 29, 2009

Stories about failed ERP implementations are more than cautionary tales; they're the stuff of nightmares. Just ask trash-disposal heavyweight Waste Management, who filed a lawsuit last year against ERP provider SAP for $100 million to cover the cost of its failed ERP implementation. And then there's the case of consumer goods giant Nestlé, who committed six long years and $200 million to its ERP implementation. Those are just a couple of horror stories that have painted ERP as a technology with a hefty price tag and painful multiyear deployment periods.

Bringing Data Together

At the crux of the problem is the difficulty most companies experience integrating enterprise-wide data into a single ERP system. "You can't minimize integration work," warned Paul Hamerman, a research analyst with Forrester Research. "It's one of the fundamental challenges that companies have with their overall business-applications footprint."

George Goodall, a senior research analyst with Info-Tech Research Group, agreed. "There are always going to be integration problems and issues regarding how to bring legacy data into a new system," he said. "There are also going to be issues about the granularity of data and at what level data should be collected."

Add-on Mayhem

Complicating the process of integrating data from an organization's disparate departments into a single database is the fact that many companies choose to build upon an existing ERP solution by adding standalone systems to accommodate unique needs and industry requirements.

"Almost all businesses have to extend or bolt on additional systems to reach certain aspects of their business that are not addressed by an ERP system," said Hamerman. "In most cases, you're not going to be able to get full coverage from a single ERP vendor so you'll have to extend or bolt on third-party solutions." For example, an insurance company may rely on a particular ERP solution for its accounting activities but turn to a third-party application to process insurance claims.

This mix-and-match approach may deepen a system's functionality, but it also gives rise to integration headaches as companies struggle to unite data from multiple best-of-breed applications. But that's not all. According to Goodall, "Integrating the brains of your employees is often a bigger issue than the straight-up data integration." That's because, he said, "when people get a brand new ERP system, they often try to customize it so that it reflects their outdated processes; that just happens constantly."

Making It Work

Rather than run outdated workflow models on a brand new system, experts recommend that companies integrate an ERP solution's fresh capabilities with day-to-day business practices. Alas, it's easier said than done. Which is precisely why so many companies turn to systems integrators and IT consultants to assist with the implementation of an ERP system.

"Very few enterprises have the technical and business savvy they need to fully revamp business processes and implement software, so consultants do play an important role in enabling people to get through the project," said Info-Tech's Goodall.

Forrester's Hamerman agreed. "IT shops are often resource-constrained when it comes to major projects so they do tend to use skilled third parties to help them [with ERP implementations]," he said. "It's good to use specialized expertise."

Nevertheless, external assistance doesn't absolve companies from having to step up to the plate and ensure a smooth ERP implementation and data-integration process. "Companies need to have good project-management practices in place to make sure they don't run into significant project delays," said Hamerman.

Featured Research
  • Best ERP Features and Benefits for Your Business

    Are you considering investing in ERP software for the first time? Or maybe you already have an ERP solution but you’re worried it’s becoming dated. If either of the above apply to you, read our latest guide on the top ERP features and benefits based on the size of your business. You may be surprised at how versatile and cost-effective it is becoming - regardless of if you own a small business or run a large enterprise. more

  • 8 Ways the Cloud is Changing ERP for the Better

    What if there was a tool available that allowed for you to save up to a quarter of your operational costs? Studies have shown that Enterprise Resource Planning (ERP) solutions enable businesses to access accurate, real-time information about daily operations which allow for the reduction of operational costs of up to 23% and administrative costs of up to 22%. more

  • 7 key questions to ask any ERP provider

    Having a fast-growing business is good. Having to overhaul your technology every time you need to scale is not. Upgrading to a more complete Enterprise Resource Planning (ERP) solution can help, but how do you ensure the solution you choose is exactly what you need? To help you with your search, we’ve pulled together 7 key questions every fast-growing business should ask before choosing a cloud-based ERP solution, including: more

  • How Finance Leadership Pays Off

    Oxford Economics recently surveyed 1,500 finance executives and it’s clear that small and midsize companies are growing significantly faster than larger companies. But, there are also big opportunities for finance to increase efficiency, boost financial performance, and work more strategically. Why is that? more

  • Professional Services Audience – Improve Profitability Infographic

    As a Professional Services Organization (PSO), you know the importance of customer satisfaction. In fact, 47% of PSO leaders say managing changing customer expectations is their top challenge. That’s why many firms are engaging smarter project management technology, even before deals are signed, to ensure project profitability. How are these leaders utilizing technology? Find out now. more