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
scheduled cleaning services Winnetka ..Adobe Photoshop is one of the world's leading graphics editing... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
I provide, here clear explanations and a count of function... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
I completed an experiment recently. I wanted to find out... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
The adware and spyware definitions list is very long. But... Read More
So, why should you use any O/R mapping tool? I... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
The Windows registry is a huge database that ensures normal... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
For those who are unclear on the differences between the... Read More
This article will not attempt to advocate the use of... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
1. What determines the software price? Is it Per Seat... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Beginning with Domino version R4 it has integration with the... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
reliable maid service Lincolnshire ..Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
Introduction: The creating of a computer program involves a number... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Around the same time Microsoft made its move with .Net... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
If there still are few unprotected computers left, I haven't... Read More
Anti-virus software is used to find, remove or fix files... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
XML parser is a software module to read documents and... Read More
Fundraising software lets you connect with donors in a way... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
To all web designers out there, this article is for... Read More
Software |