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
shuttle from O'Hare Bingham .. Lockport Chicago limo O’HareIf you have Microsoft Great Plains and support it for... Read More
Do you remember that frustrating feeling when you find an... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
Google Inc. has launched a new software package that allows... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Every day millions of new web documents emerge on the... Read More
The Windows Indexing Service provides you with the ability to... Read More
There are many commands that are used in linux on... Read More
The most important things you can do for your computer... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
Let's say that you have a software project that's under... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
I have yet to see a business that, sometimes in... Read More
New post-recession era has new features, which didn't exist in... Read More
Imagine something that follows you home and sets itself up... Read More
Are you lost in the mess of documents that get... Read More
There is many things more frustrating than surfing a website... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
Mishawaka limo O'Hare ..Have you ever noticed that when you look at your... Read More
Now there are Three Steps To Heaven Just listen and... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Now that spyware is the single most dangerous threat to... Read More
Remember old good days when your company probably had Great... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
The purpose of Project Management Software is to provide an... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
I have always had a tendency to focus on the... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Fortunately one of the most common reasons cited for the... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Today's business world is fast-paced. No matter what it is... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
What is a Web Database?A web database is a database... Read More
First we had the original Google search that evolved into... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Fleet Maintenance Management is a critical position in any company... Read More
I've been active in the Cisco Certification track for four... Read More
Software |