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:

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 Add to project > Connection. 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 Add to space > Connection. See Adding connections to a deployment space.

In the Platform assets catalog Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

• See Add data from a connection in a project.
• See Add data from a connection in a catalog.

Where you can use this connection

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

Analytics projects

• Data Refinery (Watson Studio or Watson Knowledge Catalog)
• Notebooks (Watson Studio). Use the insert-to-code function 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)

Catalogs

• Platform assets catalog
• Other catalogs (Watson Knowledge Catalog)

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