Software Information

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.


    MORE RESOURCES:

    McLane Company to Control Inbound Freight With Retalix Traffic ...
    MarketWatch - 16 hours ago
    a leading provider of software solutions for distributors and retailers, today announced that McLane Company, Inc., one of the world's largest foodservice ...


    Software allows social sites to share info
    Bizjournals.com, NC - Oct 11, 2008
    JACKSONVILLE — A Jacksonville software company is knocking down walls between social networks, such as MySpace and LinkedIn, by giving users more control ...
    Going to the dentist? Get ready for the ads Youngstown Vindicator
    all 22 news articles


    SYS-CON Media

    WSO2 Named "Silver Sponsor" of SYS-CON's SOA World Conference & Expo
    SYS-CON Media, NJ - 9 hours ago
    ... Recursion Software, Red Hat, Reflex Security, Research & Markets, RadiantLogic, Ring Cube Technologies, Riptide Software, Rogue Wave Software, rPath, ...
    LinuxWorks Named "Bronze Sponsor" of SYS-CON's Virtualization and ... SYS-CON Media
    Krugle to Exhibit at SYS-CON's Virtualization and Cloud Computing ... SYS-CON Media
    EMC Named "Gold Sponsor" of SYS-CON's SOA World and Virtualization ... SYS-CON Media
    SYS-CON Media
    all 66 news articles


    Ruling ends uncertainty for software developers
    Contractor UK, UK - 4 hours ago
    Ominously for small software developers, the UK IPO said it would continue to follow the practice, contrary to a High Court ruling in March that it should ...
    Limits on bank compensation Financial Times
    Here’s an idea — US patent system needs reform Bizjournals.com
    all 13 news articles


    21st Century Software, Inc. Announces DR/VFI v4.3 for IBM Mainframes
    PR Web (press release), WA - 3 hours ago
    Las Vegas, NV and Wayne, PA (PRWEB) October 12, 2008 -- Today, at the 2008 IBM System z Expo Conference, 21st Century Software, Inc., announced a major ...


    Economic climate weighs on oracle, but it makes gains
    Newsday, NY - 19 hours ago
    Nonetheless, its dominant position in database software gives it a degree of pricing power most other technology companies can only dream about. ...


    Software gives top students another boost
    The Nation Newspaper, Barbados - 18 hours ago
    Through this partnership, Aries Technologies has provided the school edition of the software to primary schools across the island at no cost to the Ministry ...


    INTERNET LAW - Free Software Under French Law
    IBLS INTERNET LAW (subscription), CA - 33 minutes ago
    As opposed to proprietary software, which use, redistribution or modification is prohibited, or requires the authorization of the author, free software is ...


    Software firms defy the gloom
    Times Online, UK - Oct 11, 2008
    SCOTLAND’S software sector is defying economic gloom to attract millions of pounds in new business, according to a new survey. ...


    Wall Street Journal

    Orange suspends Blackberry Bold handsets over software glitches
    Telegraph.co.uk, United Kingdom - Oct 10, 2008
    By Matthew Moore Phone provider Orange has stopped dispatching Blackberry Bold handsets due to software problems with the devices, in a move that threatens ...
    Software problems hit BlackBerry Bold IT PRO
    Third-party BlackBerry Software Development a Learning Process for RIM Brighthand
    Orange UK Suspends Sales of BlackBerry Bold Due to Software Bugs Cellular-News
    CRN - U.S. News & World Report
    all 1,068 news articles

    Software - Google News

    home | site map
    © 2006