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
move in cleaning service Mundelein ..Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
We all already got used to computer monitoring both at... Read More
Fundraising software lets you connect with donors in a way... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Some companies that are in need of fleet management may... Read More
Shareware is software that you can try before you buy;... Read More
I provide, here clear explanations and a count of function... Read More
Crystal Reports is the most flexible tool on the market... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
How would you like to prevent spyware and adware from... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Google Inc. has launched a new software package that allows... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Let's first look at your ERP system selection (without Retail... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
The various resume software offered, particularly on the internet, can... Read More
This article is the third of a series of articles... Read More
insured cleaning company Highland Park ..Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
The title of "software engineer" has got to be among... Read More
Java has come along a long way. Many would agree... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Background: For many organizations like ours, the interim target of... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
It's no secret that software companies operate in a very... Read More
And kill the best layout software in the process of... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Beginning with Domino version R4 it has integration with the... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
The major reason I recommend getting your hands on real... Read More
Looking at all the ads which promise to get rid... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
The adware and spyware definitions list is very long. But... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Fleet Maintenance Management is a critical position in any company... Read More
Once a business idea is selected, it is highly recommended... Read More
Software |