Duo Single Sign-On for SAP HANA, express edition

Overview

As business applications move from on-premises to cloud hosted solutions, users experience password fatigue due to disparate logons for different applications. Single sign-on (SSO) technologies seek to unify identities across systems and reduce the number of different credentials a user has to remember or input to gain access to resources.

While SSO is convenient for users, it presents new security challenges. If a user's primary password is compromised, attackers may be able to gain access to multiple resources. In addition, as sensitive information makes its way to cloud-hosted services it is even more important to secure access by implementing two-factor authentication and zero-trust policies.

About Duo Single Sign-On

Duo Single Sign-On is our cloud-hosted SSO product which layers Duo's strong authentication and flexible policy engine on top of SAP HANA, express edition logins. Duo Single Sign-On acts as an identity provider (IdP), authenticating your users using existing on-premises Active Directory (AD) or another SSO IdP. Duo SSO prompts users for two-factor authentication and performs endpoint assessment and verification before permitting access to SAP HANA, express edition.

Duo Single Sign-On is available in Duo Premier, Duo Advantage, and Duo Essentials plans, which also include the ability to define policies that enforce unique controls for each individual SSO application. For example, you can require that Salesforce users complete two-factor authentication at every login, but only once every seven days when accessing SAP HANA, express edition. Duo checks the user, device, and network against an application's policy before allowing access to the application.

Configure Single Sign-On

Before configuring SAP HANA, express edition with Duo SSO using Security Assertion Markup Language (SAML) 2.0 authentication you'll first need to enable Duo Single Sign-On for your Duo account and configure a working authentication source.

Once you have your SSO authentication source working, continue to the next step of creating the SAP HANA, express edition application in Duo.

Create the SAP HANA, express edition Application in Duo

1. Log on to the Duo Admin Panel and navigate to Applications → Protect an Application.

2. Locate the entry for SAP HANA, express edition with a protection type of "2FA with SSO hosted by Duo (Single Sign-On)" in the applications list. Click Protect to the far-right to start configuring SAP HANA, express edition. See Protecting Applications for more information about protecting applications with Duo and additional application options. You'll need the information on the SAP HANA, express edition page under Downloads later.

3. SAP HANA, express edition uses the Mail attribute when authenticating. We've mapped the <Email Address> bridge attribute to Duo Single Sign-On supported authentication source attributes as follows:

   Bridge Attribute	Active Directory	SAML IdP
   <Email Address>	mail	Email

   If you are using a non-standard email attribute for your authentication source, check the Custom attributes box and enter the name of the attribute you wish to use instead.

4. You can adjust additional settings for your new SAML application at this time — like changing the application's name from the default value, enabling self-service, or assigning a group policy.

5. Keep the Duo Admin Panel tab open. You will come back to it later.

Duo Universal Prompt

The Duo Universal Prompt provides a simplified and accessible Duo login experience for web-based applications, offering a redesigned visual interface with security and usability enhancements.

Universal Prompt	Traditional Prompt

The Duo SAP HANA, express edition application supports the Universal Prompt by default, so there's no additional action required on your part to start using the newest authentication experience.

Activate Universal Prompt

Activation of the Universal Prompt is a per-application change. Activating it for one application does not change the login experience for your other Duo applications. Universal Prompt is already activated for new SAP HANA, express edition applications at creation.

The "Universal Prompt" area of the application details page shows that this application's status is "Activation complete", with these activation control options:

• Show traditional prompt: Your users experience Duo's traditional prompt via redirect when logging in to this application.
• Show new Universal Prompt: (Default) Your users experience the Universal Prompt via redirect when logging in to this application.

The application's Universal Prompt status shows "Activation complete" both here and on the Universal Prompt Update Progress report.

For the time being, you may change this setting to Show traditional prompt to use the legacy experience. Keep in mind that support for the traditional Duo prompt ended for the majority of applications in March 2024. This option will be removed in the future.

Universal Update Progress

Click the See Update Progress link to view the Universal Prompt Update Progress report. This report shows the update availability and migration progress for all your Duo applications. You can also activate the new prompt experience for multiple supported applications from the report page instead of visiting the individual details pages for each application.

Enable SAP HANA, express edition for SSO

To enable SAP HANA, express edition for SSO, do the sections below in the order they appear.

1. Log into your SAP HANA XS Advanced Cockpit application.

2. In the web address bar, make note of your domain and port number. You will need them later.

   Example: If web address bar URL is https://yourdomain:8181/cockpit#/xsa, then your domain and port number are https://yourdomain:8888.

3. In the left menu sidebar, navigate to Security → IdP Trust Configuration. The "XSA System: Home - IdP Trust Configuration" page opens.

4. Click New Trust Configuration. The "New Trust Configuration" pop-up window opens.

