OData connection

To access your data in OData, create a connection asset for it.

The OData (Open Data) protocol is a REST-based data access protocol. The OData connection reads data from a data source that uses the OData protocol.

Supported versions

The OData connection is supported on OData protocol version 2 or version 4.

Create a connection to OData

To create the connection asset, you need these connection details:

  • Service root URL: The URL to access the service root of a site that has implemented the OData protocol. Consult the client product's documentation to confirm the Service root URL.
  • Timeout seconds: Timeout value for the HTTP calls.

Credentials type:

  • API Key
  • Basic
  • None

Encryption:
SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.
In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In a deployment space
Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog
Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use the OData connection in the following workspaces and tools:

Projects

  • Data Refinery (Watson Studio, IBM Knowledge Catalog any edition)
  • Notebooks (Watson Studio). Click Read data on the Code snippets pane to get the connection credentials and load the data into a data structure. See Load data from data source connections.
  • SPSS Modeler (SPSS Modeler service)
  • Synthetic Data Generator (Synthetic Data Generator service)

Catalogs

  • Platform assets catalog

  • Other catalogs (IBM Knowledge Catalog)

Data Product Hub
You can connect to this data source from Data Product Hub. For instructions, see Connectors for Data Product Hub.

Federal Information Processing Standards (FIPS) compliance

This connection can be used on a FIPS-enabled cluster (FIPS tolerant); however, it is not FIPS-compliant.

OData setup

To set up the OData service, see How to Use Web API OData to Build an OData V4 Service without Entity Framework.

Restrictions

  • For Data Refinery, you can use this connection only as a source. You cannot use this connection as a target connection or as a target connected data asset.
  • For SPSS Modeler, you cannot create new entity sets.

Learn more

www.odata.org

Parent topic: Supported connections