vinyl siding installation elmhurst vinyl siding installation siding installation installing vinyl siding siding options .. Chicago Drug testing

Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator

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 ( http://www.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: akarasev@albaspectrum.com

In The News:

When is a Software Engineer Not a Software Engineer?

The title of "software engineer" has got to be among... Read More

Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

Microsoft Great Plains Partner Selection: Overview

Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail... Read More

Software For Your Hard-Drive

All your software is stored on a hard-drive. But how... Read More

6 Easy Steps for a Smoother CD/DVD Order

It's all about turn times in the eMedia industry! The... Read More

What is Spyware? Are You Being Watched?

Find out why Spyware Removal from computers is important and... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

ERP for Large Corporation ? New Selling Strategy

Our opinion is based on our Microsoft Business Solutions Great... Read More

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for... Read More

Software Engineering: An Introduction

Software Engineering is the Systematic Approach for analysis design implementation... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

beta led street light led lighting wholesalers Pete's produce ..
beta led street light led lighting wholesalers Pete's produce ..