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
tidy up service Northbrook ..In this small article we will be looking at the... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
Google Inc. has launched a new software package that allows... Read More
Fleet Maintenance Management is a critical position in any company... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
Spyware is software or hardware installed on a computer without... Read More
And kill the best layout software in the process of... Read More
We don't think about mainframe software pricing anymore, we just... Read More
A few months back I really got sick of my... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
There is many things more frustrating than surfing a website... Read More
Anti-virus software is used to find, remove or fix files... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Are you a database professional? Do you work with a... Read More
Having from five to ten and more favorite screensavers is... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
Do you remember that frustrating feeling when you find an... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
reliable home cleaners Buffalo Grove ..The research in the field of Natural Language Processing usually... Read More
Have you ever noticed that when you look at your... Read More
Not every software testing project can or should be automated.... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
If you are software developer or database administrator - we... Read More
This short paper will expand on two key reasons to... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
This article is the fourth of a series of articles... Read More
Shareware is software that you can try before you buy;... Read More
Navision Software was purchased by Microsoft and now it is... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
How many steps does it take you to locate and... Read More
Background: For many organizations like ours, the interim target of... Read More
Do you want to get quality software at a reasonable... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
If your company has regional and worldwide operations, you might... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Software |