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

---

Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

Microsoft Business Solutions Great Plains is mid and even corporate... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

You Can Write Microsoft Office Program in About 60 Minutes

Microsoft Office program is a programming tool called Visual Basic... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Where to Find Free Fleet Maintenance Software

Costs of fleet maintenance software can vary widely. It is... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

This is a short article, written in question/answer/FAQ style to... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Do You Know These Facts About Spyware ?

Imagine something that follows you home and sets itself up... Read More

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

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

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

Microsoft Business Solutions Great Plains has substantial market share and... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

Looking for an Alternative to Microsoft Office? You Should Be!

Now is the time to look at an alternative to... Read More