Microsoft Office 2010 Pro Get to Access Services t

OData is a Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today. There are already several OData producers like: IBM WebSphere, Microsoft SQL Azure, SQL Server Reporting Services; and live services like: Netflix or DBpedia among others. SharePoint 2010,Microsoft Office Enterprise 2007, is an OData provider as well and this enables Access Services as an OData provider as well. The following walkthrough shows how to extract data using OData from a published Access Northwind web template and consume it using Microsoft PowerPivot for Excel 2010. Publishing Northwind First,Microsoft Office 2010 Pro, we’ll need to instantiate the Northwind web database and publish it to SharePoint. Accessing OData Access Services 2010 stores it’s data as SharePoint lists; therefore, in order to retrieve tables through OData we’ll need to follow the same recommendations that apply for SharePoint lists. There are a couple blog posts with more details on SharePoint and OData here and here. For our Northwind application, the main OData entry point is located on This entry points describes all tables provided by the OData service, for instance, in order to retrieve the Employees table through OData, we would use Additional OData functionality is described in the OData developers page. Consuming OData One of the applications that consumes OData,Office Standard 2007 Key, is Microsoft PowerPivot for Excel 2010. In order to import data from Northwind into PowerPivot we can follow these steps: a) From the PowerPivot ribbon,Microsoft Office Enterprise 2007, “Get External Data” section, select “From Data Feeds”. b) Enter the OData entry point,Windows 7, for this scenario: c) Select the desired Northwind tables in the “Table Import Wizard”. d) Finish the wizard to retrieve the data from Access Services. The Northwind data should be now imported in PowerPivot and ready to be used from Excel.   <div