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
last minute cleaning help Northbrook ...ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
Just the thought of a duel-boot scares many people away,... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
This article will not attempt to advocate the use of... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
I've been active in the Cisco Certification track for four... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
It's not very often I get excited about a software... Read More
Introduction: The creating of a computer program involves a number... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Program Flow is what you think it is. How the... Read More
Microsoft Word is one of the most popular office applications... Read More
Handling character strings in Java is supported through two final... Read More
We are in a transition phase in the Managerial Administration... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
We'll give you non formal view, based on our consulting... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
efficient cleaning crew Arlington Heights ...Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
We are in a transition phase in the Managerial Administration... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
I love new technology. I am still ready to wait... Read More
The Windows Indexing Service provides you with the ability to... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
In the previous ISDN article, we looked at how and... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
ERP Consulting industry is on the way to serve clients... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
The software giants don't do everything and don't always produce... Read More
Anti-virus software is used to find, remove or fix files... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
Let us give you - developer some hints in the... Read More
C++ Function templates are those functions which can handle different... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Software |