| Microsoft CRM was designed to be easily | | | | activity and call it from COM+ application - Microsoft |
| customizable. Microsoft CRM Software Development | | | | Exchange event handler (ONSYNCSAVE database |
| Kit (MS CRM SDK) which you can download from | | | | event sink). This example maybe complicated with |
| Microsoft website contains descriptions of the | | | | the following requirement. Imagine that Bill, instead of |
| objects or classes, exposed for customization. It has | | | | answering to your email (sent from CRM and |
| sample code in C# and partially in VB.Net. In Visual | | | | processed by CRM-Exchange connector) sends you |
| Studio.Net you can analyze all the classes, used by | | | | new message from MS Outlook. Then this email will |
| Microsoft developers to create MS CRM - you will | | | | not follow into MS CRM (because it doesn't have |
| discover that most of them are not documented in | | | | GUID in the header and so is ignored by CRM |
| MS CRM SDK. Microsoft will not support your | | | | Exchange connector). If you want to capture these |
| customization if you use undocumented class or do | | | | emails - you have to do it in Microsoft Exchange |
| direct SQL access to CRM database.Let us describe | | | | event sink. There maybe scenario when you want to |
| you - programmer, software developer typical cases | | | | capture and analyze in the sink all the outgoing emails |
| of MS CRM Customizations.1. Integration with SQL | | | | - this is even more complex - y!ou have to place the |
| Server application. If you have legacy system on MS | | | | sink on transport event.3. ASP Application integration. |
| SQL Server - let's say you are transportation | | | | You have legacy ASP application, where you capture |
| company and have in-house developed cargo tracking | | | | orders from your customers and you want these |
| database. Now in MS CRM you want lookup the | | | | orders be transferred to the CRM as activity. Here |
| shipments for the customer (or account in CRM). This | | | | you understand that ASP doesn't deploy Active |
| is SDK programming and calling SQL stored proc to | | | | Directory security - and the best way is to create |
| retrieve cargo info. Instead of SQL Server you can | | | | HTTP handler and call it from your ASP page. This |
| have other database (ORACLE, MS Access, | | | | HTTP handler in turn will call MS CRM SDK web |
| PervasiveSQL to name a few) - you can access | | | | service with predefined (web.config) Active Directory |
| multiple Database platforms via ADO.Net connection | | | | credentials.Some cautions. Never create your custom |
| from your .Net application, which is easily integrated | | | | SQL objects (like stored procedure, SQL view, table) |
| into MS CRM Account screen.2. Email capturing in MS | | | | in MS CRM database. Instead, create your own |
| CRM. You have customer with email Now you want | | | | database and place your objects there. When you |
| all the emails that you receive from domain to be | | | | see the first caution - you will never try to alter |
| attached to Bill who is account in CRM. This is more | | | | existing CRM objects, like adding new field to the |
| difficult customization - you have to create MS CRM | | | | table.Happy customizing! if you want us to do the job |
| SDK web service, that one will be creating email | | | | - give us a call 1-866-528-0577! |