Connector for OData — Features and settings

You can connect to and access data from OData. OData (Open Data Protocol) is a standard for providing data as a web service. You can use the OData connector in Spotfire to load data from any web service complying with the OData standard. On this page, you can find information about the capabilities, available settings, and things to keep in mind when you work with data connections to OData.

Page content

Connector features

The following functionality is available when you access data with the connector for OData.


Feature	Supported?
Load methods	Imported
Custom queries	No
Stored procedures	No
Custom connection properties	No
Single sign-on with identity provider	No
Authoring in web client	No
Included in Spotfire distribution on Linux	Yes

Data source properties

The following are the supported data source properties that you can configure when you create a data connection with the connector for OData.


Option	Description
Service URL	The address to the web service. For example, to a SharePoint server, or to Azure Marketplace. Note: If you are connecting to Azure Marketplace, see Finding the Service URL for information about how to locate the URL. If you are connectiong to SharePoint, see Modifying the SharePoint URL to learn how to construct the URL.
Authentication method	The authentication method to use when connecting to the data source. None Select this option if no authentication is needed when logging into the data source. Username and password Select this option if the authentication should be done using a web service user. Credentials can be stored, unencrypted, as part of the analysis file, using a setting in the Data Source Settings dialog. If credentials are found in the analysis file, they will be used to automatically authenticate against the web service. If no credentials or credentials profiles are found in the analysis file, all users who open the file will be prompted for credentials. Note that there will be no prompting for credentials if the credentials embedded in the analysis file fail. Windows authentication Select this option to use your Windows user account. Example of a username including domain: `domain\username` Microsoft Azure Marketplace Use this option to connect using a Microsoft Azure Marketplace account. See OData example: Loading data from Microsoft Azure Marketplace to learn more.
Account key	[Only applicable when using Microsoft Azure Marketplace authentication.] Paste your Microsoft Azure Account key into the text field. If you are unsure where to find you account key, see Finding your Account Key.

Supported data types

When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. The following are the data types that the OData connector supports.


Database data type	Spotfire data type
Edm.Binary	Binary
Edm.Stream	Binary
Edm.Boolean	Boolean
Edm.Date	Date
Edm.DateTime	DateTime
Edm.DateTimeOffset	DateTime
Edm.Byte	Integer
Edm.SByte	Integer
Edm.Int16	Integer
Edm.Int32	Integer
Edm.Int64	LongInteger
Edm.Double	Real
Edm.Guid	String
Edm.String	String
Edm.Time	Time
Edm.TimeOfDay	Time
Edm.Duration	TimeSpan
Edm.Decimal (p, s)	When p = 0 and s = 0: Currency When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real

Note:

The OData connector does not support collection properties or navigation properties.

Supported functions

Because only imported (in-memory) data is supported for OData, you can use the functions available in the Spotfire in-memory data engine to work with your OData data.