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
Great Plains Accounting, accounting package for mid-size and small companies... Read More
When you think... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Around the same time Microsoft made its move with .Net... Read More
Following tips help you to learn a software in lesser... Read More
Every day millions of new web documents emerge on the... Read More
Using professional icons in your application or website can bring... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
After almost two decades of existence, Quark has become the... Read More
The title of "software engineer" has got to be among... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
The cornerstone of successful automated office systems is the ability... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
When you buy a computer, it most likely comes with... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
As we could imagine, if you are reading this article... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
When reading an article where some term is used often,... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
If you company is small or mid-size special products or... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Crystal Reports is the most flexible tool on the market... Read More
All of us know that Microsoft bought former Great Plains... Read More
For a windows user like me, just can watch with... Read More
Almost all new and major brand of PCs come with... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
When you need a phone number, you do a quick... Read More
There is many things more frustrating than surfing a website... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
Need software to record your voice, streaming audio or musical... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
It is now common thing when large corporation selects mid-market... Read More
When Great Plains Software was designing and developing Great Plains... Read More
We would like first emphasize the change in the paradigm.... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Software |