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 sample test service provided by odata.org.

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

Click the Name box and enter a name for this connector (e.g., OData Sample Service).

Set the Data Provider dropdown to OData.

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

Set the Address to the service address, such as: http://services.odata.org/OData/OData.svc/

Select the Authentication method. For this example, select Anonymous.

Tip
You can use the Online Credentials authentication method to connect to SharePoint Office 365.

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, then locate and expand your data connector.

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 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.

4. 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

5. Using query options

Queries sent to the data source can include various options that you can set, including $filter$expand$top$skip, $select$orderby, and (when using OData version 4) $search.

These can be set when selecting a table in a data cube, by configuring its Tabular Select transform and clicking Define parameters.

Query options available in the Tabular Select's parameters
Query options available in the Tabular Select's parameters

Click to edit one of the predefined parameters, and set the Value using the syntax used by OData query options following the equal (=) sign.

For example, the $filter parameter could be set to IataCode eq 'LAX'.

You will also find a Programmatic Structures folder located directly under the data connector, listing the results of the $count query option for each table, which you can drag onto a data cube or metric set.

Programmatic Structures folder
Programmatic Structures folder

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