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
taxi from O'Hare Bismarck .. Lockport Chicago limo O’HareMicrosoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
We all take the computer for granted. I mean, all... Read More
Whether you have used Microsoft Word for years, have just... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
People often ask me: What image file formats will Photoshop... Read More
CD and DVD replication is a process that works by... Read More
The stakes are high when considering security, privacy, and savings,... Read More
IntroductionPHP can be used for a lot of different things,... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
So let's begin crunching down these 300 images using Adobe... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
The most important benefit of XML is its simplicity. Though... Read More
Linux essentials:It's free for download but you have to pay... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
We were recently faced with a decision: either to let... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
If you've been using MySQL database to store your important... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Are you lost in the mess of documents that get... Read More
Did you ever want to erase everything on your computer?... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Granger Lincoln Stretch limo rentals ..ERP Consulting industry is on the way to serve clients... Read More
The first topic we are going to discuss... Read More
Have you ever noticed that when you look at your... Read More
Most people understand that the "hardware" part of their computer... Read More
How many steps does it take you to locate and... Read More
The title of "software engineer" has got to be among... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
New post-recession era has new features, which didn't exist in... Read More
If you look back to the history, you will see... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Spyware is software or hardware installed on a computer without... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Crystal Reports is the most flexible tool on the market... Read More
Domino server is a buffer between the operation system and... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
Software |