OData service for Angles for SAP Cloud

Use the OData service to export an AngleDisplay to external applications like MS Excel and PowerBI. Note that you can only export List and Pivot Displays.

Prerequisites:

• You must have an Odata license in the ISW Platform. For more information on getting an OData license, contact the ISW Platform team or your Angles for SAP consultant.

• You must have the OData service enabled. To check if the Odata service is available, go to ITMC > Global Settings > Components.

• You must have appropriate privileges. For more information on privileges, see User Privileges.

The Odata service is auto-deployed and available for use if license and permissions are in order.

Generate API key for Authentication

To connect to Odata, you must generate an API key. This API key is used to authenticate all configured OData feeds, and incorporates any access limitations for your role. To generate the key, do the following:

1. In the Web Client, select

2. In the Users tab, select Generate API Key under Odata.

   This API key is valid for six months, after which you must repeat this step.

Enable export of an AngleDisplay

To make an AngleDisplay available for external usage via OData, do the following:

1. Execute the relevant Angle.

2. Ensure that the Angle is published. If not, publish the Angle.

3. In the display details, check the option Available externally (OData),

4. Click to copy the link to the AngleDisplay.

Access an AngleDisplay in an external application

1. Open the application where you want to see the Angle data, for example MS excel.

2. Go to Data > Get Data > From other Sources > From OData feed.

3. Select the Basic radio button.

4. In the URL field, enter the link to the AngleDisplay.

5. Click Ok.

6. Select the Basic tab. The Basic authentication screen is displayed.

7. Enter your User Name.

8. Enter the API Key from the Settings section of the Web Client as the Password.

9. In the Select which level to apply these settings to: field, retain the default settings, that is, the lowest level of the URL. With this level, the current authentication will be applicable sitewide.

10. Click Connect.

11. Click Load. The data from the AngleDisplay is loaded.