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
express cleaning service Arlington Heights ..The Windows registry is a huge database that ensures normal... Read More
Microsoft CRM is now on the scene and it is... Read More
If you are software developer or database administrator - we... Read More
Not all of us have the luxury of working both... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Software development is a risky business.Many software developers are barely... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
1. What determines the software price? Is it Per Seat... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
Once a business idea is selected, it is highly recommended... Read More
It's all about turn times in the eMedia industry! The... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
You've finally created databases that you can actually use to... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
C++ Function templates are those functions which can handle different... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
tidy up service Arlington Heights ..Handling character strings in Java is supported through two final... Read More
Whether you are a small consultancy firm, a medium sized... Read More
There are plenty of articles out there about how to... Read More
How would you like to prevent spyware and adware from... Read More
The adware and spyware definitions list is very long. But... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
One day, you suddenly realize that your computer started to... Read More
The first thing that you will notice about Linux Red... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Research bears that less than 70 percent of development projects... Read More
Microsoft Business Solutions main middle market ERP application - Microsoft... Read More
1. What determines the software price? Is it Per Seat... Read More
Today's business world is fast-paced. No matter what it is... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Linux essentials:It's free for download but you have to pay... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
When reading an article where some term is used often,... Read More
Many Webmasters have never bothered to view their website's server... Read More
One of the main reasons business owners and entrepreneurs use... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Software |