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
move in cleaning service Mundelein ..In the real world a "fire wall" is a fireproof... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
The world of small business accounting software can be a... Read More
Microsoft Retail Management System serves retail single store as well... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
The objective for Zandi Digital is to make available clever... Read More
We don't think about mainframe software pricing anymore, we just... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
It could just be me, but my experiences with document... Read More
All your software is stored on a hard-drive. But how... Read More
Using professional icons in your application or website can bring... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
User interfaces and accessibility are some of the most important... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Many Webmasters have never bothered to view their website's server... Read More
In today's business world it's all but impossible to escape... Read More
It is really interesting that a bug can create problem... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
I like my software simple. If it's too complex or... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Buying accounting software is a major investment. It's an important... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
insured cleaning company Highland Park ..Follow the steps below to quickly design, generate, and deploy... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Research bears that less than 70 percent of development projects... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
As we could imagine, if you are reading this article... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
The most important benefit of XML is its simplicity. Though... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
Let's say that you have a software project that's under... Read More
With many manufacturing shops heading over seas in favor of... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
The adware and spyware definitions list is very long. But... Read More
Need software to record your voice, streaming audio or musical... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Manufacturing in the USA is far away down from mid... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
| Software |