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: How to manually deploy OData servicesHow to deploy OData services using Visual Studio Scenario Introduction In this whitepaper we follow the scenario of creating and deploying an OData service as a WCF Data Service hosted in IIS that exposes data queried from SQL Server.
Figure 1 - OData deployment scenarios covered in this whitepaper. Assumptions & Pre-requisites This whitepaper assumes you will be hosting in IIS 7 and not self-hosting (e.g., in Windows Service process). ASP.NET Web Site projectASP.NET Web Application projectWCF Service Application project / WCF Workflow Service Application project The database used by the example is AdventureWorksLT. The list of components that need to be installed on each tier are as follows: Development. 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.
Windows Communication Framework (WCF) has supported SOAP services since its initial release in .NET Framework 3.0, and later releases of the .NET Framework have added additional support and default bindings to make it easier to build SOAP services using WCF. 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.
OData Web Services See Also. 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. For more information about how to use the WCF Data Services client library with a Silverlight-based application, see WCF Data Services (Silverlight). Other client libraries are available that enable you to consume an OData feed in other kinds of applications. 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. The Open Data Protocol (OData) is a web protocol that is designed for querying tabular data and provides you with an alternative to SOAP-based web services. OData builds on web technologies such as HTTP, the Atom Publishing Protocol (AtomPub), and JavaScript Object Notation (JSON) to provide access to information from different applications, services, and stores. OData uses URIs for resource identification and commits to an HTTP-based, uniform interface for interacting with resources. This commitment to core Web principles allows for OData to enable a new level of data integration and interoperability across a broad range of clients, servers, services, and tools.
You can use OData web services to show Microsoft Dynamics NAV data, and you can update data in a Microsoft Dynamics NAV database using OData web services. OData can be found in other Microsoft products and technologies, including the following: Microsoft Excel implements OData for its PowerPivot add-in. 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. All rights reserved. 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. The Problem: Accessing Diverse Data in a Common Way There are many possible sources of data. One solution is for every data source to define its own approach to exposing data. Thinking about some typical problems illustrates why this approach isn't the best solution.
Defining a common approach makes much more sense. The Solution: What OData Provides OData defines an abstract data model and a protocol that let any client access information exposed by any data source. Figure 1: Any OData client can access data provided by any OData data source. As the figure illustrates, OData allows mixing and matching clients and data sources. OData was originally created by Microsoft. The OData Data Model. 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. We intend on working with others in the community to move the features of OData into future version of AtomPub or other appropriate standards. There is a growing list of products that implement OData. Wiki Article: Q&A on Open Data Protocol (Odata) - SQL Azure Team Blog.