SAP Analytics Cloud


SAP Analytics Cloud


This page outlines the steps to connect SAP Analytics Cloud to your CData Connect Cloud OData endpoint.

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.
  • Configure your OData tables and columns from your data sources. Later, you will use the OData Service URL on that page (https://cloud.cdata.com/api/odata/service) 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 your CData Connect Cloud OData API, 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 modal, 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/service
    • 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 modal, 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.