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
Rolling Meadows Cadillac Escalade rental .. Lockport Chicago limo O’HareGreat Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Did you ever want to erase everything on your computer?... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
One day, you suddenly realize that your computer started to... Read More
We all take the computer for granted. I mean, all... Read More
Introduction: The creating of a computer program involves a number... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
If you have been using the Internet for any amount... Read More
Whether you have used Microsoft Word for years, have just... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Microsoft Word is one of the most popular office applications... Read More
An integral part of any quality CRM system is lead... Read More
1. What determines the software price? Is it Per Seat... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
Google Inc. has launched a new software package that allows... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Spyware and malware are large problems for Internet users today... Read More
The title of "software engineer" has got to be among... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
Des Moines rental limo ..When you buy a computer, it most likely comes with... Read More
When you need a phone number, you do a quick... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
There are certain pluses and minuses in both cases and... Read More
We don't think about mainframe software pricing anymore, we just... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
It could just be me, but my experiences with document... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
Following tips help you to learn a software in lesser... Read More
If you have Microsoft Great Plains and support it... Read More
What is a Web Database?A web database is a database... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
FTP stands for "file transfer protocol". FTP is basically a... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
Now that spyware is the single most dangerous threat to... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
While I was in college, if you would have asked... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
The fact that a software tester is a most infamous... Read More
Software |