CRM Microsoft Software Implementation Tips
Microsoft CRM is CRM answer from Microsoft Business Solutions. If you compare it to other traditional CRM applications, such as Siebel - you will see that Microsoft CRM does use all the resent Microsoft technologies, that means that Microsoft targets its CRM to Windows market exclusively, plus this means that Microsoft CRM is more difficult in its installation. Microsoft doesn’t even have to care about other platforms, such as Linux/Unix or Apple.
Outlook Client. This was very bright idea from Microsoft side to have outlook client as a presentation for Microsoft CRM data. Outlook has such nice features as synchronization and then working offline. If you have outlook client for CRM - you can download your customers, leads, contacts, and event properly programmed custom features, then work with them and finally synchronize them back to MS CRM database
MS CRM Integration. As the task itself it is not difficult or challenging one. You can deploy MS SQL Server linked server to show your third party or even heterogeneous data on MS CRM screens. However, when we are talking about enabling working offline - we should get different approach. Your third party system should feed data into MS CRM database - through MS CRM SDK custom utility. In CRM itself you should stick to MS CRM user defined fields. If you take this direction - MS CRM custom features will be taken by Outlook client and synchronized with local machine. Your third party data could reside as it was mentioned in heterogeneous platforms: Oracle, DB 2, Sybase, Lotus Notes Domino, SAP, Pervasive SQL 2000, Ctree or any ODBC compliant database.
Transportation Companies - about 30% of our clients in the States are transportation and freight forwarding companies. This actually proves the hypothesis that MS CRM is very simple solution - these companies usually do not have extra money to spend on their computer system, but need the solution for its sales people to instantly see the cargos, plus have simple customization, allowing them to integrate with legacy system.
Customization Tools. Visual Studio.Net is the first to mention, where you can create web application for MS CRM in VB.Net or C#.Net. Then you should use Crystal Reports Enterprise to expand reporting functionality. You use MS SQL Server scripting to pull the data from third party system (but not to update data in the CRM - you should use MS CRM SDK for this purpose
Data Massage and initial conversion. Implementing MS CRM is often about switching from your existing contact management system, such as ACT!, Gold Mine and similar. Data conversion in the form of initial master records import and balances could be done by various tools, such as Scribe or native MS CRM integration utility.
