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
move out cleaning service Glencoe ..."Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
1. What determines the software price? Is it Per Seat... Read More
CD and DVD replication is a process that works by... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Research bears that less than 70 percent of development projects... Read More
New post-recession era has new features, which didn't exist in... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
In the previous ISDN article, we looked at how and... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Shareware is software that you can try before you buy;... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Handling character strings in Java is supported through two final... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
on demand house cleaning Mundelein ...This tutorial covers OLAP solutions used by Data warehouses and... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
The various resume software offered, particularly on the internet, can... Read More
It is really interesting that a bug can create problem... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
When you buy a computer, it most likely comes with... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
Fundraising software lets you connect with donors in a way... Read More
Handling character strings in Java is supported through two final... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
The Windows registry is a huge database that ensures normal... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
I completed an experiment recently. I wanted to find out... Read More
What is Software?Software is a set of instruction written to... Read More
Domino server is a buffer between the operation system and... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
The US House of Representatives has recently passed the "Spy... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
There are several kinds of software piracy. The bottom line... Read More
Software |