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


Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

And kill the best layout software in the process of... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

Manufacturing in the USA is far away down from mid... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

How to Get The Best Accounting Software For Your Small Business

Buying accounting software is a major investment. It's an important... Read More

Microsoft Great Plains Integrations - Tips for Developer

In this short FAQ style article we would like to... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Design a Web Album Using Adobe Photoshop- Part 2

So let's begin crunching down these 300 images using Adobe... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

Brand Your Websites URL With a Favicon

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

eConnect: eCommerce Development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable... Read More

Software Upgrades Arent Always the Best Move

When my daughter was getting into AOL instant messaging (AIM)... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

What You Must Know About Spyware Right Now

Spyware is like the new technological nuclear weapon on the... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More