Microsoft CRM is CRM application, maintained and supported by Microsoft Business Solutions. Microsoft CRM utilizes majority of the Microsoft technologies: Windows Active Directory, SQL Server, MS Exchange, BizTalk (integration with MS Great Plains, and soon with Navision), Message Queuing, .Net web services to name a few. There is market demand on the efficient integration of MS Office documents into Microsoft CRM. Let's take a look at the options:
? Attachment to MS CRM Notes. You may attach Office docs as file attachment to MS CRM Note. It is bullet-proof method, however you should be aware that it is not that simple for the user to attach files, especially web interface, which may work slow. The second drawback ? you are actually copying document into MS SQL Server database and you may quickly increase its size and degrade efficiency.
? Lotus Notes/Domino remarks. Also we need to give mind set change advise to Lotus Notes/Domino switchers to MS CRM. Lotus is designed to incorporate files and documents (such as MS Word, Excel, Power Point, etc.) into its database ? why it is efficient in Lotus ? answer is simple ? Lotus is not a relational database. At the same time MS SQL Server ? MS CRM DB platform is perfectly relational.
So ? go ahead and make attachments, but do not try to make your CRM database be the repository of your documents. It is also possible to use Lotus as your documents repository and programmatically realize the links from MS CRM objects to documents, stored in Lotus Notes/Domino. Also it is possible to have Lotus/Domino playing the role of email server (instead of MS Exchange) ? but this is outside of the scope.
? MS SharePoint. This is probably the best MS Office documents repository which could be seamlessly integrated with MS CRM, in this case MS CRM links to the repository, not imports the whole documents into MS SQL database. Sharepoint integration is subject for dedicated article and might be realized with elements of MS CRM programming (MS CRM SDK)
? Windows Files Links. This solutions doesn't require SharePoint license but it will require some MS CRM programming
? Microsoft Office Information Bridge Framework for Microsoft CRM ? this tool is sometimes misunderstood. It is the other way integration ? from MS Office documents you can link to MS CRM objects (including proposals). This solution however works in the realm of MS CRM security model and requires the user, who opens MS Office document have MS CRM user id (and so ? the user license)
You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com
Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( help@albaspectrum.com ) ? Microsoft Business Solutions partner, serving clients in Illinois, New York, California, Florida, Georgia, Texas, Arizona, Virginia, Minnesota, Canada, UK, Europe, Australia, Asia, Russia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer. You can reach Andrew: help@albaspectrum.com
Wheaton limo Chicago a> .. Lockport Chicago limo O’HareUpgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
If you have been using the Internet for any amount... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Just imagine: you are walking, say, towards your car, and... Read More
NOTE: Please take time to read on - it may... Read More
The fact that a software tester is a most infamous... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
When you first think about multicurrency ? you probably have... Read More
Adware is a type of Spyware program that displays some... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
The title of "software engineer" has got to be among... Read More
The cornerstone of successful automated office systems is the ability... Read More
Mike Dunville* had a decision to make. As the new... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
First we had the original Google search that evolved into... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Pirated software is on the increase and now accounts for... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Chicago limo Lisle ..As you probably know, when Microsoft purchased Great Plains Software... Read More
Finally, you have some time to personalize your desktop with... Read More
We would like first emphasize the change in the paradigm.... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
A wiki is an editable text-based website. But you don't... Read More
Are you a whiz at calculating financial information? Not the... Read More
We were recently faced with a decision: either to let... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
I've been active in the Cisco Certification track for four... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
During the years of our consulting practice, which comes back... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
One day, you suddenly realize that your computer started to... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
User interfaces and accessibility are some of the most important... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
Are you one of those people that keeps track of... Read More
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
It would be easy to think, like most people apparently... Read More
Software |