crane siding antioch replace siding installing vinyl siding best siding highland park hardie board siding libertyville .. 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:

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Groupware as a Document Manager: Collaboration Series #3

This article is the third of a series of articles... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

Many reasons made GBM a unanimous choice for experts, one... Read More

ERP for Large Corporation ? New Selling Strategy

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

Guide to Software Marketing

Intro This concise article will tell you in plain English... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Configure Windows Indexing Service for Performance

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

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Microsoft Great Plains SOP: Sales Order Processing

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Software Automation Helps Increase your Bottom Line

When you own a small business, time is money. And... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

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

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

The Software 2005 Conference - A Review

The Software 2005 conference is now a wrap. This conference,... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA... Read More

led vs induction lighting street light installation Pete's produce ..
led vs induction lighting street light installation Pete's produce ..