THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a freelance data mangler in London

OData.org updated, gives clues about future SQL Azure enhancements

The OData website at http://www.odata.org/home has been updated today to provide a much more engaging page than the previous sterile attempt. Moreover its now chockful of information about the progress of OData including a blog, a list of products that produce OData feeds plus some live OData feeds that you can hit up today, a list of OData-compliant clients and an FAQ. Most interestingly SQL Azure is listed as a producer of OData feeds:

If you have a SQL Azure database account you can easily expose an OData feed through a simple configuration portal. You can select authenticated or anonymous access and expose different OData views according to permissions granted to the specified SQL Azure database user.

A preview of this upcoming SQL Azure service is available at https://www.sqlazurelabs.com/OData.aspx and it enables you to select one of your existing SQL Azure databases and, with a few clicks, turn it into an OData feed. It looks as though SQL Azure will soon be added to the stable of products that natively support OData, good news indeed.

@Jamiet

Related blog posts:

Published Tuesday, March 16, 2010 3:00 PM by jamiet
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Adam said:

Jamie,

I just went and checked out this website as I have never heard of it before and in principle it looks quite interesting. However, it looks like you need to be a hardcore .NET programmer to get anywhere with it. And, after reading through some of the sections on the website I don't really understand it's 'real world' purpose.

Can you help me out here...what do I need to know?

Thanks

March 18, 2010 1:55 PM
 

SSIS Junkie said:

Those that have followed my blogs for a while may know that I have a slightly banal interest in Windows

March 18, 2010 5:24 PM
 

jamiet said:

Hi Adam,

The way I think of it is this. For the past 15 years or so we've had ODBC which helped different kinds of databases on the same network LAN talk to each other. ODBC was a standard that database providers could adhere to that enabled that "talking" to occur.

Today we have a new network across which databases need to talk to each other - the internet. And its not just databases as we know them either, people are now surfacing spreadsheets, non-relational data stores, report data, queries, metadata etc... as queryable "things". Even a web page can be considered to be queryable data these days.

OData provides the same job that ODBC did - its a standard that can enable all of these things to talk to each other across the network.

Jon Udell describes it better in his blog post "OData is grease to cut data friction" (http://blog.jonudell.net/2009/11/18/odata-is-grease-to-cut-data-friction/)

-Jamie

March 19, 2010 6:40 AM
 

amorts said:

Hi Jamie,

Thanks for the description and the link. I can certainly see the requirement of something like OData, although the actual hands on use appears somewhat mystical!

Cheers,

Adam

March 19, 2010 6:02 PM
 

GoAzure said:

There is now the capability to crete and use an OData Service for SQL Azure in Azure AppFabric

For more information: http://blogs.msdn.com/netservices/archive/2010/04/20/how-to-use-the-odata-for-sql-azure-with-appfabric-access-control.aspx

April 27, 2010 2:12 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement