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:

    Software allows social sites to share info
    Bizjournals.com, NC - 14 hours ago
    JACKSONVILLE — A Jacksonville software company is knocking down walls between social networks, such as MySpace and LinkedIn, by giving users more control ...


    SYS-CON Media

    Composite Software to Exhibit at SYS-CON's Virtualization and ...
    SYS-CON Media, NJ - 6 hours ago
    SYS-CON Events announced today that the eading global virtualization technology provider Composite Software to exhibit at SYS-CON's 4th International ...
    Active Endpoints Named "Gold Sponsor" of SYS-CON's SOA World ... SYS-CON Brasil (Assinatura)
    EMC Named "Gold Sponsor" of SYS-CON's SOA World and Virtualization ... SYS-CON Media
    Intel Named "Gold Sponsor" of SYS-CON's SOA World and ... SYS-CON Media
    all 35 news articles


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


    Review: Tiny flash drives improve their security
    San Jose Mercury News,  USA - 22 hours ago
    I put a few secure flash drive solutions to the test: Take Anywhere's Pocket Safe ($59.95), the IronKey ($149) and TrueCrypt, a free software program that ...


    Times Online

    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


    Sys-Con Italia (Comunicati Stampa)

    AppSense Named "Gold Sponsor" of SYS-CON's Virtualization & Cloud ...
    Sys-Con Italia (Comunicati Stampa) - 9 hours ago
    ... Black Duck Software, Blackbaud, Blade Network Technologies, Blue Coat, Blue Lane, BlueArc, BlueNote Networks, BluePheonix Solutions, BMC Software, ...


    BBC News

    US judge halts sales of RealNetworks DVD software
    Reuters - Oct 9, 2008
    RealDVD, a software product from RealNetworks subsidiary RealNetworks Home Entertainment Inc, allows users to create a copy of a DVD for their computer's ...
    Judge Temporarily Halts Sales of RealNetworks Copying Software Wall Street Journal
    For PC: RealDVD works so well that it's on legal hold Dallas Morning News
    Drop that DVD copying software and put your hands in the air InfoWorld
    Wired News - International Herald Tribune
    all 335 news articles


    40 laid off at software company as execs arrested
    nwitimes.com, IN - 15 hours ago
    SEATTLE - Two former software executives grossly overstated their company's revenue to attract more than $50 million in private investment, prosecutors said ...
    Prosecutor: Exec used company as 'piggy bank' Seattle Times
    Judge orders Entellium CEO kept in custody Seattle Post Intelligencer
    Feds can’t find $9.6M from Entellium Bizjournals.com
    all 20 news articles


    Dorado Software Announces Redcell Storage Commander for Automated ...
    MarketWatch - Oct 10, 2008
    Redcell Storage Commander, Redcell OpsCenter, and Redcell Network Commander are generally available and trial software is available on the Dorado Software's ...


    The ONLY Property and Facilities Management Software Exhibition in ...
    1888 Press Release (press release), TX - 2 hours ago
    The three leading software solutions who are at the forefront of technology exhibiting under one roof at the only property and facilities management ...

    Software - Google News

    home | site map
    © 2006