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
professional maid services Glencoe ..I suggest that you do not spend a lot of... Read More
The purpose of one of our projects was MS Exchange... Read More
Microsoft CRM is now on the scene and it is... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Do you want to get quality software at a reasonable... Read More
Accounts payable is just one area of office management where... Read More
Music downloads are off the charts! We're listening to digital... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
The Internet is reshaping every form of communications medium, and... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Shareware is software that you can try before you buy;... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Let's say that you have a software project that's under... Read More
This is a short article, written in question/answer/FAQ style to... Read More
If your company has regional and worldwide operations, you might... Read More
Introduction: The creating of a computer program involves a number... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
The software giants don't do everything and don't always produce... Read More
With any good luck and a good amount of hard... Read More
last minute cleaning help Lincolnshire ..In our small article we'll consider Microsoft Business Solutions Great... Read More
XML parser is a software module to read documents and... Read More
Almost all new and major brand of PCs come with... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
To all web designers out there, this article is for... Read More
We all already got used to computer monitoring both at... Read More
In the case when you represent mid-size or mid-size-to-large business,... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Some companies that are in need of fleet management may... Read More
First we had the original Google search that evolved into... Read More
People often ask me: What image file formats will Photoshop... Read More
This article is the fourth of a series of articles... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
The world of small business accounting software can be a... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Accounts payable is just one area of office management where... Read More
Microsoft Great Plains fits to majority of industries, in the... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Software |