#Office add ins for word 2010 how to#
#Office add ins for word 2010 full#
#Office add ins for word 2010 windows#

Therefore, an ECT can be easily created for connecting to any SQL Server database table or view, WCF service or Web service.

#Office add ins for word 2010 windows#

SharePoint Designer includes default support for connecting to external data sources including SQL Server, Windows Communication Foundation (WCF) and the Microsoft. Instead, itРІР‚в„ўs retrieved via the ECT when accessed by an end user. External lists look and act like any other standard list in SharePoint, but the external list data is not stored in SharePoint. Once the ECT has been created, an external list can be generated from it on any site within SharePoint.

The ECT contains metadata describing the structure of the back-end data, such as the fields and CRUD methods that SharePoint will use to interact with it. The first step is to create a new External Content Type (ECT). There are a couple steps required to do this. SharePoint Designer 2010 is the tool used for configuring access to a LOB system and making its data available in a SharePoint external list.

It would be better to access this customer data from the authoritative CRM system and expose it in SharePoint as an external list that Office clients can access. In real-life, you probably end up with users copying this information from various non-authoritative sources and pasting it into their Office documents. However, thereРІР‚в„ўs a customer table in the database with name and address data that could be used by many others if it were available. Why would you want to bring LOB data into SharePoint? Consider the use case where you have a customer relationship management (CRM) system that only a limited number of people in the organization can access directly.

#Office add ins for word 2010 full#

SharePoint 2010 provides Business Connectivity Services (BCS), which is an evolution of the BDC that supports full read/write access to your LOB data. MOSS 2007 let you to connect to LOB data using the Business Data Catalog (BDC), which provided read-only access to back-end systems. One particularly useful data source is an external list that displays data retrieved via a connection to a line-of-business (LOB) system. LetРІР‚в„ўs start by taking a quick look at the SharePoint list types you can employ as data sources.

#Office add ins for word 2010 how to#

In this article, weРІР‚в„ўll describe a couple of no-code solutions and show you how to build a few more-complex solutions using these new features in SharePoint 2010. Just as in Microsoft Office SharePoint Server (MOSS) 2007, a broad array of Web services is available in SharePoint 2010 for use as well.

These range from virtually no-code solutions made possible via SharePoint Workspace 2010 (formerly known as Groove), direct synchronization between SharePoint and Outlook, the new SharePoint REST API and the new client object model. With the release of SharePoint 2010, there are a number of new ways available to access SharePoint data and present it to the Office user. For enterprises looking at ways to improve end-user productivity, making SharePoint data available directly within Office applications is a significant option to consider. Some developers in the enterprise have not yet taken advantage of the opportunity to build custom functionality into Office applications-functionality that can provide a seamless, integrated experience for users to directly access SharePoint data from within familiar productivity applications.

In ever-increasing numbers, many are interacting with Microsoft SharePoint as a portal for collaboration and as a platform for accessing shared data and services. Millions of people use the Microsoft Office client applications in support of their daily work to communicate, scrub data, crunch numbers, author documents, deliver presentations and make business decisions. Volume 25 Number 07 Office Add-Ins - 3 Solutions for Accessing SharePoint Data in Office 2010