Connecting to OData

Contents[Hide]

1. Overview

OData (or Open Data Protocol) is a REST-based data access protocol which was initially defined by Microsoft.

This article shows you how to connect to OData services such as Microsoft Azure Marketplace.

For a list of available services, see OData - Live Services.

2. Connect to the OData Sample Service

Follow these steps to connect to a test/sample service provided by odata.org.

Go to the main menu in Dundas BI and create a new data connector.

Set the Data Provider dropdown to OData.

Click the File Name box and enter OData Sample Service as the name of the data connector.

Create a new data connector for OData
Create a new data connector for OData

Set the Address to: http://services.odata.org/OData/OData.svc/

Select Anonymous as the Authentication method.

Set the address and authentication method
Set the address and authentication method

Click Submit to create the data connector and connect to the service.

To check the results, create a new dashboard from the main menu.

Expand the Data Connectors folder in the Explore window.

Locate the OData Sample Service data connector and expand it.

Drag one of the OData tables to the dashboard canvas to see its data.

Drag a table to the canvas
Drag a table to the canvas

3. Connect to Azure Data Market

3.1. Sign up for a data service

Follow these steps to sign up for a free data service from the Microsoft Azure Marketplace DataMarket.

Go to the Find & Purchase Data Subscriptions page.

Click the data service you want to connect to, such as the London Borough Profiles Data service, which is free of charge.

Click Sign Up (top-right corner).

You will be asked to enter a Windows Live ID. If you have an existing hotmail or messenger account, you can supply that email address. Or, you can set up a new live.com email address.

Register with the Microsoft Azure Marketplace by entering your contact information.

Sign Up to gain access to your selected data service.

Sign up for the selected data service
Sign up for the selected data service

On the Thank You page, click Explore This Dataset.

Note the following information which is needed to set up the data connector:

  • Primary Account Key - Click Show to see the account key. Copy the key text and paste into Notepad for later use.
  • URL for current expressed query:
    • https://api.datamarket.azure.com/GreaterLondonAuthority/LondonBoroughProfiles/v1/LondonBoroughProfile

Explore the dataset and copy the account key
Explore the dataset and copy the account key

3.2. Connect to the data service

Next, create a new data connector named OData London Borough Profiles.

Set the Address to: https://api.datamarket.azure.com/GreaterLondonAuthority/LondonBoroughProfiles/

Select Azure Data Market as the Authentication method.

Set the Account key to the value obtained when you clicked Show in an earlier step (use copy-and-paste).

Set the address, authentication, and account key
Set the address, authentication, and account key

Click Submit to create the data connector and connect to the service.

To check the results, create a new dashboard from the main menu.

Expand the Data Connectors folder in the Explore window.

Locate the OData London Borough Profiles data connector and expand it.

Drag one of the OData tables to the dashboard canvas to see its data.

Drag a table to the canvas
Drag a table to the canvas

4. Connect to SharePoint

You can also connect to data on your SharePoint server using the OData protocol.

For example, set the Address to http://spserver/_vti_bin/listdata.svc/ and the Authentication method to Specified Windows credentials.

5. Advanced properties

By default, the OData connector will auto-detect the OData version, but you can use the OData Service Version option to force a specific version such as V1, V2, V3, V4, etc.

The Records Per Page option specifies the number of records or rows to fetch at a time. By default, it is set to 100 but you can increase this in order to load data faster.

Advanced OData settings
Advanced OData settings

6. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri