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 [email protected] 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! [email protected]

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 (www.albaspectrum.com), he is Microsoft CRM SDK, Great Plains Dexterity, SQL, C#/VB.Net and Crystal Reports developer; [email protected]

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

CNBC

Microsoft allies with Facebook on AI software
CNBC
Microsoft has developed open-source software for crafting artificial intelligence models. But in recent months, the company has changed course, opting to work more closely with Facebook and contribute to the development of Facebook's own flavor of free ...

and more »

TechCrunch

Citrix pays $200M to acquire Sapho, which connects legacy software with 'micro apps'
TechCrunch
As large organizations grapple with adopting modern work practices without throwing out all of their legacy software, a company that works with them is making an acquisition that it hopes will help with that process. Citrix today is announcing that it ...

and more »

Forbes

Move Slow and Make Things: Airtable's Howie Liu Built A $1B Software Giant Emphasizing Substance Over Speed
Forbes
The trio pored over academic papers on collaborative software theory, agonized about the Node.js architecture and obsessed over the speed at which windows popped open. After reading Kenya Hara's design book White, Liu spent months focusing on the ...

and more »

Texas Standard

Trying To Make Good After A Bad Software Update
Texas Standard
With software companies shipping feature-fixes and security patches almost weekly, it might not be clear to everyone why this matters. But our tech expert, Omar Gallaga, says this week's update actually fixes a big problem for Microsoft, and comes more ...

and more »

Seeking Alpha

Marin Software: A First Whiff Of Spring?
Seeking Alpha
Cash burn has declined considerably in the quarter and is guided to decline some more, giving the company some more time to turn things around. That doesn't take away that the company is in big trouble, enough for us not to recommend the shares.

and more »

TechCrunch

Apex.AI raises $15.5 million for autonomous-vehicle software
TechCrunch
AI's software stack is designed to easily integrate into existing systems and serve as the enterprise version of the Robot Operating System, an open-source software middleware for robotics. “Most companies have expertise building consumer applications ...


Adweek

Software Companies Dominated Deloitte's 2018 North America Technology Fast 500
Adweek
The Deloitte North America Technology Fast 500 list debuted in 1995 and, for the 23rd straight year, software dominated the list, with the 2018 crown going to SwanLeap, an end-to-end transportation technology provider for logistics managers and supply ...
OneStream Software Ranked 212th Fastest Growing Company in North America on Deloitte's 2018 Technology Fast ...Associated Press (press release) (blog)
About Deloitte | Our global network of member firmsDeloitte
Technology Fast 500™: North America - DeloitteDeloitte

all 498 news articles »

Computerworld

Hey, LG: How's that 'Software Upgrade Center' going?
Computerworld
Back in April, LG came out with an almost laughably bold declaration: The company infamous for treating Android software updates as an afterthought was breaking new ground by opening a "Software Upgrade Center" — and not just any "Software Upgrade ...
Android Developers Blog: An Update on Project TrebleAndroid Developers Blog

all 21 news articles »

Digital Trends

The best data recovery software
Digital Trends
Before downloading and running any recovery software, you should stop using the drive if possible. The only operation you should use it for — especially if it's potentially going to fail soon — is to make a backup of the entire drive to a secondary ...


Forbes

How A Global Software Corporation Creates And Manages A Marketing Budget
Forbes
SAP is a global enterprise software firm with €23.46 billion in annual revenues and 404,000+ customers in more than 180 countries. I recently asked Siddharth Taparia, SVP and head of marketing transformation at SAP, to share his insights on how he ...

Google News

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Know-how in Microsoft Publisher

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

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Great Plains Dexterity: Customizations & Source Code Programming

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

Think Of This

Think of this, first we had the HAM Radio, then... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More