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
eco-friendly cleaning service Buffalo Grove ..We were recently faced with a decision: either to let... Read More
Considering whether or not your software company should hire a... Read More
It would be easy to think, like most people apparently... Read More
There are certain pluses and minuses in both cases and... Read More
The purpose of Project Management Software is to provide an... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
This is the tutorial where we really get into programming.... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
While Adobe is the most known maker of PDF tools,... Read More
Research bears that less than 70 percent of development projects... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
So, you've bought a new Macintosh, and now you may... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Once a business idea is selected, it is highly recommended... Read More
Our hosted solution allow you to run your own search... Read More
As seeing large number of implementations ? in our case... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
While I was in college, if you would have asked... Read More
What is Software?Software is a set of instruction written to... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Intro This concise article will tell you in plain English... Read More
express cleaning service Arlington Heights ..Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
So, you've bought a new Macintosh, and now you may... Read More
CD and DVD replication is a process that works by... Read More
First we had the original Google search that evolved into... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
In the previous ISDN article, we looked at how and... Read More
In this small article we will be looking at the... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
Spyware and malware are large problems for Internet users today... Read More
XML parser is a software module to read documents and... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
When you buy a computer, it most likely comes with... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
Software |