Create a Connection

In this short exercise, we will create a connection from SAP Analytics Cloud to connect to the Analytical Dataset we created in our first exercise.

1. Click here to open the SAP Analytics Cloud URL and then in the main navigation panel, click on Connections.
   

Note: SAP Datasphere offers a public OData API (details https://api.sap.com/api/ODataAPI/overview) to support the replication of models to SAP Analytics Cloud.

Let us now add a connection and select the OData connection type.

2. Click on the + icon and select OData Services.

   

3. Depending on the geographic location of your SAP Analytics Cloud URL; EU10/US10/AP11, enter the relevant settings to define your OData Service Connection in SAP Analytics Cloud.

EU10

If your SAP Analytics Cloud URL includes EU10 (e.g. https://academy-t-sac.eu10.hcs.cloud.sap/) enter these details:

Connection Name: DATASPHERE_SAC_PLANNING_

Data Service URL (Data Source): https://academydatasphere.eu10.hcs.cloud.sap/api/v1/dwc/consumption/analytical/<your_user_space_id>/Analytic_Model_

Authentication Type: OAuth 2.0 Authorization Code

OAuth Client ID: sb-c2a0459f-f019-4d61-89ba-0811e35f25ba!b193354|client!b3650

Secret: e6f59abf-1baf-4d18-a745-ff868d9d66c7$apQOloMqBdry4e_auxMx3k3Gy0OTKOm9S8XmVS8BcoE=

Token URL: https://academydatasphere.authentication.eu10.hana.ondemand.com/oauth/token Authorization URL: https://academydatasphere.authentication.eu10.hana.ondemand.com/oauth/authorize

US10

If your SAP Analytics Cloud URL includes US10 (e.g. https://academy-t-sac.us10.hcs.cloud.sap/) enter these details:

Connection Name: DATASPHERE_SAC_PLANNING_

Data Service URL (Data Source): https://academydatasphere-2.us10.hcs.cloud.sap/api/v1/dwc/consumption/analytical/<your_user_space_id>/Analytic_Model_

Authentication Type: OAuth 2.0 Authorization Code

OAuth Client ID: sb-5ca19516-cd2c-4277-b8dc-504f83cee5fe!b142524|client!b655

Secret: 98eeb3db-8ddd-470e-b8d3-28f27620f0ad$HAxP05A5AJqZK42cg-nLDi4Nk0NERrDzO4Re-4rXD5Y=

Token URL: https://academydatasphere-2.authentication.us10.hana.ondemand.com/oauth/token Authorization URL: https://academydatasphere-2.authentication.us10.hana.ondemand.com/oauth/authorize

AP11

If your SAP Analytics Cloud URL includes AP11 (e.g. https://academy-t-sac.ap11.hcs.cloud.sap/) enter these details:

Connection Name: DATASPHERE_SAC_PLANNING_

Data Service URL (Data Source): https://academydatasphere-1.ap11.hcs.cloud.sap/api/v1/dwc/consumption/analytical/<your_user_space_id>/Analytic_Model_

Authentication Type: OAuth 2.0 Authorization Code

OAuth Client ID: sb-e6c77e1b-094d-4963-8501-f60923e14be0!b2498|client!b23

Secret: a5bb74cd-4b3e-42bb-8c27-b2c06181409a$xILkwMB4kJy35_gHsJhu4RE80FGY6qD9JTx-g9jUwFw=

Token URL: https://academydatasphere-1.authentication.ap11.hana.ondemand.com/oauth/token Authorization URL: https://academydatasphere-1.authentication.ap11.hana.ondemand.com/oauth/authorize

4. Finally, click the Create button and you should receive a green confirmation popup at the bottom of the screen.
   

Summary

You have now successfully created your connection and can move on to the next lesson.