en
Get Started

SAP OData

This plugin provides the capability to read from SAP using the OData protocol.

Plugin information

Version 1.0.1
Author Dataiku (Alex Bourret)
Released 2020-11-13
Last updated 2020-11-13
License Apache Software License
Source code Github
Reporting issues Github

Description

The purpose of this Dataiku Plugin is to allow DSS users to read from SAP using the OData protocol. SAP offers the possibility to expose SAP data structures using ABAP CDS Views. CDS Views can be made public and therefore consumed from external systems using the SAP ODATA access. The Plugin serves as a new Dataset for reading data from SAP. It is a read only dataset.

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 DSS, go to App > Plugins > Installed > SAP OData > Settings > SAP/OData login
  2. Add a preset, name it and fill in the details.

    Fill in the preset
  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.

How to use

  1. Go to your DSS 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.

Get the Dataiku Data Sheet

Learn everything you ever wanted to know about Dataiku (but were afraid to ask), including detailed specifications on features and integrations.

Get the data sheet