Software Information |
|
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, [email protected] 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: [email protected]
|
RELATED ARTICLES
Microsoft CRM Data Import FAQ Microsoft CRM has built-in conversion tool, however you should probably first try third party conversion tool, such as Scribe. It is relatively expensive and has bunch of importing capabilities, that you might never use and need. Scribe allows you to map objects in source and target, when source is ACT! for example. If you are just realized the need to load data into CRM ? please research Microsoft CRM import tool and Scribe. Here we will describe other option and possibilities Microsoft Great Plains SOP: Sales Order Processing Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). The Secret of the Layer Styles Dialogue When you double-click a layer in the Layer Palette, you will access the Layer Style dialogue box. Here, you can set many eye-catching layer styles such as Bevel & Emboss, Drop Shadow, Inner Shadow, etc. Mozilla Vs. Firefox For those who are unclear on the differences between the Mozilla package (Netscape is also comparable to Mozilla except they're two different companies) and Firefox / Thunderbird, here it is: Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights Logistics automation is often considered as barcoding extension to Sales Order Processing, Purchase Order Processing, Inventory Control modules. Software extensions makers may disagree with this simplification, but budget solution works exactly like barcoding extension and is usually done via Great Plains Dexterity, Modifier with VBA and SQL stored procedures. If your company is looking for implementing automated inventory bin/item pickup and conveyer ? then you need specialized software. However if you just envision your warehouse workers with barcode scanners ? then read this article to understand your options with Microsoft Business Solutions Great Plains. Imagine if Everyone Working In Your Office Was In Synch? Microsoft-Outlook is a pretty amazing program. So much more than simply an e-mail client, it provides a task list, a powerful calendar with recurring scheduling capabilities, wonderful electronic sticky notes, mail-merge capability with MS-Word support and so much more. Microsoft Great Plains Inventory Control ? Overview For Consultant Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features. Artificial Intelligence And Intuition The intuitive algorithm. ERP for Large Corporation ? New Selling Strategy Our opinion is based on our Microsoft Business Solutions Great Plains, Microsoft CRM sales and marketing campaign to large businesses in the following industries: Aerospace, Furniture, Beverages, Placement, Distribution & Logistics, Textile, Services, Food, Manufacturing. With the new economy recovery we see signs on the market, signaling selling strategy change. On the other hand this is normal process and each time you sell different, probably keeping your personal passion to sell and help your customers. Let's look at the trends: Constructionalist Parsing - Deciphering Natural Language The research in the field of Natural Language Processing usually assumes the existence of a syntactic "Generative Engine" that combines words and word-like elements into syntactic structures, and then sometimes displaces them by "syntactic movement". A Linguistic Parser must "undo" all the effects of syntactic movement, which results in a structure where the relations between the words are represented more directly. Microsoft Great Plains Installation ? Overview for IT Director/Controller Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0 Save Your Resources - Combine Your IM Clients There are so many different programs that clutter up your desktop and icon bar, every program using up your precious resources! How much faster would your PC if you could run one single program as opposed to three or more instant messenger clients? Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights Microsoft Great Plains is one of the Microsoft Business Solutions family ERP products: Great Plains, Navision, Axapta, Solomon, Small Business Manager. MBS also has Microsoft CRM - Client Relation Management software and Microsoft Retail Management System (Microsoft RMS) Accessing XML Using Java Technologies The most important benefit of XML is its simplicity. Though it is simple it is powerful enough to express complex data structures. Java is one of most important programming languages that is used for creating your web pages. Groupware: Answers the 5 Questions of Document Collaboration Every organization which creates collaborative documents, whether they are budgets, presentations, reports, spreadsheets, or other documents recognizes that collaborative efforts are requirement. That collaboration always forces the 5 eternal document collaboration questions: Who? What? Where? When? How? The reason I refer to them as eternal is that every day businesses are faced with these questions and rarely find the answers when they collaborate on documents. Your Computer May Be Infected, Heres How To Check (NOT about virus) NOTE: Please take time to read on - it may be vital for your PC's security. If you are not in the mood, just save it or print it out for later reference. Keeping Track One of the things we can be as certain of as death and taxes is that in every meeting at least one person will hand out a document for comments and discussion. But think of the huge workload this gives rise to for the author. She can only hope that not too many people respond, or that they don't all do so at once! Destination: Desktop for Google First we had the original Google search that evolved into the leader in its class. In fact, it became so popular that the word "google" worked its way into our everyday language as a verb, as in "to google" something. Google later introduced a toolbar that was plug-in for some browsers like Internet Explorer. The Google toolbar features a direct Google search box with quick access to image and group searches, a pop-up blocker, and for Internet marketers mostly, a PageRank (PR) indicator. Microsoft CRM Implementation & Customization: MS CRM Fax Gateway With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion. How the Firefox: How to... Manual Helped Me A few months back I really got sick of my computer always being slow and having system errors. So I started doing a bit of research and heard of a new browser called "Firefox". |
home | site map |
© 2005 |