The ODataAdapter is the only Smart Data Integration adapter that does not use a data provisioning agent. Instead the adapter runs in the HANA tenant's dpserver, and is disabled by default. The adapter does not have real time data capture capabilities, so creating a remote subscription based on an ODataAdapter virtual table will fail by design.
The remote source is configured at a broad service level, and virtual tables are created for individual entity sets or collections described by that OData service. Insert/update/delete/select statements on these HANA virtual tables are translated to POST/PUT/DELETE/GET requests and sent over HTTP/S. As of HANA SPS06, the adapter supports OData V2 and V4 protocols.
For official ODataAdapter documentation, see the following links and read through the subcategories to get a better understanding of the features and capabilities of this adapter.
- Installation and Configuration Guide
- Modeling Guide (SAP Web IDE and SAP Business Application Studio edition)
Common Questions or Problems
- If the ODataAdapter does not appear in the list of available adapters while creating a remote source:
- Activate the adapter in the dpserver with the following SQL (requires System Privilege - ADAPTER ADMIN): CREATE ADAPTER "ODataAdapter" PROPERTIES 'display_name=OData Adapter;description=OData Adapter' AT LOCATION DPSERVER;
- After creating the remote source, no remote objects can be seen in the metadata browser.
- First confirm that a connection test succeeds.
- If the connection is working but no remote metadata is found, confirm the remote source URL refers to the broad service level URL. You can verify you are entering a URL that can be understood by SDI by opening the URL in your web browser. The URL should be the "Service root URL", take for example https://services.odata.org/V4/Northwind/Northwind.svc. When opening the URL, you should see a list of collections for your specific service. In the following example from Northwind V4, the service has many collections including Customers and Employees, which can later be represented as virtual tables.
...<collection href="Customers"><atom:title type="text">Customers</atom:title></collection>
<collection href="Employees"><atom:title type="text">Employees</atom:title></collection>...
- Do you want to show navigation properties ($expand), which reveal relationships between entity sets in the OData service ?
- If yes, then set "Show Navigation Properties"= True for remote source configuration.
- SDI can only work with keys for Navigation Properties, other navigation field won't be displayed when creating virtual table.
- What authentication methods are supported with SDI ODataAdapter?
- For HANA SPS06 and SAP HANA Cloud, there are additional authentication options.
- doesn't support SAML, if you want to use SDI to connect to ODATA provider that enable SAML, you need to put in the "Extra Connection Parameters" in remote source connection with value "saml2=disabled"
- Tips for accessing SuccessFactors OData through SDI:
- It is highly recommended to apply a server-side paging method, and include historical data control parameters for your SuccessFactors virtual tables.
- Paging:
- Historical parameters:
- asOfDate: Select a single date historical version of the data.
- fromDate: Set the earliest date for a range of historical data that will be returned by the request.
- toDate: Set the latest date for a range of historical data that will be returned by the request.
- It is highly recommended to apply a server-side paging method, and include historical data control parameters for your SuccessFactors virtual tables.
- If you are connecting to an HTTPS secured OData services, please check the help document for detail steps.
- If all the configuration has been done and still there is error for remote source connection, please enabled the traces and gather the recommended information for efficient support.