Office 2010 Key Get to Access Services tables with

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,Office 2007 Serial, Microsoft SQL Azure, SQL Server Reporting Services; and live services like: Netflix or DBpedia among others. SharePoint 2010, 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 Professional, 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,Office 2007 Serial, 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,Microsoft Office 2007 Enterprise, 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, “Get External Data” section, select “From Data Feeds”. b) Enter the OData entry point,Office 2010 Key, 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