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
tidy up service Northbrook ..Most people understand that the "hardware" part of their computer... Read More
Intro This concise article will tell you in plain English... Read More
Viruses and spyware usually show up on your computer one... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
In linux, one of great commands for finding out information... Read More
Looks like Microsoft Great Plains becomes more... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
Before being able to choose a secure Internet communication system,... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Let's first look at your ERP system selection (without Retail... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
The vast majority of us will have, at some point,... Read More
Introduction: The creating of a computer program involves a number... Read More
Microsoft CRM is new player on the CRM software... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
The Windows registry is a huge database that ensures normal... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Are you a database professional? Do you work with a... Read More
The adware and spyware definitions list is very long. But... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
reliable home cleaners Buffalo Grove ..Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
Crystal Reports is the most flexible tool on the market... Read More
While I was in college, if you would have asked... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Bill of Lading is required report for Logistics and Freight... Read More
The research in the field of Natural Language Processing usually... Read More
When you need a phone number, you do a quick... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
With any good luck and a good amount of hard... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
How many steps does it take you to locate and... Read More
What is Software?Software is a set of instruction written to... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
At the end of XX century, in the late 1990th... Read More
Software |