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 ( 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

Buchanan travel from Midway ..
In The News:

Tech expert Kurt “CyberGuy" Knutsson shows you how to categorize open tabs into custom groups for streamlined browsing.
Tech expert Kurt “CyberGuy" Knutsson reveals how you can secure your iPhone/iPad: Strong passcode, biometric security and software updates.
Here's how you can take better family pictures by using your iPhone or Android's photo timer, a tripod, editing tools and a good prompt to get everyone to smile naturally.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
An internal investigation by Advance Auto Parts determined over 2 million people were affected by a data breach that exposed names, Social Security numbers and driver's licenses.
Toys "R" Us is back with a cutting-edge short film using artificial intelligence to tell the story of its origins that's innovative and nostalgic.
Elon Musk announced Tuesday that he plans to move the California headquarters for SpaceX to Texas, citing California Gavin Newsom's progressive politics.
Data breaches happen all the time – and it's important to take quick, decisive action if your information gets caught up in one. Here's how.
Retirement is perfect for starting a passion project and earning money. Tech expert Kurt “CyberGuy" Knutsson shows you how.
Tokyo researchers have developed a method to create living skin for robots by using perforation anchors. Kurt “CyberGuy" Knutsson reveals the exciting possibilities.
Tech expert Kurt “CyberGuy" Knutsson talks about how to secure your accounts and monitor credit if your number is found on the dark web.
Tech expert Kurt “CyberGuy" Knutsson discusses how Stanford’s HumanPlus robot learns tasks by watching humans.
Hackers are skipping attempts to infiltrate Facebook accounts. Now, they're using photos, names and information to clone Facebook accounts.
Scientists at the University of Tokyo have developed a robot that can drive a regular vehicle. Musashi is a humanoid robot that mimics humans.
AT&A announced a data breach that affected nearly all of the company's cellular customers, raising serious concerns about customer privacy and security.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Dave is the world's most advanced artificial intelligence Lego robotic head from Creative Mindstorms that combines toy blocks with cutting-edge AI technology.
Security robot Athena from Kody Robots is like a superhero among surveillance robots with brains of the most advanced artificial intelligence.
Researchers found the largest password leak ever with 10 billion unique passwords. Kurt “CyberGuy" Knutsson discusses how this a wake-up call for everyone who uses the internet.
Kurt “CyberGuy" Knutsson discusses how Kodiak Robotics’ tech may transform commercial/military transport.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Twilio confirmed to CyberGuy that hackers got access to 33 million phone numbers related to its Authy two-factor authentication service.
EOS-X Space, a Spanish company, is preparing to launch a luxury balloon capsule into near-space in 2025, allowing travelers to float to the stratosphere.
Scammers' newest frontier is real-estate — and bad actors finding targeting homeowners, buyers and sellers with their familiar dirty tricks.
Kurt “CyberGuy" Knutsson’s Prime Day guide: Top savings tips and cheap membership tricks.

Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

As we could imagine, if you are reading this article... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... 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

Microsoft CRM for Corporate Business ? Working Offline

If your company has regional and worldwide operations, you might... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

Microsoft Great Plains PM: Payables Management

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

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Dig Out That Worm

Internet worms. Is your PC infected?If your computer has become... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

Microsoft Great Plains serves majority of US based horizontal and... Read More

Groupware as a Document Manager: Collaboration Series #3

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

MSN Messenger Is A Sweet Way To Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

ERP for Large Corporation ? New Selling Strategy

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

Sussex limo Chicago ..