SAP BODS 4.2 - OData Adapter for OData version 4 doesn't work

[former_member676570]

Hi Team,

We have requirements to extract data from OData version 4 using SAP DS OData adapter with OAuth2.0.

Job Server and OData Adapter have been configured (see below configurations), however when we create a datastore by using Data Services Designer we received below error message.

Datastore configs: It uses OData version 4, this is due to the source of data only returning OData Version 4.

OData Adapter configs:

Classpath in the OData Adapter: Below is the list of jar files, I removed the root path for easy reading.

lib\acta_adapter_sdk.jar; lib\acta_broker_client.jar;

lib\acta_tool.jar; ext\lib\bcm.jar; ext\lib\cryptojFIPS.jar;

ext\lib\ssljFIPS.jar; ext\lib\xercesImpl.jar; ext\lib\xml-apis.jar;

ext\lib\log4j-1.2.15.jar; lib\acta_odata_adapter.jar;

ext\lib\odata4j-0.7.0-bundle.jar;

ext\lib\antlr-3.1.1-runtime.jar;

ext\lib\com.fasterxml-aalto-xml-0.9.10.jar; ext\lib\commons-codec-commons-codec-1.9.jar;

ext\lib\commons-io-commons-io-2.4.jar;

ext\lib\commons-logging-commons-logging-1.2.jar;

ext\lib\org.apache.commons-commons-lang3-3.3.2.jar;

ext\lib\org.apache.httpcomponents-httpclient-4.2.6.jar;

ext\lib\org.apache.httpcomponents-httpcore-4.2.5.jar;

ext\lib\org.apache.olingo-odata-client-api-4.1.0.jar;

ext\lib\org.apache.olingo-odata-client-core-4.1.0.jar;

ext\lib\org.apache.olingo-odata-client-proxy-4.1.0.jar;

ext\lib\org.apache.olingo-odata-commons-api-4.1.0.jar;

ext\lib\org.apache.olingo-odata-commons-core-4.1.0.jar;

ext\lib\org.codehaus.woodstox-stax2-api-3.1.4.jar;

ext\lib\org.slf4j-slf4j-api-1.7.7.jar;

Job Server Configs

Appreciate everyone's input to resolved this issue.

And I notice that the OData adapter is requesting resource from w3c via port 80, resource URL http://www.w3.org/TR/html4/loose.dtd, IP Address and port 128.30.53.100:80 - does anyone know why and can we source this locally? i.e. copy the resource into DS server and re-pointing the caller into local resource?

Thanks everyone.