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 (help@albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    express cleaning service Arlington Heights ..
    In The News:

    The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
    ChatGPT data breach exposes personal info of users through partner Mixpanel. OpenAI confirms names, emails compromised in security incident.
    Android rolls out Emergency Live Video for 911 calls, letting dispatchers see real-time scenes during emergencies. Great for holiday travel safety.
    Malicious Chrome and Edge extensions collected browsing history, keystrokes and personal data from millions of users before Google and Microsoft removed them.
    Google's new Call Reason feature lets Android users mark calls as urgent before dialing, displaying an urgent label to recipients using Phone by Google app.
    Medical history made as surgeons successfully restore sight to legally blind patient using world's first 3D printed corneal implant grown from human cells.
    Data brokers aggressively collect your holiday shopping data to fuel scams and targeted ads. Learn how to delete your digital profile before 2025 starts.
    Scammers are sending fake MetaMask wallet verification emails using official branding to steal crypto information through phishing links and fraudulent domains.
    Learn what background permissions, push notifications, security updates, auto-join networks and app refresh mean to better manage your phone's privacy settings.
    Criminals test stolen data by applying for deposit accounts in victims' names to prepare bigger attacks. Learn why banks won't share fraud details.
    New study of 10,500+ kids reveals early smartphone ownership linked to depression, obesity, and poor sleep by age 12. Earlier phones mean higher risks.
    A phone phishing attack compromised Harvard's alumni and donor database, marking the second security incident at the university in recent months.
    AutoFlight's zero-carbon floating vertiport uses solar power to charge eVTOL aircraft while supporting emergency response, tourism, and marine energy maintenance.
    A new phone return scam targets recent buyers with fake carrier calls. Learn how criminals steal devices and steps to protect yourself from this fraud.
    New Anthropic research reveals how AI reward hacking leads to dangerous behaviors, including models giving harmful advice like drinking bleach to users seeking help.
    The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
    Holiday email scams, including non-delivery fraud and gift card schemes, spike in November and December, costing victims hundreds of millions, the FBI says.
    Holiday visits offer the perfect opportunity to help older parents with technology updates, scam protection and basic troubleshooting skills for safer digital experiences.
    Swiss scientists create grain-sized robot that surgeons control with magnets to deliver medicine precisely through blood vessels in medical breakthrough.
    Researchers exploited WhatsApp's API vulnerability to scrape 3.5 billion phone numbers. Learn how this massive data breach happened and protect yourself.
    Travel companies share passenger data with third parties during holidays, but travelers can protect themselves by removing data from broker sites and using aliases.
    Xpeng's humanoid robot moves so realistically that crowds believed it was fake, marking a major advancement in robotics technology ahead of 2026 commercial launch.
    Researchers discover phishing scam using invisible characters to evade email security, with protection tips including password managers and two-factor authentication.
    iPhone and Android users can reduce battery drain and data usage by restricting Background App Refresh to Wi-Fi connections instead of mobile networks.
    Scammers nearly stole an Apple account by exploiting the support system with authentic-looking tickets and phone calls, users can protect themselves with safety steps.

    It?s Back!! WordPerfect?s Amazing Comeback

    Have you noticed WordPerfect is gearing up for a comeback... Read More

    A Case Study on Selecting Contract Management Software

    Professional services firm cuts costs and improves productivity with integrated... Read More

    Mapping Software: Putting Data Visualization on the Map

    Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

    Accessing XML Using Java Technologies

    The most important benefit of XML is its simplicity. Though... Read More

    Know-how in Microsoft Publisher

    For those who still don't know, Microsoft Publisher helps computer... Read More

    ERP System of the Future: Database, Business Logic and Interface

    We will base our prognosis on our Microsoft Business Solutions... Read More

    Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

    Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

    Where to Find Free Fleet Maintenance Software

    Costs of fleet maintenance software can vary widely. It is... Read More

    eConnect: eCommerce Development for Microsoft Great Plains

    Microsoft Business Solutions Great Plains has several options to enable... Read More

    Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

    Great Plains Fixed Assets Management module is a robust tool... Read More

    Best Spyware Removers

    Finding the best spyware removers to detect and remove spyware... Read More

    How To Develop Software For Your Business

    Software development is a risky business.Many software developers are barely... Read More

    DB Integration - Software for Combine MS Access Databases

    Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

    Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

    Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

    Microsoft CRM: Data Conversion ? Import from Act!

    Best Software Act! is very popular CRM for small and... Read More

    Great Plains Dexterity: Customizations & Source Code Programming

    Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

    Microsoft Great Plains Customization: Project Organization ? International Business Example

    Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

    Looking for an Alternative to Microsoft Office? You Should Be!

    Now is the time to look at an alternative to... Read More

    Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

    Microsoft bought Navision, Denmark based software development company, along with... Read More

    Collaboration Software: Index of Collaboration Software Technologies

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

    Is Your Computer Sick?

    Viruses and spyware usually show up on your computer one... Read More

    Software Piracy - Global Increase

    Pirated software is on the increase and now accounts for... Read More

    Groupware Finds Home in American Business: Collaboration Tool Analysis

    What is Groupware?Have you ever had to manage document collaboration... Read More

    Microsoft Great Plains eCommerce ? Stored Procedures Approach

    Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

    HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

    The first topic we are going to discuss... Read More

    tidy up service Arlington Heights ..