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 (help@albaspectrum.com), he is Microsoft CRM SDK, Great Plains Dexterity, SQL, C#/VB.Net and Crystal Reports developer; help@albaspectrum.com
shuttle from O'Hare Bingham .. Lockport Chicago limo O’HareFormer Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
One of the things we can be as certain of... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
It is really interesting that a bug can create problem... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
This article is the first of a series of articles... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
There are plenty of articles out there about how to... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
Let us give you - developer some hints in the... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
In this short FAQ style article we would like to... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Think of this, first we had the HAM Radio, then... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Our hosted solution allow you to run your own search... Read More
Microsoft CRM is new player on the CRM software... Read More
Mishawaka limo O'Hare ..The Software 2005 conference is now a wrap. This conference,... Read More
Background: For many organizations like ours, the interim target of... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
How to delete the user? This is the first problem... Read More
The major reason I recommend getting your hands on real... Read More
I have always had a tendency to focus on the... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
Google Inc. has launched a new software package that allows... Read More
How do you run a program on a remote server... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
This article is the third of a series of articles... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
You've finally created databases that you can actually use to... Read More
Although statistics often is blamed for various deadly sins --... Read More
Considering whether or not your software company should hire a... Read More
If you are software developer or database administrator - we... Read More
So, why should you use any O/R mapping tool? I... Read More
Adware is a type of Spyware program that displays some... Read More
We were recently faced with a decision: either to let... Read More
Before being able to choose a secure Internet communication system,... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
An integral part of any quality CRM system is lead... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
In the early days of the personal computer, we're talking... Read More
Software |