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
Culver prom limo ..You might think you don't need a firewall... Read More
It's all about turn times in the eMedia industry! The... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
In the early days of the personal computer, we're talking... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Enabling Chinese input is quick and easy, there are only... Read More
In linux, one of great commands for finding out information... Read More
Need software to record your voice, streaming audio or musical... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
In today's business world it's all but impossible to escape... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
There are two major WYSIWYG(What You See Is What You... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
We live in a post-industrial age where information is the... Read More
When you need a phone number, you do a quick... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
Wood Dale limo ..Microsoft has never released a service pack for Windows98 SE,... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Considering whether or not your software company should hire a... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
As seeing large number of implementations ? in our case... Read More
Icons are used everywhere; right from software applications, to internet... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Microsoft Great Plains fits to majority of industries, in the... Read More
The research in the field of Natural Language Processing usually... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
In the real world a "fire wall" is a fireproof... Read More
DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
When you visit department stores and see that majority of... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Words we choose to describe things and phenomena often show... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
Is your PC is slow and wimpy? Then you need... Read More
Software |