Home
>
Software
>
Microsoft CRM ? Typical Customizations

Microsoft CRM ? Typical Customizations

Microsoft CRM was designed to be easily customizable. Microsoft CRM Software Development Kit (MS CRM SDK) which you can download from Microsoft website contains descriptions of the objects or classes, exposed for customization. It has sample code in C# and partially in VB.Net. In Visual Studio.Net you can analyze all the classes, used by Microsoft developers to create MS CRM - you will discover that most of them are not documented in MS CRM SDK. Microsoft will not support your customization if you use undocumented class or do direct SQL access to CRM database.

Let us describe you - programmer, software developer typical cases of MS CRM Customizations.

1. Integration with SQL Server application. If you have legacy system on MS SQL Server - let's say you are transportation company and have in-house developed cargo tracking database. Now in MS CRM you want lookup the shipments for the customer (or account in CRM). This is SDK programming and calling SQL stored proc to retrieve cargo info. Instead of SQL Server you can have other database (ORACLE, MS Access, PervasiveSQL to name a few) - you can access multiple Database platforms via ADO.Net connection from your .Net application, which is easily integrated into MS CRM Account screen.

2. Email capturing in MS CRM. You have customer with email Bill@customer.com. Now you want all the emails that you receive from customer.com domain to be attached to Bill who is account in CRM. This is more difficult customization - you have to create MS CRM SDK web service, that one will be creating email activity and call it from COM+ application - Microsoft Exchange event handler (ONSYNCSAVE database event sink). This example maybe complicated with the following requirement. Imagine that Bill, instead of answering to your email (sent from CRM and processed by CRM-Exchange connector) sends you new message from MS Outlook. Then this email will not follow into MS CRM (because it doesn't have GUID in the header and so is ignored by CRM Exchange connector). If you want to capture these emails - you have to do it in Microsoft Exchange event sink. There maybe scenario when you want to capture and analyze in the sink all the outgoing emails - this is even more complex - y!

ou have to place the sink on transport event.

3. ASP Application integration. You have legacy ASP application, where you capture orders from your customers and you want these orders be transferred to the CRM as activity. Here you understand that ASP doesn't deploy Active Directory security - and the best way is to create HTTP handler and call it from your ASP page. This HTTP handler in turn will call MS CRM SDK web service with predefined (web.config) Active Directory credentials.

Some cautions. Never create your custom SQL objects (like stored procedure, SQL view, table) in MS CRM database. Instead, create your own database and place your objects there. When you see the first caution - you will never try to alter existing CRM objects, like adding new field to the table.

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

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in multiple states and internationally (help@albaspectrum.com), he is Microsoft CRM SDK, Great Plains Dexterity, SQL, C#/VB.Net and Crystal Reports developer; help@albaspectrum.com

last minute cleaning help Northbrook ...

In The News:

ShinyHunters claims it breached FBIJobs.gov and stole Social Security numbers, home addresses and sensitive assignment details of FBI personnel.

Find My iPhone, Google Find Hub and Samsung Find have critical tracking settings to enable now, before your phone ever goes missing or stolen.

The FTC proposed a new enforcement policy on personalized pricing, warning companies that hide how personal data shapes the prices shoppers see.

The $250 million Apple Siri AI settlement is now accepting claims, with eligible iPhone owners potentially receiving up to $95 per device.

ShareAScan turns T-shirts into scannable digital business cards with QR codes that link to profiles the owner can update anytime they choose.

BragJack research reveals how a single malicious browser extension could hijack Gemini, Perplexity Comet and Edge AI agents with zero clicks.

A phishing campaign impersonating OpenAI uses fake ChatGPT billing emails with a convincing login page to steal credentials and payment details.

Startups are helping modernize America’s defense industry with new technology and innovative ideas as the War Department diversifies its inventory.

New account fraud victims jumped 31% in 2025, reaching 5.4 million. Criminals open accounts you may never see on your regular bank statements.

Flytrex says its AI-powered Rooftop Dock system in Dallas-Fort Worth positions drones at restaurants before orders arrive, cutting delivery costs by 60%.

Samson Sky's Switchblade flying car secures $80 million from Dubai's Matin Group, but the redesigned hybrid-electric aircraft still needs more testing.

The Fox News AI Newsletter covers the latest artificial intelligence technology advancements, including the challenges and opportunities AI presents now and for the future.

CenterPoint Energy confirmed customer data was stolen, while a hacker claims 7.49 million records with partial Social Security numbers were taken.

The $59 Brick device promises to help curb phone addiction, but free iPhone and Android tools may already do the job. Here's what to try first.

Epsilon Data Management's "opportunity seeker" lists helped scammers target millions of older Americans, DOJ court filings reveal in detail.

HBO Max's verified Reddit account was hijacked to push 108 malicious ads using ClickFix, a technique that tricks victims into running dangerous commands.

Flash Shelton reveals how home security cameras and alarm systems can stop squatters before they claim tenant rights in your vacant property.

WIM-Z's AI dog training robot uses on-device processing to detect barking and dispense treats autonomously, with field trials showing up to 83% reduction.

Google's Threat Intelligence Group found PROMPTFLUX malware that uses Gemini to rewrite its own code every hour, raising urgent cybersecurity alarms.

Your VPN may quietly drop protection when switching between airport Wi-Fi and hotel Wi-Fi. Key settings like auto-connect and kill switch help.

A South Carolina caregiver allegedly gained power of attorney over a 75-year-old with Parkinson's, then transferred his home via quitclaim deed for $5.

Joby Aviation flew its eVTOL air taxi into DFW Airport's busy airspace as Texas launches Project Nexus, a three-year advanced air mobility program.

Federal prosecutors say criminals bought sponsored search ads mimicking real banks, capturing over 5,000 login credentials and draining accounts.

The Mercedes-Benz eActros 600 electric truck targets 621 miles per charge on a 28,000-mile round-the-world journey through over 30 countries.

A viral video shows roughly a dozen Coco Robotics delivery robots swarming a Chicago sidewalk near Lincoln Park, raising wheelchair access concerns.