SESSION CODE COS 208 Adam Wilson Program Manager

SESSION CODE: COS 208 Adam Wilson Program Manager Microsoft Corporation

Flat file I need data! Different formats Relational Hierarchical invoice Credit card Different billing free FTP Database Different access DVD Web service Discovery Semantics

Office, Dynamics, SQL Server ISV Apps Custom Apps Marketplace Standard Data Access (OData) Billing Analytics Services for Content Providers I need data!

http: //apps. facebook. com/crimestats http: //silverlight. onterrasys. com/Crime. Demo/

Find and subscribe to dataset in “Dallas” portal http: //www. sqlazureservices. com Understand dataset query/response format using Service Explorer In your app, make request and process Atom. Pub response

A quick way to explore “Dallas” datasets Learn about data format and perform quick queries View results in various formats Available for every dataset Fill in parameter values using guided help Click “Analyze” to continue exploring in Power. Pivot and Excel to create Pivot. Tables, graphs, etc.

Trusted marketplace for premium data

var context = new Dallas. Data. Service. Context(new Uri(. . . )); var r = from c in context. Crimes where c. Robbery / c. Population > (from c 2 in context. Crimes select (c 2. Robbery / c 2. Population)). Sum() select c; service/$metadata Service/Crimes? $filter=. . .

Current CTP 2 providers include

High costs Proprietary apps Hard to discover Proprietary protocols Content Privacy Security Reports Service SLA Authentication Billing PR Licensing Authorization Application support $$

Standard Integrated One stop shop Powered by Windows Azure Content Providers MS Products “Dallas” Content consumers (Developers, IWs) ISVs

www. microsoft. com/teched www. microsoft. com/learning http: //microsoft. com/technet http: //microsoft. com/msdn

// Construct the request Web. Request request = Web. Request. Create( "https: //api. sqlazureservices. com/Data. Gov. Service. svc/" + "crimes/Louisiana? city=New%20 Orleans&year=2007"); // Add headers required by Dallas request. Headers["$account. Key"] = "28 Q 3 Twd. Ww. Ip 5 WPa. Jn. Ks. CNst. GFi 1 EKXs 6 X 5 e. V 0 Jn. V 6 HM="; request. Headers["$unique. User. ID"] = "47676 c 3 b-7 c 9 a-4 cdc-8 ad 2 -51 b 4 c 795 baba"; // Read and display the response using (var reader = new Stream. Reader(request. Get. Response(). Get. Response. Stream(), true)) { XDocument xml = XDocument. Parse(reader. Read. To. End()); string burglary. Value = xml. Root. Descendants(). First(el => el. Name. Local. Name == "Burglary"). Value; Console. Write. Line("There were {0} burglaries in New Orleans in 2007. ", burglary. Value); }

<feed xmlns="http: //www. w 3. org/2005/Atom" xmlns: d="http: //schemas. microsoft. com/ado/2007/08/dataservices" xmlns: m="http: //schemas. microsoft. com/ado/2007/08/dataservices/metadata"> <title type="text">Data. Gov - U. S. Offenses Known to Law Enforcement</title> <id>https: //api. sqlazureservices. com/Data. Gov. Service. svc/crimes/Louisiana? city=New Orleans& year=2007& $format=atom 10</id> <rights type="text">2010 U. S. Government</rights> <updated>2010 -05 -31 T 23: 28: 17 Z</updated> <link rel="self" title="Data. Gov - U. S. Offenses Known to Law Enforcement" href="https: //api. sqlazureservices. com/Data. Gov. Service. svc/crimes/Louisiana? city=New%20 Orleans& year=2007& $format=atom 10"/> <entry> <id>https: //api. sqlazureservices. com/Data. Gov. Service. svc/crimes/Louisiana? city=New Orleans& year=2007& $format=atom 10& $page=1& $itemsperpage=1</id> <title type="text">Louisiana / New Orleans in 2007</title> <updated>2010 -05 -31 T 23: 28: 17 Z</updated> <link rel="self" href="https: //api. sqlazureservices. com/Data. Gov. Service. svc/crimes/Louisiana? city=New%20 Orleans& year=2007& $format=atom 10& $page=1& $itemsperpage=1"/> <content type="application/xml"> <m: properties> <d: State m: type="Edm. String">Louisiana</d: State> <d: City m: type="Edm. String">New Orleans</d: City> <d: Year m: type="Edm. Int 32">2007</d: Year> <d: Population m: type="Edm. Int 32">220614</d: Population> <d: Robbery m: type="Edm. Int 32">1154</d: Robbery> [. . . ]