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

---

Adware and Spyware

What is 'adware'?Adware is basically software or scripts that are... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

String in Java

Handling character strings in Java is supported through two final... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for... Read More

Free Software - Powerful Alternatives to Budget-Busting Software

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

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

5 Time-Saving Tips in Microsoft Word

Whether you have used Microsoft Word for years, have just... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

7 Things to Consider Before Buying Small Business Accounting Software

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

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More

Software For Your Hard-Drive

All your software is stored on a hard-drive. But how... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks... Read More

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

What is a Document Manager without Version History?

Document Manager and Version HistoryIn previous articles I have discussed... Read More

Microsoft Great Plains SOP: Sales Order Processing

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

An Introduction to .NET Framework

.Net Framework is a platform or development environment to seamlessly... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

Great Plains Dexterity Customization Options ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More