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
best cleaning company Lincolnshire ..Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Three highly respected names in Human Resources have joined forces... Read More
Remember old good days when your company probably had Great... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
Find out why Spyware Removal from computers is important and... Read More
In the real world a "fire wall" is a fireproof... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Did you ever want to erase everything on your computer?... Read More
Remember back in the days where screensavers were the coolest... Read More
Well, even if the combination might look very unusual, we... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Mike Dunville* had a decision to make. As the new... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
This short paper will expand on two key reasons to... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
on demand house cleaning Lake Forest ..Whether you have used Microsoft Word for years, have just... Read More
The most important benefit of XML is its simplicity. Though... Read More
... Read More
Intro This concise article will tell you in plain English... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
The Internet is reshaping every form of communications medium, and... Read More
With any good luck and a good amount of hard... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
It is now common thing when large corporation selects mid-market... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
As seeing large number of implementations ? in our case... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
How would you like to prevent spyware and adware from... Read More
How do you run a program on a remote server... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
During the years of our consulting practice, which comes back... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
For those who are unclear on the differences between the... Read More
The term "document management" and "paperless office" is the subject... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
Software |