Manage Learn to apply best practices and optimize your operations.

Tips for migrating from Salesforce.com to Microsoft CRM

When migrating from Salesforce.com to Microsoft CRM, it is important to consider data cleansing and conversion, application configuration, customization and reporting.

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?

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.

Dig Deeper on Salesforce CRM

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.