The CData MCP Server for SAP Gateway models SAP Gateway entities in relational Tables, Views, and Stored Procedures. The table definitions are dynamically obtained from the OData service(s) you connect to. Any changes in the metadata, such as added or removed columns or changes in data type, can be loaded by reconnecting.

SAP Gateway provides multi-schema support via the Service property. Set this property to one service or a comma-delimited list of services you want to retrieve data from. If Service is not set and the service is not set in the URL, the SAP Gateway's catalog service is used to discover all the available services.

Tables

The server models the writable entity sets and singletons described in the service metadata document as bidirectional Tables.

Views

Some OData entities can only be accessed through Navigation Properties. By default, the server models navigation properties as separate views. See Views for more information on querying navigation properties.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.