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
Alexis limo rentals ..While I was preparing some personal background information for a... Read More
Anti-virus software is used to find, remove or fix files... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
What is a Web Database?A web database is a database... Read More
Imagine something that follows you home and sets itself up... Read More
How to delete the user? This is the first problem... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Intro This concise article will tell you in plain English... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
Usually workflow & messaging is realized in CRM and then... Read More
With thousands of web pages added to the Net every... Read More
Adware is a type of Spyware program that displays some... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Now is the time to look at an alternative to... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
In this short FAQ style article we would like to... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
Need software to record your voice, streaming audio or musical... Read More
The objective for Zandi Digital is to make available clever... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
Once upon a time not so long ago, there was... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
We would like first emphasize the change in the paradigm.... Read More
car service from Midway Alsip ..Microsoft Business Solutions ? Navision is an integrated solution for... Read More
With thousands of web pages added to the Net every... Read More
When Great Plains Software was designing and developing Great Plains... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Today's business world is fast-paced. No matter what it is... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
As seeing large number of implementations ? in our case... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
One day, you suddenly realize that your computer started to... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
Program Flow is what you think it is. How the... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
User interfaces and accessibility are some of the most important... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
Microsoft CRM is new player on the CRM software... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Just when you thought you were Web savvy, one more... Read More
Software |