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

---

Software Upgrades Arent Always the Best Move

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

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Can Group Collaboration Software Meet Business Needs?

According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More

Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator

Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More

Know-how in Microsoft Publisher

For those who still don't know, Microsoft Publisher helps computer... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

The Opera Alternative

Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

Need of Document Management System (DMS)

Document Management or Enterprise Information Management is perhaps one of... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Protect Your Most Vital Business Asset with Security Software

Homeland security, airport security, Internet security â?" these days weâ??re... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

What You Must Know About Spyware Right Now

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

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

CRM and Customer Life Cycle

Customer Relationship Management or CRM is a combination of enterprise... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

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

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Software Automation Helps Increase your Bottom Line

When you own a small business, time is money. And... Read More

Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP... Read More

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Razzle Dazzle Them

Once upon a time not so long ago, there was... Read More

10 Things You Could be Using Photoshop For, But Probably Arent

Most people don't use Photoshop to its fullest capabilities. Here... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

ERP System of the Future: Database, Business Logic and Interface

We will base our prognosis on our Microsoft Business Solutions... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

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

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More