Create an OData Producer Service Model

Use the Model option in the OData Server configuration file to create an OData Producer service model.

You can create an OData Producer service model to expose specific tables and views by defining a namespace (the model) in a text file that complies to the OData Service Definition Language (OSDL) syntax. The model is applied to the OData Producer when you reference the text file using the Model option in your OData Server configuration file.

Syntax

service [namespace "namespace-name"] {
    "owner"."{table-name | view-name}" [ keys("column-name", ...) ]
    ...
  }

Parameters

namespace-name – is the name of the service you define. Append _Container to service-name to generate a container name.
owner – is the name of the owner of the table or view.
table-name | view-name – is the name of the table or view to expose in the OData metadata.
column-name – is a column name to use as a primary key when one is not specified in the table or view defined by table-name or view-name. You can reference multiple column names.

Examples

Exposing a table and a view – this service model exposes a table and a view:

service namespace "DBServer" {
    "dba"."TableWithPrimaryKey";
    "dba"."ViewWithoutPrimaryKey" keys("primary_key1", "primary_key2");
}

Usage

You can define a service that contains references to multiple tables or views.
When using the keys parameter:
- Specify a key list when referencing a table or view that does not contain a primary key.
- Do not specify a key list when referencing a table that contains a primary key.

The model is applied to the OData Producer when you reference the text file using the Model option in your OData Server configuration file.