Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision.
If you are programmer or database administrator who is asked: how do we modify Microsoft CRM ? read this article and you will have the clues for further research.
1. 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.
2. 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
3. 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.
4. 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.
5. 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.
6. 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
7. 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!
About The Author
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, Los Angeles, Houston, Atlanta, and Miami 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.
If you want us to do the job - give us a call 1-866-528-0577! www.albaspectrum.com
shuttle from O'Hare Bingham .. Lockport Chicago limo O’HareWhat is Snort?Snort is an open source network intrusion detection... Read More
Program Flow is what you think it is. How the... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
After seeing many people complain about their weak Internet security... Read More
Just the thought of a duel-boot scares many people away,... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
The first thing that you will notice about Linux Red... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
We would like first emphasize the change in the paradigm.... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
While Adobe is the most known maker of PDF tools,... Read More
An integral part of any quality CRM system is lead... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
I have always had a tendency to focus on the... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
There are many commands that are used in linux on... Read More
I like my software simple. If it's too complex or... Read More
There are two major WYSIWYG(What You See Is What You... Read More
A UNIX Shell is in simplest terms, a command line... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
CD and DVD replication is a process that works by... Read More
Mishawaka limo O'Hare ..Microsoft Great Plains could be tuned and setup to fit... Read More
Google Inc. has launched a new software package that allows... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Finally, you have some time to personalize your desktop with... Read More
I completed an experiment recently. I wanted to find out... Read More
Did you ever want to erase everything on your computer?... Read More
Microsoft Word is one of the most popular office applications... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
You turn on your computer, and it doesn't look quite... Read More
I provide, here clear explanations and a count of function... Read More
In this small article we will show you the possible... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
There are several kinds of software piracy. The bottom line... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Our hosted solution allow you to run your own search... Read More
This article is the first of a series of articles... Read More
Here is some free software tools to help you build... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
How many steps does it take you to locate and... Read More
At the end of XX century, in the late 1990th... Read More
Software |