CRM Watcher

CRM Watcher is the source for the latest Microsoft Dynamics CRM News and Downloads.

Sunday, April 30, 2006

Several ways to import data

Microsoft CRM includes five tools for importing data, each of which is designed for specific source data: Bulk Import Wizard, Data Migration Framework, Data Migration Wizard for Microsoft Office Outlook with Business Contact Manager, Microsoft Dynamics CRM Connector for Microsoft Dynamics GP and Microsoft CRM SDK.

The Bulk Import Wizard imports your leads, contacts, accounts, campaign responses, and marketing list data. It is built into Microsoft CRM and can be used easily on an ongoing basis by a sales or marketing representative. All imported data is owned by the user who imports it.

The Data Migration Framework, part of the Microsoft Dynamics CRM 3.0 Data Migration Pack, is typically used when you first implement Microsoft CRM to bring all data from all your legacy databases and systems into Microsoft CRM.

If you’re switching from using Microsoft Outlook with Business Contact Manager to using Microsoft CRM, you can use the Data Migration Wizard for Microsoft Office Outlook with Business Contact Manager, part of the Data Migration Pack. The wizard guides you through mapping data from Outlook with Business Contact Manager to Microsoft CRM. It must be run by a person with the Microsoft CRM System Administrator security role and is designed to be run only once.

If you need to migrate data from Microsoft Dynamics Great Plains 8.0 or Microsoft Dynamics GP 9.0 to Microsoft CRM, and then keep the data synchronized between the two applications, you can use the Microsoft Dynamics CRM Connector for Microsoft Dynamics GP. This tool provides ongoing synchronization of data, as well as data migration and correlation between the two applications.

If you need to migrate data into a custom entity, use the Microsoft CRM SDK to create a custom program to migrate your data.

Read more

Scribe Adapter for Microsoft CRM (Third Party Tool)
The Scribe Adapter for Microsoft CRM combined with Scribe Insight technology platform enables you to interact with Microsoft CRM web services API through a graphical user interface, without having to write any code. Select the objects you wish to integrate with, and it’s just point, click, and go.

Read more

Don't forget to remove the restricted access user option when migrating data!