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
cleaning service near Bannockburn ..Microsoft PowerPoint has dramatically changed the way in which academic... Read More
An integral part of any quality CRM system is lead... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
This is a short article, written in question/answer/FAQ style to... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
There are plenty of articles out there about how to... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Remember back in the days where screensavers were the coolest... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
The title of "software engineer" has got to be among... Read More
This article is the third of a series of articles... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
pet-friendly home cleaners Mundelein ..Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
We all take the computer for granted. I mean, all... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Sometimes your PC will start acting strange for no apparent... Read More
Looks like Microsoft Great Plains becomes more... Read More
For a windows user like me, just can watch with... Read More
I have always had a tendency to focus on the... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
This article is the third of a series of articles... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
The world of small business accounting software can be a... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Software |