OData and DB2: open data for the open web
- Posted: Nov 08, 2012 at 9:12AM
Right click “Save as…”
OData is a web protocol that unlocks data silos to facilitate data access from browsers, desktop applications, mobile apps, cloud services, and other scenarios. In this screencast, you'll see how easy it is to set up on OData service (deployed on Windows Azure) for an IBM DB2 database (running on IBM's cloud service), with examples of how to use the service from browsers, client apps, phone apps, and Microsoft Excel.
Here's an overview of the screencast, with links to specific sections:
[00:29] architectural overview. A high-level view of the components that make up the demo service.
[02:23] connecting to an IBM DB2 database. How to install the DB2 driver and set up a connection to a DB2 database.
[03:45] creating the entity data model. How to create an entity data model in Visual Studio, including selecting tables from the data source, customizing names, hiding columns, and defining relationships, complex types, and scalar properties.
[08:44] creating the WCF data service (OData feed). How to create a WCF data service that exposes the entity data model as an OData endpoint.
[10:43] testing the service locally. Debugging the service in Visual Studio, and querying the service to return the metadata that defines the entity data model.
[12:34] OData queries in the browser. Examples of the simple and consistent syntax of OData queries, and how to return tables/collections or individual entities, how to filter and sort results, and how to display a stored image in its native mime type.
[15:05] consuming the OData service from a .NET client application. A simple ASP.NET Dynamic Data Entities web site that can be used to navigate and edit the data exposed by the OData service.
[16:07] consuming the OData service from a Windows Phone app. Consuming the OData service from a Windows Phone application.
[17:11] consuming the OData service from Excel with the PowerPivot add-in. With the free PowerPivot add-in, you can use Excel to query, analyze, and report on data from any OData service.