Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software market. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc.

If you are software developer, database administrator or web designer who is asked: how do we customize Microsoft CRM ? we are giving you directions in this article.

  • Microsoft CRM SDK ? this is software development kit with C# and partly VB.net code samples ? it is supported by Microsoft Business Solutions technical support. It is based on web service calls, if you are C# .NET developer ? you are excellently positioned to do this type of customizations. This is the preferred modification scenario and this should be easily upgradeable customization. VB.Net examples will be available soon.
  • Legacy SQL Data integration. This is also easy and safe. If you have SQL database, sitting on the same or linked SQL Server ? you can create ASPX .Net application and simply integrate it into CRM. You can place it on the navigation bar or menu in isv.config ? please refer to MS CRM SDK
  • Legacy ASP integration ? this is somewhat more sophisticated. You have to deploy HTTP handler to be a middle party between CRM which is .Net based and ASP which is legacy IIS. The trick is ? you have to have INI file with security settings to penetrate into MS CRM with proper credentials, calling web service.
  • Microsoft Exchange Programming. Microsoft CRM has Exchange connector ? which moves CRM incoming email to MS if it has GUID in its subject. You can alter this logic (for instance - move email to CRM if it doesn't have GUID but it is from the sender who is contact or account in MS CRM). Refer to MS Exchange SDK onsyncsave event handling. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.
  • Direct SQL touch ? in #4 above I described you the scenario with MS Exchange handlers ? this would be ideal world if MS CRM SDK does the job. But ? in real world this is not always true ? you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc). This is not supported by MBS technical support ? but you can rescue to this technique if you have to get job done.
  • MS CRM Customization tool ? this is rather end-user tool and we don't describe it here ? read the manual. We've described above the options to use when this tool doesn't do the job
  • Crystal Reports - feel free to create Crystal report - tables and views structure is self explanatory. Try to avoid the temptation to create your own SQL view or stored procedure in MS CRM database, instead - create custom database and place your view and stored proc in it.

    • Happy modifying! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    pen paper and inkwell


    cat break through


    Beware of The Pirated Software E-Mail Scams!

    You have gotten those E_Mails buy software at deep discounts.... Read More

    How To Avoid Getting Hooked By Pfishing

    "Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

    Troubleshoot Windows with Task Manager

    Task Manager is a Windows system utility that displays thetasks... Read More

    Begun, The Browser Wars Have

    As Mozilla Firefox nears 10% market share, with well over... Read More

    Demand More From Your Lead Tracking Software

    An integral part of any quality CRM system is lead... Read More

    Linux Dual Boot-How To Format

    Just the thought of a duel-boot scares many people away,... Read More

    Microsoft CRM Development

    Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

    Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

    In the case when you represent mid-size or mid-size-to-large business,... Read More

    Microsoft Great Plains BR: Bank Reconciliation

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    What To Do When Windows Wont Boot

    When Windows fails to boot it is normally caused by... Read More

    Adware, What Is It?

    Adware is a type of Spyware program that displays some... Read More

    Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

    All of us know that Microsoft bought former Great Plains... Read More

    Microsoft CRM Customization Secrets ? Second Edition

    This article is for advanced Microsoft CRM SDK C# developers.... Read More

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

    Some introduction into Great Plains Software products, now Microsoft Business... Read More

    Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

    Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

    Collaboration Software: Index of Collaboration Software Technologies

    Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

    Free Program Removes Spyware not Detected by Premium Security Scan

    What is Spyware?Spyware monitors your surfing habits and sends the... Read More

    Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

    Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

    Linux for Home Users

    Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

    Review of TikiWiki Content Management System

    TikiWiki is open source software - it is written in... Read More

    Lotus Domino Implementation and Development: Infrastructure ? Present and Future

    Domino server is a buffer between the operation system and... Read More

    Microsoft CRM Customization: Integration with Third Party SQL Application/Database

    Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

    Is Your Small Business Ready For A CRM Software Solution?

    I have yet to see a business that, sometimes in... Read More

    Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

    Enabling Chinese input is quick and easy, there are only... Read More

    Microsoft CRM USA Nationwide Remote Support

    Remember old good days when your company probably had Great... Read More

    SQL Administrator Skills Required to Support Microsoft Great Plains

    Microsoft Great Plains is becoming more and more popular and... Read More

    Your Computer May Be Infected, Heres How To Check (NOT about virus)

    NOTE: Please take time to read on - it may... Read More

    Corporate ERP Selection: Microsoft Great Plains

    In our opinion, traditional approach when you select ERP/MRP system... Read More

    Helping Newbies Understand Professional Software

    The Windows registry is a huge database that ensures normal... Read More

    eCommerce development for Microsoft Great Plains: tools and highlights for programmer

    Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

    Free Microsoft Word Online Training Tutorial Resources

    Microsoft Word is one of the most popular office applications... Read More

    Is Software Tester a Most Infamous Person in a Software Project Team?

    The fact that a software tester is a most infamous... Read More