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

---

Instant Messaging is a Sweet Way to Communicate

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

Review on QuarkXpress 6.0

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

Microsoft CRM Implementation - US Market Lessons

Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More

Groupware and Online Collaboration: Collaboration Series #4

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

Troubleshoot Windows with Task Manager

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

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... 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

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Anti-Spyware Protection ? Holes in the Shining Armor

Looking at all the ads which promise to get rid... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

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

Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Linux Secrets

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

Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

In the new era of internet marketing the problem of... Read More

Windows x: Basic Windows ?Security? Issues

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

Microsoft Great Plains Customization Tools ? Overview

Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... 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

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... 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

Microsoft Small Business Manager Customization Options - Overview

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

Microsoft Great Plains Payroll Module Customization Scenarios

It is now common thing when large corporation selects mid-market... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

The Opera Alternative

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

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More