Deploying OData Services using IIS & SQL Server. Zoiner TejadaHershey Technologies Published: April 2011 Summary This white paper will familiarize you with the options available for deploying OData Services that are hosted in IIS and backed by a Microsoft SQL Server database.
In this whitepaper we show: Web Service Alternatives: SOAP and OData. Microsoft Dynamics NAV supports OData web services in addition to the SOAP web services that have been available since Microsoft Dynamics NAV 2009.
Developers planning to create Microsoft Dynamics NAV web services may need to decide which type of web service is better suited to their needs. First, there are some absolute limitations: SOAP Web Services SOAP web services allow full flexibility for building operation-centric services. They provide industry standard interoperability. The most common type of messaging pattern in SOAP is the Remote Procedure Call (RPC), where one network node (the client) sends a request message to another node (the server), and the server sends a response message to the client. WCF Data Services Client Library. Any application can interact with an Open Data Protocol (OData)-based data service if it can send an HTTP request and process the OData feed that a data service returns.
This interoperability enables you to access OData-based services from a broad range of Web-enabled applications. WCF Data Services includes client libraries that provide a richer programming experience when you consume OData feeds from .NET Framework or Silverlight-based applications. This section describes how to use client libraries to access and change data from a .NET Framework client application. Tutorial: Creating and Consuming a WCF Sync Service. This tutorial contains three mandatory walkthroughs followed by an optional walkthrough.
It also contains a topic that includes steps to troubleshoot service or client related issues. Walkthrough: Creating a Sample Database In this walkthrough you will create a database that is used by the sample sync service and use the SyncSvcUtil utility to create sync related artifacts in the database. Task 1: Creating a sample database Open a command prompt with administrative rights and switch to C:\Program Files\Microsoft SDKs\Microsoft Sync Framework\4.0\Samples\Config folder. Leave this Command Prompt window open so that you can use it later in this walkthrough. Task 2: Provisioning the database In this task you will provision the database using the SyncSvcUtil.exe tool. In the Command Prompt window from Task 1, type the following command and then press ENTER. ..\.. Walkthrough: Creating a Sync service In this walkthrough you will create a simple sync service. Pre-requisites Note Pre-Requisites. Windows Azure and SQL Database Tutorials - Tutorial 2.1: Create an OData Service (en-US)
OData - TechNet Articles - United States (English) - TechNet Wiki. OData Web Services. Research Mobile - OData - Open Data for the Open Web. There is a vast amount of data available today and data is now being collected and stored at a rate never seen before.
Much, if not most, of this data, however, is locked into specific applications or formats and difficult to access or to integrate into new uses. The Open Data Protocol (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. OData is being used to expose and access information from a variety of sources including, but not limited to, relational databases, file systems, content management systems and traditional websites.
Join us in this tutorial to learn how OData can enable a new level of data integration and interoperability across a broad range of clients, servers, services, and tools. Bring your laptop and you will have a chance to work OData into your own projects on whatever platform you choose. ©2010 Microsoft Corporation. Introduction to Open Data Protocol (OData) and SQL Azure - SQL Azure Team Blog. Introducing OData. Data Access for the Web, the cloud, mobile devices, and more David Chappell Chappell & Associates Published: May 2011 Download this whitepaper (PDF) Describing OData Our world is awash in data.
Allowing this kind of broad access to data is the goal of the Open Data Protocol, commonly called just OData. Open Data Protocol Q&A. Q: What is the Open Data Protocol?
A: The Open Data Protocol (OData) is a web protocol for querying and updating data. OData applies web technologies such as HTTP, Atom Publishing Protocol (AtomPub) and JSON to provide access to information from a variety of applications, services, and stores. OData emerged organically based on the experiences implementing AtomPub clients and servers in a variety of products over the past several years. OData is being used to expose and access information from a variety of sources, including but not limited to relational databases, file systems, content management systems, and traditional web sites. Microsoft has released OData under the Open Specification Promise (OSP) to allow anyone to freely interoperate with OData implementations.
There is a growing list of products that implement OData. The Open Data Protocol was previously talked about in three ways: “Astoria” ProtocolADO.NET Data Services Protocol“Our conventions/extensions to AtomPub” Wiki Article: Q&A on Open Data Protocol (Odata) - SQL Azure Team Blog.