--- title: Hybrid Azure applications using OData | daily.dev description: A walkthrough shows how to expose an on-premise SQL Server database to a Windows Azure application without opening firewall ports, by wrapping the database in... canonical: https://daily.dev/posts/hybrid-azure-applications-using-odata-czvdkgnzm twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Hybrid Azure applications using OData | daily.dev og:description: A walkthrough shows how to expose an on-premise SQL Server database to a Windows Azure application without opening firewall ports, by wrapping the database in... og:url: https://daily.dev/posts/hybrid-azure-applications-using-odata-czvdkgnzm og:image: https://api.daily.dev/og/posts/czvdKgNZm.png og:image:alt: Hybrid Azure applications using OData og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Hybrid Azure applications using OData **[Maarten Balliauw](https://daily.dev/sources/maartenballiauw)** · 7 min read · 0 upvotes · 0 comments ## Summary A walkthrough shows how to expose an on-premise SQL Server database to a Windows Azure application without opening firewall ports, by wrapping the database in an OData feed built with WCF Data Services and relaying it through Windows Azure platform AppFabric Service Bus. Steps cover building a console-hosted WCF service, configuring webHttpRelayBinding and service bus credentials in App.config, writing the custom WebServiceHost, and consuming the resulting feed both via browser and from a .NET client. The post notes updates aren't supported out of the box and that full database access still requires alternatives like PortBridge. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Running a production-like local environment with Aspire](https://daily.dev/posts/running-a-production-like-local-environment-with-aspire-7qzdip0aa) · Tim Deschryver · 0 upvotes · 0 comments - [Deploying ASP.NET Core Web API to Azure and Docker](https://daily.dev/posts/deploying-asp-net-core-web-api-to-azure-and-docker-cvbz8psyb) · We Are .NET · 2 upvotes · 0 comments - [Create a WCF Web Service in Visual Studio 2015](https://daily.dev/posts/create-a-wcf-web-service-in-visual-studio-2015-lhamcmupt) · C\# Corner · 1 upvotes · 0 comments --- Tags: [#azure](https://daily.dev/tags/azure), [#.net](https://daily.dev/tags/.net), [#hybrid-cloud](https://daily.dev/tags/hybrid-cloud) [View this post on daily.dev](https://daily.dev/posts/hybrid-azure-applications-using-odata-czvdkgnzm) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Hybrid Azure applications using OData","url":"https://daily.dev/posts/hybrid-azure-applications-using-odata-czvdkgnzm","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/hybrid-azure-applications-using-odata-czvdkgnzm"},"datePublished":"2026-10-04T13:04:42.118Z","dateModified":"2026-10-04T13:06:16.777Z","description":"A walkthrough shows how to expose an on-premise SQL Server database to a Windows Azure application without opening firewall ports, by wrapping the database in...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/d3366642ab5df8b2262130225345b7cf?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/d3366642ab5df8b2262130225345b7cf?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Maarten Balliauw","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Maarten Balliauw","logo":"https://media.daily.dev/image/upload/s--rOTg3VYO--/f_auto,q_auto/v1791119043/logos/maartenballiauw?_a=BAMAMicg0","url":"https://daily.dev/sources/maartenballiauw"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/hybrid-azure-applications-using-odata-czvdkgnzm","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"azure,.net,hybrid-cloud","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Maarten Balliauw","item":"https://daily.dev/sources/maartenballiauw"},{"@type":"ListItem","position":3,"name":"Hybrid Azure applications using OData"}]} ```