Search

SAP Analytics Cloud

SAP Analytics Cloud

This page outlines the steps to connect SAP Analytics Cloud to CData Connect Cloud using the OData protocol. This requires the use of virtual datasets. See the Virtual Datasets documentation for more information.

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect Cloud account. See Connections for more information.
  • Create a virtual dataset Workspace. Later, you will use the OData Service URL on that page (https://cloud.cdata.com/api/odata/{workspace_name}) with the relevant workspace name to establish the connection.
  • Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connecting to CData Connect Cloud

To establish a connection from SAP Analytics Cloud to CData Connect Cloud using the OData protocol, follow these steps.

  1. From the SAP Analytics Cloud dashboard, open the navigation menu and click Connections.

  2. On the Connection page, click Add Connection.

  3. In the Select a data source dialog, type odata into the search bar and select OData Services. You can also find it listed under the Acquire Data category without searching.

  4. Configure the connection:
    • Enter a Connection Name and, optionally, a Description.
    • Data Service URL—enter https://cloud.cdata.com/api/odata/{workspace_name}
    • Authentication Type—select Basic Authentication.
    • User Name—enter your CData Connect Cloud username. This is displayed in the top-right corner of the CData Connect Cloud interface. For example, test@cdata.com.
    • Password—enter the PAT you generated on the Settings page.

  5. Click Create to save the connection.

Querying Your OData API

After establishing the connection to your CData Connect Cloud OData API, you can access it as a data source in SAP Analytics Cloud. Follow these steps to access it:

  1. In SAP Analytics Cloud, open the navigation menu and click Datasets or Modeler.

  2. In the Create New section, click From a Data Source.

  3. In the Select a data source dialog, select OData Services.

  4. In the Connection drop-down menu, select the connection you created. If you are using the Modeler tab, select the Create a new query radio button.

  5. Click Next and build your query according to your needs.

For information about refreshing the data from your OData API, please see this SAP Analytics Cloud help article.