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
no-contract cleaning service Glenview ..Do you remember that frustrating feeling when you find an... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
In the early days of the personal computer, we're talking... Read More
I provide, here clear explanations and a count of function... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
In this small article we will show you the possible... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Once upon a time not so long ago, there was... Read More
What is a Web Database?A web database is a database... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
Words we choose to describe things and phenomena often show... Read More
Sales are all about leverage, because there is only so... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Think of this, first we had the HAM Radio, then... Read More
The various resume software offered, particularly on the internet, can... Read More
This article is the fourth of a series of articles... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
Each Industry and market niche has business specific and unique... Read More
house cleaning company Glencoe ..As Mozilla Firefox nears 10% market share, with well over... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Intro This concise article will tell you in plain English... Read More
Shareware is software that you can try before you buy;... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
At the end of XX century, in the late 1990th... Read More
Background: For many organizations like ours, the interim target of... Read More
There are plenty of articles out there about how to... Read More
ERP Consulting industry is on the way to serve clients... Read More
An integral part of any quality CRM system is lead... Read More
Most people understand that the "hardware" part of their computer... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
So, you've bought a new Macintosh, and now you may... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
The most important things you can do for your computer... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Almost all new and major brand of PCs come with... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
Microsoft CRM is now on the scene and it is... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
Software |