Skip to Content
1
Apr 28, 2020 at 08:53 AM

Live Data Connection to SAP S/4HANA Cloud Edition via OAuth

174 Views Last edit Apr 28, 2020 at 10:07 AM 3 rev

We want to integrate our S/4 cloud environment with SAP Analytics cloud, so we can use S/4 data in SAC. It seems that live connection with OAuth is the best way to archive this. We have followed the guide on SAC help portal, but are not able to authenticate the user from SAC(see picture below) .

I have create a list that describe the steps we have done bellow and Appreciate any comment on the steps I have done, "missing" steps or prerequisites that are missing.

I will update the steps when we have a working solution. All URL and values are fake, but the format is correct.

Prerequsit

1: S/4 cloud hostname : my347623.s4hana.ondemand.com
2: S/4 cloud roles : ID SAP_BR_ADMINISTRATOR
3: SAC role : BI Admin
4: Know if you run SAC in SAP data centers or on non-SAP data centers. us1 or jp1, indicates an SAP data center,eu10 or us30, indicates a non-SAP data center
5: Default language in S/4
6: SAP Analytics cloud URL : https://myconsultingas.eu1.sapanalytics.cloud/sap/fpa/ui/tenants/042/

Part 1 - Gathering needed information from SAP Analytics cloud (SAC)
Steps
1 - Log into SAC
2 - Open: System -> Administration -> App Integration
3 - Get: Autorization URL : https://oauthasservices-aghytr55e.hana.ondemand.com/oauth2/api/v1/authorize
4 - Get: Token URL: https://oauthasservices-a4326881e.hana.ondemand.com/oauth2/api/v1/token
5 - Open: connection ->Add connection -> SAP S/4HANA
6 - Get : Provider Name: myconsultingas.eu1.sapanalytics.cloud
7 - Click Download Signing Certificate

Part 2 - Create a communication system in SAP S/4HANA
Steps

  1. Log into S/4
  2. Open Communication systems
  3. Click New
  4. Enter system ID : MY_SAC
  5. Click Create
  6. In the field Host Name, enter : SAP Analytics cloud URL
  7. In the field Auth. Endpoint : enter Autorization URL : https://oauthasservices-aghytr55e.hana.ondemand.com/oauth2/api/v1/authorize
  8. In the field Token Endpoint : enter Token URL: https://oauthasservices-a4326881e.hana.ondemand.com/oauth2/api/v1/token
  9. Set OAuth 2.0 Identity Provider to On
  10. In the field providername enter : myconsultingas.eu1.sapanalytics.cloud
  11. Upload the certificate you created in Part1, step 7
  12. under Users for Inbound Communication, click add
  13. Click New User
  14. Enter username,description and password.
  15. click Create and ok
  16. Click save

Part 3 - Create Communication Arragements in SAP S/4HANA Steps

  1. Open Communication Arrangements
  2. Click new
  3. in the field Scenario, enter SAP_COM_0065
  4. Click Create
  5. In the field communication Systems, enter MY_SAC
  6. In the field Tenant ID enter 042
  7. In the field User name, enter username with OAuth 2.0
  8. Uncheck UI LINK Navigator service status
  9. Uncheck Retrive Stories service status
  10. Click Save

Part 4- Create Live connection

  1. Log into SAC
  2. Open: connection ->Add connection -> SAP S/4HANA
  3. In the field Name, enter S4
  4. in the field Description, enter S4 test
  5. In the field host, enter my347623.s4hana.ondemand.com
  6. In the field token user, enter user created in part 2 step 12
  7. Enter password for the user
  8. In the filed OAuth Scope, enter SAP_BW_INA_BATCHPROCESSING_HTTP SAP_BW_INA_GETCATALOG_HTTP SAP_BW_INA_GETRESPONSE_HTTP SAP_BW_INA_GETSERVERINFO_HTTP SAP_BW_INA_LOGOFF_HTTP SAP_BW_INA_VALUEHELP_HTTP

Attachments

image.png (605.6 kB)