Tutorial: Integrate SAP Analytics Cloud with Azure Active Directory

In this tutorial, you'll learn how to integrate SAP Analytics Cloud with Azure Active Directory (Azure AD). When you integrate SAP Analytics Cloud with Azure AD, you can:

  • Control in Azure AD who has access to SAP Analytics Cloud.
  • Enable your users to be automatically signed-in to SAP Analytics Cloud with their Azure AD accounts.
  • Manage your accounts in one central location - the Azure portal.

Prerequisites

To get started, you need the following items:

  • An Azure AD subscription. If you don't have a subscription, you can get a free account.
  • SAP Analytics Cloud single sign-on (SSO) enabled subscription.

Scenario description

In this tutorial, you configure and test Azure AD SSO in a test environment.

To configure the integration of SAP Analytics Cloud into Azure AD, you need to add SAP Analytics Cloud from the gallery to your list of managed SaaS apps.

  1. Sign in to the Azure portal using either a work or school account, or a personal Microsoft account.
  2. On the left navigation pane, select the Azure Active Directory service.
  3. Navigate to Enterprise Applications and then select All Applications.
  4. To add new application, select New application.
  5. In the Add from the gallery section, type SAP Analytics Cloud in the search box.
  6. Select SAP Analytics Cloud from results panel and then add the app. Wait a few seconds while the app is added to your tenant.

Configure and test Azure AD SSO for SAP Analytics Cloud

Configure and test Azure AD SSO with SAP Analytics Cloud using a test user called B.Simon. For SSO to work, you need to establish a link relationship between an Azure AD user and the related user in SAP Analytics Cloud.

To configure and test Azure AD SSO with SAP Analytics Cloud, perform the following steps:

  1. Configure Azure AD SSO - to enable your users to use this feature.
    1. Create an Azure AD test user - to test Azure AD single sign-on with B.Simon.
    2. Assign the Azure AD test user - to enable B.Simon to use Azure AD single sign-on.
  2. Configure SAP Analytics Cloud SSO - to configure the single sign-on settings on application side.
    1. Create SAP Analytics Cloud test user - to have a counterpart of B.Simon in SAP Analytics Cloud that is linked to the Azure AD representation of user.
  3. Test SSO - to verify whether the configuration works.

Configure Azure AD SSO

Follow these steps to enable Azure AD SSO in the Azure portal.

  1. In the Azure portal, on the SAP Analytics Cloud application integration page, find the Manage section and select Single sign-on.

  2. On the Select a Single sign-on method page, select SAML.

  3. On the Set up Single Sign-On with SAML page, click the pencil icon for Basic SAML Configuration to edit the settings.

    Edit Basic SAML Configuration

  4. On the Basic SAML Configuration section, enter the values for the following fields:

    a. In the Identifier (Entity ID) text box, type a value using one of the following patterns:

    Identifier URL
    <sub-domain>.sapbusinessobjects.cloud
    <sub-domain>.sapanalytics.cloud

    b. In the Sign on URL text box, type a URL using one of the following patterns:

    Sign on URL
    https://<sub-domain>.sapanalytics.cloud/
    https://<sub-domain>.sapbusinessobjects.cloud/

    Note

    The values in these URLs are for demonstration only. Update the values with the actual Identifier and Sign on URL. To get the sign-on URL, contact the SAP Analytics Cloud Client support team. You can get the identifier URL by downloading the SAP Analytics Cloud metadata from the admin console. This is explained later in the tutorial.

  5. On the Set up Single Sign-On with SAML page, in the SAML Signing Certificate section, find Federation Metadata XML and select Download to download the certificate and save it on your computer.

    The Certificate download link

  6. On the Set up SAP Analytics Cloud section, copy the appropriate URL(s) based on your requirement.

    Copy configuration URLs

Create an Azure AD test user

In this section, you'll create a test user in the Azure portal called B.Simon.

  1. From the left pane in the Azure portal, select Azure Active Directory, select Users, and then select All users.
  2. Select New user at the top of the screen.
  3. In the User properties, follow these steps:
    1. In the Name field, enter B.Simon.
    2. In the User name field, enter the username@companydomain.extension. For example, B.Simon@contoso.com.
    3. Select the Show password check box, and then write down the value that's displayed in the Password box.
    4. Click Create.

