Microsoft Entra SSO integration with DB Education Portal for Schools

In this article, you'll learn how to integrate DB Education Portal for Schools with Microsoft Entra ID. Providing single sign-on access through Microsoft Entra ID, for the DB Education Portal, available for Schools and Multi Academy Trusts across the United Kingdom. When you integrate DB Education Portal for Schools with Microsoft Entra ID, you can:

  • Control in Microsoft Entra ID who has access to DB Education Portal for Schools.
  • Enable your users to be automatically signed-in to DB Education Portal for Schools with their Microsoft Entra accounts.
  • Manage your accounts in one central location.

You'll configure and test Microsoft Entra single sign-on for DB Education Portal for Schools in a test environment. DB Education Portal for Schools supports SP initiated single sign-on.

Note

Identifier of this application is a fixed string value so only one instance can be configured in one tenant.

Prerequisites

To integrate Microsoft Entra ID with DB Education Portal for Schools, you need:

Add application and assign a test user

Before you begin the process of configuring single sign-on, you need to add the DB Education Portal for Schools application from the Microsoft Entra gallery. You need a test user account to assign to the application and test the single sign-on configuration.

Add DB Education Portal for Schools from the Microsoft Entra application gallery to configure single sign-on with DB Education Portal for Schools. For more information on how to add application from the gallery, see the Quickstart: Add application from the gallery.

Create and assign Microsoft Entra test user

Follow the guidelines in the create and assign a user account article to create a test user account called B.Simon.

Alternatively, you can also use the Enterprise App Configuration Wizard. In this wizard, you can add an application to your tenant, add users/groups to the app, and assign roles. The wizard also provides a link to the single sign-on configuration pane. Learn more about Microsoft 365 wizards..

Configure Microsoft Entra SSO

Complete the following steps to enable Microsoft Entra single sign-on.

  1. Sign in to the Microsoft Entra admin center as at least a Cloud Application Administrator.

  2. Browse to Identity > Applications > Enterprise applications > DB Education Portal for Schools > Single sign-on.

  3. On the Select a single sign-on method page, select SAML.

  4. On the Set up single sign-on with SAML page, select the pencil icon for Basic SAML Configuration to edit the settings.

    Screenshot shows how to edit Basic SAML Configuration.

  5. On the Basic SAML Configuration section, perform the following steps:

    a. In the Identifier textbox, type the value: DBEducation

    b. In the Reply URL textbox, type a URL using one of the following patterns:

    Reply URL
    https://intranet.<CustomerName>.domain.extension/governorintranet/wp-login.php?saml_acs
    https://portal.<CustomerName>.domain.extension/governorintranet/wp-login.php?saml_acs
    https://intranet.<CustomerName>.domain.extension/studentportal/wp-login.php?saml_acs
    https://portal.<CustomerName>.domain.extension/studentportal/wp-login.php?saml_acs
    https://intranet.<CustomerName>.domain.extension/staffportal/wp-login.php?saml_acs
    https://portal.<CustomerName>.domain.extension/staffportal/wp-login.php?saml_acs
    https://intranet.<CustomerName>.domain.extension/parentportal/wp-login.php?saml_acs
    https://portal.<CustomerName>.domain.extension/parentportal/wp-login.php?saml_acs
    https://intranet.<CustomerName>.domain.extension/familyportal/wp-login.php?saml_acs
    https://portal.<CustomerName>.domain.extension/familyportal/wp-login.php?saml_acs

    c. In the Sign on URL textbox, type a URL using one of the following patterns:

    Sign on URL
    https://portal.<CustomerName>.domain.extension
    https://intranet.<CustomerName>.domain.extension

    Note

    These values are not real. Update these values with the actual Reply URL and Sign on URL. Contact DB Education Portal for Schools support team to get these values. You can also refer to the patterns shown in the Basic SAML Configuration section.

  6. DB Education Portal for Schools application expects the SAML assertions in a specific format, which requires you to add custom attribute mappings to your SAML token attributes configuration. The following screenshot shows the list of default attributes.

    Screenshot shows the image of attributes configuration.

  7. In addition to above, DB Education Portal for Schools application expects few more attributes to be passed back in SAML response, which are shown below. These attributes are also pre populated but you can review them as per your requirements.

    Name Source Attribute
    groups user.groups
  8. On the Set up single sign-on with SAML page, in the SAML Signing Certificate section, click copy button to copy App Federation Metadata Url and save it on your computer.

    Screenshot shows the Certificate download link.

Configure DB Education Portal for Schools SSO

To configure single sign-on on DB Education Portal for Schools side, you need to send the App Federation Metadata Url to DB Education Portal for Schools support team. They set this setting to have the SAML SSO connection set properly on both sides.

Create DB Education Portal for Schools test user

In this section, you create a user called Britta Simon at DB Education Portal for Schools SSO. Work with DB Education Portal for Schools SSO support team to add the users in the DB Education Portal for Schools SSO platform. Users must be created and activated before you use single sign-on.

Test SSO

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

  • Click on Test this application, this will redirect to DB Education Portal for Schools Sign-on URL where you can initiate the login flow.

  • Go to DB Education Portal for Schools Sign-on URL directly and initiate the login flow from there.

  • You can use Microsoft My Apps. When you click the DB Education Portal for Schools tile in the My Apps, this will redirect to DB Education Portal for Schools Sign-on URL. For more information, see Microsoft Entra My Apps.

Additional resources

Next steps

Once you configure DB Education Portal for Schools 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.