Home > Ask the CRM Experts > Using Microsoft CRM Questions & Answers > Tips for migrating from Salesforce.com to Microsoft CRM
Ask The CRM Expert: Questions & Answers
EMAIL THIS

Tips for migrating from Salesforce.com to Microsoft CRM

Richard Smith EXPERT RESPONSE FROM: Richard Smith

Pose a Question
Other CRM Categories
Meet all CRM Experts
Become an Expert for this site


CRM and call center FAQs
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 07 November 2007
I'm wondering about migrating from CRM applications such as Salesforce.com, ACT! and GoldMine to Microsoft CRM. What kind of testing activities should be involved to do a successful implementation? What are some challenges of CRM migration testing?

>
EXPERT RESPONSE
Organizations will choose to migrate from other applications for a host of reasons, ranging from having outgrown their existing system to reducing the costs for managing and maintaining the system. There are three critical areas to consider as part of a migration:

1) Data cleansing and conversion: Most, if not all, of the data in your current system will need to be migrated to CRM. This is simpler if you have one solution, like Salesforce.com, because it is less likely that you will encounter multiple duplicate records that are more likely with each rep's individual ACT or Goldmine database. The data generally needs to be extracted from the source application (Salesforce.com, ACT, etc.), de-duplicated, and then imported into CRM. Some data objects are more difficult to extract and import than others. Contacts, accounts, and opportunities are generally easy to convert. Notes, emails, and document attachments are generally more difficult (and more costly) to convert.

2) Application configuration: With the data ready for import, you need to make sure that CRM has been properly configured to be able to store the custom fields from your existing application. For example, you may have additional fields like Market Sector, Annual Revenues, and Number of Employees on an account in Salesforce, and you need to make sure that there is both a field and a related value, for each pick list (drop down list), for the data you are importing.

3) Customization and reporting: Some organizations enhance their CRM solution with custom functionality, reporting, or third party add-on solutions. Others leverage advanced tools to build new functionality or integrate the solution with other applications – like an ERP or financial accounting application. This is more likely with a product like Salesforce.com, and less likely with ACT and Goldmine. You will need to evaluate which of these customizations, integrations, and reports will need to be migrated to your new solution.

As part of your upgrade, it is important to plan multiple types of testing to ensure the best results possible after the deployment and conversion to your new Dynamics CRM application.

  • First, you will want test the data conversion process several times to ensure both that the conversion process functions and that the data is correctly imported into CRM. It may be helpful to have users review a subset of their data after each conversion batch to help identify any potential conversion issues.

  • Next you will want to system test the application. Generally, system test consists of reviewing the application's functionality, configuration, integration, and customization – including reporting – to ensure that the new functionality works as expected. This may also be a good time to test application performance with load testing tools to ensure the hardware and software are tuned for the expected workload one the application is deployed into production. Microsoft offers tools to test both Windows and SQL Server performance.

  • Finally, you will want to execute user tests. User acceptance testing (UAT) really has two purposes: allowing the users to develop familiarity with the new Dynamics CRM solution, and ensuring that users get to review their data and application functionality to ensure that the application functions as expected. We generally help customers develop test scripts for their users to work through during UAT that review functionality in multiple areas of the application.

    The amount and type of testing will depend greatly upon the complexity of your implementation and the total number of users in your environment. Organizations with 10, 20, or even 50 users will generally have less data migration, configuration, and customization – and thereby testing requirements – than organizations with 500 to 1,000 users. Many organizations have some level of expertise in house to manage the deployment. If you by chance do not have this experience internally, you can leverage the expertise of a certified Microsoft partner who has helped other customers implement and upgrade their CRM environment.


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


    RELATED CONTENT
    Using Microsoft CRM
    Microsoft eLearning courses for Dynamics CRM training
    Linking Microsoft Outlook contacts to Dynamics CRM
    The advantages of Microsoft CRM Online: Support, flexibility and cost
    Technology requirements for a Dynamics CRM installation
    Should we upgrade to Microsoft CRM 4.0?
    Converting and linking leads in Microsoft Dynamics CRM
    Multi-language deployments of Microsoft CRM
    How does Microsoft CRM 4.0 integrate with Microsoft Office?
    Is Microsoft Retail Management System (RMS) integrated with Dynamics CRM?
    Estimating Microsoft CRM customization or configuration costs

    CRM implementation
    Four steps for an effective mobile CRM implementation
    CRM is not dead
    Benefits of ERP-CRM integration
    CRM application integration using Web services
    Five best practices for working with CRM consultants
    CRM failure: The top six reasons CRM programs fail
    End-user experience management drives Siebel CRM success at BT
    Technology requirements for a Dynamics CRM installation
    CRM continues to disappoint
    CRM ROI quiz
    CRM implementation Research

    Software upgrades
    Oracle enhances Siebel CRM software, tinkers with gadgets
    Home Shopping Network gets ROI from a Siebel 8.0 upgrade
    Five best practices for working with CRM consultants
    Should we upgrade to Microsoft CRM 4.0?
    Microsoft Dynamics CRM 4.0: Special report
    Oracle adds single-tenant option to CRM On Demand
    Microsoft releases CRM 4.0, gears up for 2008, competition
    Some CRM users happy to wait for Fusion
    Disney details its CRM upgrade to Siebel 8.0
    Oracle rolls out CRM features ahead of OpenWorld

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    collaborative CRM  (SearchCRM.com)
    implementation  (SearchCRM.com)
    project planning  (SearchCRM.com)
    service assurance  (SearchCRM.com)
    skill-based routing  (SearchCRM.com)

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



    Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice



    Expert CRM Reviews
    CRM Webcasts
    Sales force CRM

    Find the right CRM solution according to your unique needs.
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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