Show TOC

Function documentationOData Service Data Sources

 

You can extract data from OData Service data sources. Extracting data from OData sources allows you, for example, to compare data in a “hybrid” scenario where some of your data is stored in the cloud (and there is a corresponding OData service for it) and other data is stored on-premise.

Prerequisites

You have created an RFC connection of type HTTP Connection to External Server and specified the target system on the Technical Settings tab of transaction SM59. For example, you have entered the target host services.odata.org and the path prefix /V2/OData/OData.svc/.

Activities

If you select OData Service as your source type, you must enter the RFC destination for the OData service. You then create your data model by specifying entities of the OData service as the tables and properties of the OData service as the fields.

On generation, a query is created for this data model. When you run the comparison, the query is used to extract the data.