Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of article, where IT people could get initial directions. Even if it seems as a trivial task, we would suggest you to think about these possible scenarios: objects mapping between your legacy CRM: GoldMine, ACT, Siebel, Lotus Notes Domino. When you think about MS CRM switch over ? do you think just to transfer master records: Leads, Contacts, Accounts, or you are thinking about historical activities: emails, faxes, calls, appointments, etc?

? MS CRM Import tool. You can import contact and leads using MS CRM import, your source files should be text files and import tool doesn't validate duplicates, dirty records and similar potential pitfalls. Well, Import wizard comes free with MS CRM purchase, but in our opinion, you should just continue reading and go to the next bullet.

? Scribe. This is the first professional level option you should consider. The nicety of scribe lays in the fact that it has mappings for ACT for example and you will need just select the destination. Again, please understand that each CRM solutions has its own master and activity objects categories. Scribe should resolve 85% of your conversion issues and if not you should check with scribe. Some issues are not resolvable in scribe: Siebel email attachments, records duplications and others.

? Microsoft CRM SDK. MS CRM SDK is the ultimate tool to migrate whatever is possible and impossible into MS CRM. However ? we have to warn you that in this case we have to do custom data conversion and our programmers dedicate their time to help you out. We expect your participation in objects mapping. Plus you should be ready to allocate substantial time to test the conversion, prior to going live. So, the expectations should be set that your have to budget 50 hours or more

? Security Model Concerns. Microsoft CRM has advanced security model, and technically it can serve up to large corporation with regional and worldwide offices. In this case you usually deploy objects sharing technique and deploy teams and role (MS CRM Business Units and Sales Territories doesn't allow your CRM users to be in multiple units or at the same time serve several territories). If initial data conversion requires security consideration ? you should consider MS CRM SDK approach ? even if you have to pay higher price for the conversion. Large business should consider the risk of exposing records to unauthorized employees

? MS CRM Integration. Using MS CRM SDK you can integrate CRM with your third party financial applications, such as Navision, Axapta, Solomon, Oracle Financials, SAP, PeopleSoft. Software Development Kit allows you to integrate your custom SQL, DB2, Oracle or other ODBC and OLEDB complaint application.

Currently we are confident in MS CRM ability to automate the following industries: Aerospace & Defense, Chemicals, Oil & Gas, Advertising & Publishing, Distribution & Logistics, Beverages, Supply Chain Management (SCM), Pharmaceutical, Nonprofit, Healthcare/Hospitals, Wholesale/Retail, Manufacturing/Assembling, International Business/Multinational Corporation, Government.

You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Business Solutions partner, serving clients in Illinois, New York, California, Florida, Georgia, Texas, Arizona, Virginia, Minnesota, Canada, UK, Europe, Australia, Asia, Russia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer. You can reach Andrew: akarasev@albaspectrum.com

In The News:


pen paper and inkwell


cat break through


Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Groupware as a Document Manager: Collaboration Series #3

This article is the third of a series of articles... Read More

How to Upgrade Dexterity Customization ? Tips for IT Manager

If you have Microsoft Great Plains and support it... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Free Software - Powerful Alternatives to Budget-Busting Software

When you buy a computer, it most likely comes with... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

Where to Find Free Fleet Maintenance Software

Costs of fleet maintenance software can vary widely. It is... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Begun, The Browser Wars Have

As Mozilla Firefox nears 10% market share, with well over... Read More

Manufacturing Solutions for Microsoft Great Plains ? Overview for Consultant

Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight... Read More

PHP On-The-Fly!

IntroductionPHP can be used for a lot of different things,... Read More

Open Source Concepts: Dual Licensing Explained

We were recently faced with a decision: either to let... Read More

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

Microsoft CRM Data Import FAQ

Microsoft CRM has built-in conversion tool, however you should probably... Read More

Brand Your Websites URL With a Favicon

Have you ever noticed that when you look at your... Read More