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

Bishop Hill taxi from Midway ..

In The News:

After a recent cyberattack affected patient record systems at Ascension, one of the largest U.S. health systems, here are a few ways you can safeguard your health records.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Kurt "CyberGuy" Knutsson explains how to hide the apps loaded onto your Android device so others can't access them and violate your privacy.

Kurt "CyberGuy" Knutsson has a warning about a new type of malware that's targeting Apple computers for files that may contain private information.

NASA'S Dragonfly rotorcraft is scheduled for a 2028 journey to Saturn's largest moon, Titan, which is located 746 million miles from Earth.

Apple launched its first artificial intelligence product, the M4 Apple silicon chip in a new iPad Pro. Steve Jobs predicted the iPad would replace laptops.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Artificial intelligence has made social engineering scams more sophisticated. They are scams by which criminals exploit trust for money or information.

Quadroin AUV is an underwater research robot that mimics penguins' graceful and swift swimming, descending to depths of 492 feet at speeds up to 11.5 mph.

Will fake movie trailers made with AI become real enough to take over Hollywood? Kurt “CyberGuy" Knutsson discusses more about spotting AI movie trailers and how they work.

Kurt “CyberGuy" Knutsson discusses how Triton Submarines redefines the underwater experience with the Triton 660/9 AVA, which offers panoramic views and unparalleled ocean access.

If your Facebook account has been hacked and you're having trouble logging back in, Kurt “CyberGuy" Knutsson shows you some steps to recover your account.

Kurt “CyberGuy" Knutsson reveals how the Aloha Unleashed project showcases a dual-arm robot system that autonomously performs tasks, demonstrating remarkable precision in robotics.

Air Force Secretary Frank Kendall boarded the cockpit of an F-16 controlled by artificial intelligence on Friday, before the plane entered a dogfight with a human-controlled plane.

Using a virtual private network to seach the internet has its pros and cons. It can provide more security and privacy. But users can be blocked from websites.

Dragon 12 is an underwater kite manufactured by Swedish company Minesto that promises to generate clean electricity deep under the sea.

The Federal Communications Commission slapped the nation's four biggest mobile carriers with fines totaling $200 million for unauthorized sharing of customer location information.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

The fully electric Atlas 2.0 robot was designed for real-world applications, and it is capable of lifting and maneuvering heavy, irregular objects.

Rather than spending time searching for the right buttons, here are a variety of keyboard shortcuts to make your workflow easier, faster and with less clutter.

High tech video cameras seem to find their way into the hands of Peeping Toms in hotels, dressing rooms and rental properties. Here's how to keep yourself safe.

If you consider Facebook's "People You May Know" section distracting, there's a way to temporarily remove it. There is no permanent way to eliminated it.

ChatGPT is an industry game-changer — here are a few simple prompts that can easily come in handy as personal and professional life hacks.

IPhones have several voice assist options available — like Siri and VoiceOver — that can help users search the web and read articles by voice.

The X1 exoskeleton is a motorized artificial intelligence-powered all-terrain device that straps to your waist and thighs for hiking climbing and running.