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
Beecher limo rentals ..If someone entered your home, uninvited and installed numerous cameras... Read More
When Windows fails to boot it is normally caused by... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
We would like to give you pluses and minuses of... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Program Flow is what you think it is. How the... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
Microsoft CRM is now on the scene and it is... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
The term "document management" and "paperless office" is the subject... Read More
In this small article we will be looking at the... Read More
Introduction: The creating of a computer program involves a number... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
In order to implement VLANs in a network environment, you'll... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
How do you run a program on a remote server... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
Bridgeview limo Chicago ..Anyone who has ever used Microsoft Word knows that it... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
If you look back to the history, you will see... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
So let's begin crunching down these 300 images using Adobe... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
Best Software Act! is very popular CRM for small and... Read More
So, you've bought a new Macintosh, and now you may... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
It's all about turn times in the eMedia industry! The... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
Bill of Lading is required report for Logistics and Freight... Read More
When you need a phone number, you do a quick... Read More
With thousands of web pages added to the Net every... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
As seeing large number of implementations ? in our case... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Software |