Microsoft CRM was designed to be easily customizable. Microsoft CRM Software Development Kit (MS CRM SDK) which you can download from Microsoft website contains descriptions of the objects or classes, exposed for customization. It has sample code in C# and partially in VB.Net. In Visual Studio.Net you can analyze all the classes, used by Microsoft developers to create MS CRM - you will discover that most of them are not documented in MS CRM SDK. Microsoft will not support your customization if you use undocumented class or do direct SQL access to CRM database.
Let us describe you - programmer, software developer typical cases of MS CRM Customizations.
1. Integration with SQL Server application. If you have legacy system on MS SQL Server - let's say you are transportation company and have in-house developed cargo tracking database. Now in MS CRM you want lookup the shipments for the customer (or account in CRM). This is SDK programming and calling SQL stored proc to retrieve cargo info. Instead of SQL Server you can have other database (ORACLE, MS Access, PervasiveSQL to name a few) - you can access multiple Database platforms via ADO.Net connection from your .Net application, which is easily integrated into MS CRM Account screen.
2. Email capturing in MS CRM. You have customer with email Bill@customer.com. Now you want all the emails that you receive from customer.com domain to be attached to Bill who is account in CRM. This is more difficult customization - you have to create MS CRM SDK web service, that one will be creating email activity and call it from COM+ application - Microsoft Exchange event handler (ONSYNCSAVE database event sink). This example maybe complicated with the following requirement. Imagine that Bill, instead of answering to your email (sent from CRM and processed by CRM-Exchange connector) sends you new message from MS Outlook. Then this email will not follow into MS CRM (because it doesn't have GUID in the header and so is ignored by CRM Exchange connector). If you want to capture these emails - you have to do it in Microsoft Exchange event sink. There maybe scenario when you want to capture and analyze in the sink all the outgoing emails - this is even more complex - y!
ou have to place the sink on transport event.
3. ASP Application integration. You have legacy ASP application, where you capture orders from your customers and you want these orders be transferred to the CRM as activity. Here you understand that ASP doesn't deploy Active Directory security - and the best way is to create HTTP handler and call it from your ASP page. This HTTP handler in turn will call MS CRM SDK web service with predefined (web.config) Active Directory credentials.
Some cautions. Never create your custom SQL objects (like stored procedure, SQL view, table) in MS CRM database. Instead, create your own database and place your objects there. When you see the first caution - you will never try to alter existing CRM objects, like adding new field to the table.
Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Microsoft CRM SDK, Great Plains Dexterity, SQL, C#/VB.Net and Crystal Reports developer; akarasev@albaspectrum.com
limousine chicago serviceYou probably didn't casually invite, or extend a formal attendance... Read More
Are you a whiz at calculating financial information? Not the... Read More
If you are in the market for new staffing software,... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Is your PC is slow and wimpy? Then you need... Read More
Accounts payable is just one area of office management where... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
The purpose of one of our projects was MS Exchange... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
Once upon a time not so long ago, there was... Read More
If you would like to pick something from Microsoft, or... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
After seeing many people complain about their weak Internet security... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
In the real world a "fire wall" is a fireproof... Read More
Well, even if the combination might look very unusual, we... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
We would like to give you several situations, when you... Read More
solar power street lights parking garage lighting fixtures Pete's produce ..Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Should one use Windows Update?This topic has good and valid... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
We were recently faced with a decision: either to let... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
In this article you will find some background information about... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
All of us know that Microsoft bought former Great Plains... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
The intentions of this short tutorial are not to teach... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
Once a business idea is selected, it is highly recommended... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Just the thought of a duel-boot scares many people away,... Read More
The most important benefit of XML is its simplicity. Though... Read More
Did you ever give a thought to the number of... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Software Software |