For developers that were around at the time, the development and publishing of “Open Database Connectivity (ODBC)” drivers in the 1990’s was a game-changer for the development of client/server applications. ODBC provided a translation layer between the client application’s use of embedded SQL and the back-end database. This gave developers the ability to port applications […]
Posts Tagged ‘odata’
Configuring SharePoint 2013 Preview for On-Premise Apps
Since Apps are the “next big thing” for SharePoint, from an opportunity perspective, expect to see a lot of hullaballoo about how you should create apps because they’re going to be the greatest thing to happen to SharePoint since Shared Service Applications replaced the Shared Services Provider. However, not all apps are created equal, and […]
Client data access with OData and CSOM in SharePoint 2013
SharePoint 2013 has improved OData support. In fact, it offers full-blown OData compliant REST based interface to program against. For those who aren’t familiar with OData, OData is an open standard for querying and updating data that relies on common web standard HTTP. Read this OData primer for more details. The obvious benefits are: 1. […]
Consuming OData sources in SharePoint 2013 App step by step
SharePoint 2013 has an out-of-box supports for connecting to OData sources using BCS. You no longer are required to write .Net assembly connector to talk to external OData sources. 1. Open Visual Studio 2012 and create a new SharePoint 2013 App project. This project template is available after installing office developer tools for Visual Studio […]
31 Days Of OData – Day 5 Addressing Entities In OData
Before we can learn about Addressing Entities in OData, we have to lay the ground work for all OData commanding including queries. We will first detail and demonstrate the Uniform Resource Identifier or URI and then look at a URI for OData. What is a URI? An URI is a string that is used to […]
31 Days of OData – Day 4 Metadata in OData
Let’s go back 15 years ago when I started professionally developing software and using relational databases. The relational database was a great tool to deal with data. No more did we have to use flat files to store our data with tools named Paradox, dBase and other such data management systems. We now had more […]
31 Days of OData – Day 3 OData Entity Data Model
From Day 2 of the series, we looked at data types that are present in the OData protocol. These data types allow for the richness of the data experience. Next we will look at taking these data types and crafting the entities that make up the OData feed. An OData feed is very much like […]
31 Days of OData – Day 2 Data Types of OData
Since data is the basis for all OData feeds it is natural to see then that describing the data that represents the types Entities with in the feed is important. It is not only important for the data but also for the metadata that plays a significant role in the OData protocol. The OData protocol […]
31 Days of OData – Day 1 Background of OData
What is the Open Data Protocol? The official statement for Open Data Protocol (OData) is that 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. Really what that means is that we can select, save, delete and […]