Assign the Azure AD test user

In this section, you'll enable B.Simon to use Azure single sign-on by granting access to SAP Analytics Cloud.

  1. In the Azure portal, select Enterprise Applications, and then select All applications.
  2. In the applications list, select SAP Analytics Cloud.
  3. In the app's overview page, find the Manage section and select Users and groups.
  4. Select Add user, then select Users and groups in the Add Assignment dialog.
  5. In the Users and groups dialog, select B.Simon from the Users list, then click the Select button at the bottom of the screen.
  6. If you are expecting a role to be assigned to the users, you can select it from the Select a role dropdown. If no role has been set up for this app, you see "Default Access" role selected.
  7. In the Add Assignment dialog, click the Assign button.

Configure SAP Analytics Cloud SSO

  1. In a different web browser window, sign in to your SAP Analytics Cloud company site as an administrator.

  2. Select Menu > System > Administration.

    Select Menu, then System, and then Administration

  3. On the Security tab, select the Edit (pen) icon.

    On the Security tab, select the Edit icon

  4. For Authentication Method, select SAML Single Sign-On (SSO).

    Select SAML Single Sign-On for the authentication method

  5. To download the service provider metadata (Step 1), select Download. In the metadata file, find and copy the entityID value. In the Azure portal, on the Basic SAML Configuration dialog, paste the value in the Identifier box.

    Copy and paste the entityID value

  6. To upload the service provider metadata (Step 2) in the file that you downloaded from the Azure portal, under Upload Identity Provider metadata, select Upload.

    Under Upload Identity Provider metadata, select Upload

  7. In the User Attribute list, select the user attribute (Step 3) that you want to use for your implementation. This user attribute maps to the identity provider. To enter a custom attribute on the user's page, use the Custom SAML Mapping option. Or, you can select either Email or USER ID as the user attribute. In our example, we selected Email because we mapped the user identifier claim with the userprincipalname attribute in the User Attributes & Claims section in the Azure portal. This provides a unique user email, which is sent to the SAP Analytics Cloud application in every successful SAML response.

    Select User Attribute

  8. To verify the account with the identity provider (Step 4), in the Login Credential (Email) box, enter the user's email address. Then, select Verify Account. The system adds sign-in credentials to the user account.

    Enter email, and select Verify Account

  9. Select the Save icon.

    Save icon

Create SAP Analytics Cloud test user

Azure AD users must be provisioned in SAP Analytics Cloud before they can sign in to SAP Analytics Cloud. In SAP Analytics Cloud, provisioning is a manual task.

To provision a user account:

  1. Sign in to your SAP Analytics Cloud company site as an administrator.

  2. Select Menu > Security > Users.

    Add Employee

  3. On the Users page, to add new user details, select +.

    Add Users page

    Then, complete the following steps:

    1. In the USER ID box, enter the user ID of the user, like B.

    2. In the FIRST NAME box, enter the first name of the user, like B.

    3. In the LAST NAME box, enter the last name of the user, like Simon.

    4. In the DISPLAY NAME box, enter the full name of the user, like B.Simon.

    5. In the E-MAIL box, enter the email address of the user, like b.simon@contoso.com.

    6. On the Select Roles page, select the appropriate role for the user, and then select OK.

      Select role

    7. Select the Save icon.

Note

SAP Analytics Cloud also supports automatic user provisioning, you can find more details here on how to configure automatic user provisioning.

Test SSO

In this section, you test your Azure AD single sign-on configuration with following options.

  • Click on Test this application in Azure portal. This will redirect to SAP Analytics Cloud Sign-on URL where you can initiate the login flow.

  • Go to SAP Analytics Cloud Sign-on URL directly and initiate the login flow from there.

  • You can use Microsoft My Apps. When you click the SAP Analytics Cloud tile in the My Apps, this will redirect to SAP Analytics Cloud Sign-on URL. For more information about the My Apps, see Introduction to the My Apps.

Next steps

Once you configure SAP Analytics Cloud you can enforce session control, which protects exfiltration and infiltration of your organization’s sensitive data in real time. Session control extends from Conditional Access. Learn how to enforce session control with Microsoft Cloud App Security.