5. Return to the Duo Admin Panel. Under "Downloads", click Download XML.

6. Return to the SAP HANA, express edition "New Trust Configuration" pop-up window. Next to the Metadata field, click Upload and open the XML file you downloaded from Duo earlier.

7. In the "New Trust Configuration" pop-up window, enter a unique name for your identity provider into the Name field.

8. Enter a unique name for your origin key into the Origin Key field. This name describes the type of trust configuration.

9. Make sure the Status drop-down menu is set to Active.

10. Make sure the Show SAML login link on login page and Create shadow users during login checkboxes are both checked.

11. Enter a unique name for your SSO login link into the Link Text field. This link will appear on the SAP HANA, express edition login page.

12. At the bottom of the "New Trust Configuration" pop-up window, click Parse, and then click Save.

13. Open a new web page. In the web address bar, type the domain and port number you noted earlier. At the end of your domain and port number, type /uaa-security/saml/metadata and press Enter. The SAP HANA, express edition metadata file downloads automatically.

    Example: https://yourdomain:8888/uaa-security/saml/metadata

14. Return to the Duo Admin Panel. Under "Service Provider", click Choose File and open the metadata file you downloaded from SAP HANA, express edition earlier.

Group Mapping

Mapping Duo groups to different roles in SAP HANA, express edition is required. To map Duo groups, do the following:

1. In the SAP HANA, express edition left menu sidebar, navigate to Security → Role Collections. The "XSA System: Home - Role Collections" page opens.

2. Click New Role Collection. The "New Role Collection" pop-up window opens.

3. Enter a unique name for your role collection into the Name field and then click Save.

4. In the "Name" column, click your role collection. The "Role Collection - Example Role - Roles" page opens.

5. Click Add Role. The "Add Role" pop-up window opens.

6. Click the Application Identifier drop-down menu and select your desired application identifier.

7. Click the Role Template drop-down menu and select your desired role template.

8. Click the Role drop-down menu and select your desired role, and then click Save.

9. In the left menu sidebar, navigate to Security → Role Collections. In the "Name" column, copy your role collection name and paste it into the Duo Admin Panel SAP HANA, express edition role name field, under "Service Provider".

10. In the Duo Admin Panel, click the Duo groups drop-down menu and select the applicable Duo group.

    

11. Scroll down to the bottom of the page and click Save.

Assign Role Collections

1. Return to SAP HANA, express edition. In the left menu sidebar, click User Management. The "XSA System: Home - User Management" page opens.

2. In the "Actions" column on your user row, click the Assign Role Collections icon. The "Assign Role Collections" pop-up window opens.

3. Click Add. The "Role Collections" pop-up window opens.

4. Click the checkbox next to your desired role collection, and then click Select.

5. At the bottom of the "Assign Role Collections" pop-up window, click Save.

Learn more about SAP HANA, express edition SSO at the SAP Help Portal.

Using SSO

You can log on to SAP HANA, express edition by navigating to your SAP HANA, express edition SSO page, which is the domain and port number you noted earlier e.g., https://yourdomain:8888/uaa-security/login. Click your trust configuration to be redirected to Duo Single Sign-On to begin authentication.

Active Directory Login

With Active Directory as the Duo SSO authentication source, enter the primary username (email address) on the Duo SSO login page and click or tap Next.

Enter the AD primary password and click or tap Log in to continue.

Enable Duo Passwordless to log in to Duo SSO backed by Active Directory authentication without entering a password in the future.

SAML Login

With another SAML identity provider as the Duo SSO authentication source, Duo SSO immediately redirects the login attempt to that SAML IdP for primary authentication. Users do not see the Duo SSO primary login screen.

Duo Authentication

Successful verification of your primary credentials by Active Directory or a SAML IdP redirects back to Duo. Complete Duo two-factor authentication when prompted and then you'll return to SAP HANA, express edition to complete the login process.

* Universal Prompt experience shown.

You can also log into SAP HANA, express edition using Duo Central, our cloud-hosted portal which allows users to access all of their applications in one spot. Link to SAP HANA, express edition in Duo Central by adding it as an application tile. Once the tile has been added, log into Duo Central and click the tile for IdP-initiated authentication to SAP HANA, express edition.

Congratulations! Your SAP HANA, express edition users now authenticate using Duo Single Sign-On.

See the full user login experience, including expired password reset (available for Active Directory authentication sources) in the Duo End User Guide for SSO.

Enable Remembered Devices

To minimize additional Duo two-factor prompts when switching between SAP HANA, express edition and your other Duo Single Sign-On SAML applications, be sure to apply a shared "Remembered Devices" policy to your SAML applications.

Troubleshooting

Need some help? Try searching our Knowledge Base articles or Community discussions. For further assistance, contact Support.