Upcoming Events

Cloud Connect
Santa Clara
Feb 13-16, 2012

Cloud Connect brings together the entire cloud eco-system to better understand the transformation we're experiencing and promises to be the defining event of the cloud computing industry. Learn about the latest cloud technologies and platforms from thought leaders in Cloud Connect’s comprehensive conference.

Register Now!

More Events »

Subscribe to Newsletter

  • Keep up with all of the latest news and analysis on the fast-moving IT industry with Network Computing newsletters.
Sign Up
Technology Business Applications
R E V I E W  
Integrating CRM: No Pain, No Gain

  June 13, 2003
  By Lori MacVittie


TOC Issue TOC
Printer Print full article
Printer Print this page
Printer Download as PDF
E-Mail E-Mail this URL
Discuss Discuss this article
flame author Flame the author
 
  In this article
arrow
Introduction
arrow
Integration & Customization
arrow
ACCPAC CRM 5.5
arrow
Epicor Clientele 8.1
arrow
Microsoft Business Solutions CRM 1.0
arrow
Soffront CRM 8.0
arrow
FrontRange GoldMine 6.0
arrow
Executive Summary | How We Tested | Outsourcing CRM
arrow
Report Card

One thing you won't find in the marketing brochures for midmarket customer relationship management solutions is a description of how much pain you'll experience while integrating that software with your existing architecture. The vendors promise you can install a CRM system and have your salespeople selling their hearts out in less time than it takes the Roadrunner to escape Wile E. Coyote. Yet they neglect to include the 2-point-type disclaimer that reads, "If customization or integration is needed, forget it."

Your sales and customer-service teams will benefit from using the CRM system, but you must deploy, integrate and maintain it. You got the short end of that stick, so to minimize your chance of getting splinters, we've rigorously tested five midmarket CRM products in our NWC Inc. Business Applications Lab. (See inc.networkcomputing.com for more information about NWC Inc.)

NWC Inc., our mock midsize manufacturing company, uses an IBM DB2 database to store its customer information. Customers searching for specialty widgets use our order and inventory records daily. It was unwieldy to support 600,000 customers and their associated orders via simplistic, PHP (PHP Hypertext Preprocessor) and WebSphere-hosted Java servlet interfaces, which are as far from seamless as it gets.


So we asked ACCPAC International, Epicor Software, FrontRange Solutions, Microsoft and Soffront Software to supply a CRM application that would accomplish three key things: allow analysis of our customer and sales records; provide NWC Inc. customers with a self-service knowledgebase to decrease time spent on technical support; and let NWC Inc. integrate e-mail and phone communications, to better understand customers' needs. The winner would be fully integrated into NWC Inc.'s infrastructure. PeopleSoft, SAP and Siebel also were invited but declined to participate, each saying it doesn't "do" reviews. Oracle reluctantly declined to participate as its solution doesn't support DB2.

Although we considered features and functionality in our evaluation, we weighted integration and deployment issues more heavily in our report card. The software would have to import our existing data, take advantage of our authentication infrastructure (Active Directory Services) and be tailored to fit our B2C model. Customization was a key factor in our testing, as most midmarket CRM programs follow a B2B model, in which records are tracked based on company relationships, rather than a B2C model, which typically focuses on a single contact per customer. We also required customer self-service capabilities: the ability to submit incident reports, search a knowledgebase for solutions to common problems and communicate with customer-service representatives regarding orders.

Architectures



CRM Software Pricing

click to enlarge

The predominant architecture for most CRM solutions, whether targeting the large enterprise or the small- to medium-enterprise market, is a centralized server and browser client. This architecture offers a faster time to deployment, less desktop configuration and a single point of management. Some systems, such as Soffront CRM, offer both a fat client and browser access; others, such as Microsoft Business Solutions CRM and ACCPAC CRM, provide only browser access. Epicor takes the slimmed down Microsoft .Net client approach and puts a rich client, with a familiar Windows-style interface, on the desktop. FrontRange's GoldMine Business Contact Manager Corporate Edition offered only a desktop client at the time of our tests; however, the vendor released an identically priced, browser-based product, iGoldMine, just as we were finishing our tests.

Web services have found a home with CRM. All the products we tested offer SOAP (Simple Object Access Protocol) access. Epicor and Microsoft took this model further and built their software on the .Net framework. This gives their systems unprecedented customization capabilities. Although any serious customization requires programming skills and experience with Visual Studio .Net (Visual Basic .Net or C#), the possibilities are endless and far easier to integrate back into the product than customization via a conventional software development kit.

Both Epicor and Microsoft have addressed Web services' security concerns. As we poked around their APIs, we concluded that without appropriate authentication, you can't mess with the product. On the other end of the spectrum, after we pored over the ACCPAC's WSDL (Web Services Definition Language), we couldn't determine how ACCPAC handles security. The functionality is severely limited to basic operations.

We were pleased that all the products handle general data security gracefully. We prefer the easy integration with ADS offered by Soffront and Microsoft. Soffront's method of applying access rights to specific customer records via queries made it easier to group customers into territories based on existing data, such as state of residence. Microsoft and ACCPAC do a good job of applying territory-based security to records, but we had to configure records into territories manually. None of the vendors provide authentication or access via LDAP, but LDAP is less important than ADS for the midmarket.


start top Introduction Integration & Customization 

Research and Reports

Hypervisor Derby
August 2011

Network Computing: August 2011

TechWeb Careers