SAP OData

Description

SAP data structures can be exposed through OData endpoints using ABAP CDS Views and accessed via SAP ODATA access.

This capability is provided by the “SAP OData” plugin, which you need to install. Please see Installing plugins.

The dataset is read-only.

How to set up

The main prerequisite to use this plugin is to know the credentials to connect to the SAP system (Username, Password, Client). SAP OData support depends on the SAP Netweaver Gateway. Check your SAP Version if your actual SAP Netweaver Gateway (e.g. NW 7.0) supports SAP OData.

  1. In Dataiku, go to App > Plugins > Installed > SAP OData > Settings > SAP/OData login.

  2. Add a preset, name it and fill in the details.

  3. The Resource box can contain the full URL of the service node to access, or the OData service’s URL with the service node left out. It this case, the end user of the plugin will be able to chose which service node to access. In an OData URL, the service node is the last segment of the URL path. For instance, if the resource is https://sapesX.sapdevcenter.com/sap/opu/odata/sap/SVC_NDE, the service node is SVC_NDE. The service node is also the name of the CDS View as defined and exposed using ABAP CDS Views within SAP.

  4. For the user’s comfort of use, a list of descriptions of available service nodes can be added to the preset. To do so, first make sure no service node is present in the resource’s URL. Then simply add the service node code and its actual description in the Service name section of the preset.

How to use

  1. Go to your Dataiku Flow.

  2. Select SAP OData in the plugin section of the +Dataset. menu and click on SAP OData in the combo box.

  3. Pick the access type and the preset you previously configured.

  4. If necessary, fill in the Service node box (see point 3 of the paragraph above).

  5. If the Entity box is left blank, the plugin will retrieve a list of entities accessible on this service node.