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
This is the tutorial where we really get into programming.... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
What is Software?Software is a set of instruction written to... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
I like my software simple. If it's too complex or... Read More
The world of small business accounting software can be a... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
I have always had a tendency to focus on the... Read More
Almost all new and major brand of PCs come with... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
And kill the best layout software in the process of... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
There are plenty of articles out there about how to... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
Now there are Three Steps To Heaven Just listen and... Read More
In the Clinton era the status quo was simple: you... Read More
The java programming language is becoming more and more popular... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
First we had the original Google search that evolved into... Read More
Sales are all about leverage, because there is only so... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
I suggest that you do not spend a lot of... Read More
In a previous article, I wrote about OpenOffice... Read More
In order to implement VLANs in a network environment, you'll... Read More
All your software is stored on a hard-drive. But how... Read More
As we could imagine, if you are reading this article... Read More
If you look back to the history, you will see... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
I've been active in the Cisco Certification track for four... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
While Adobe is the most known maker of PDF tools,... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
The research in the field of Natural Language Processing usually... Read More
We are in a transition phase in the Managerial Administration... 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
Viruses and spyware usually show up on your computer one... Read More
People often ask me: What image file formats will Photoshop... Read More
Trying to figure out a stream in banning one email... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
Microsoft CRM is new player on the CRM software... Read More
Many Webmasters have never bothered to view their website's server... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Looks like Microsoft Great Plains becomes more... Read More
Software |