Microsoft Azure Active Directory

Owned by DATABASICS, Inc.
Last updated: Mar 15, 2022
4 min read

In this tutorial, you learn how to integrate DATABASICS with Azure Active Directory (Azure AD). Integrating DATABASICS with Azure AD provides you with the following benefits:

  • You can control in Azure AD who has access to DATABASICS.

  • You can enable your users to be automatically signed-in to DATABASICS (Single Sign-On) with their Azure AD accounts.

  • You can manage your accounts in one central location - the Azure portal.

If you want to know more details about SaaS app integration with Azure AD, see What is application access and single sign-on with Azure Active Directory. If you don't have an Azure subscription, create a free account before you begin.

Prerequisites

To configure Azure AD integration with DATABASICS, you need the following items:

  • An Azure AD subscription. If you don't have an Azure AD environment, you can get one-month trial here

  • DATABASICS single sign-on enabled subscription

Scenario description

In this tutorial, you configure and test Azure AD single sign-on in a test environment.

  • DATABASICS supports SP initiated SSO

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

To add DATABASICS from the gallery, perform the following steps:

  1. In the Azure portal, on the left navigation panel, click Azure Active Directory icon.

  2. Navigate to Enterprise Applications and then select the All Applications option.

  3. To add new application, click New application button on the top of dialog.

  4. In the search box, type DATABASICS, select DATABASICS from result panel then click Add button to add the application.

Configure and test Azure AD single sign-on

In this section, you configure and test Azure AD single sign-on with DATABASICS based on a test user called Britta Simon. For single sign-on to work, a link relationship between an Azure AD user and the related user in DATABASICS needs to be established.

To configure and test Azure AD single sign-on with DATABASICS, you need to complete the following building blocks:

  1. Configure Azure AD Single Sign-On

     - to enable your users to use this feature.

  2. Configure DATABASICS Single Sign-On

     - to configure the Single Sign-On settings on application side.

  3. Create an Azure AD test user

     - to test Azure AD single sign-on with Britta Simon.

  4. Assign the Azure AD test user

     - to enable Britta Simon to use Azure AD single sign-on.

  5. Create DATABASICS test user

     - to have a counterpart of Britta Simon in DATABASICS that is linked to the Azure AD representation of user.

  6. Test single sign-on

     - to verify whether the configuration works.

Configure Azure AD single sign-on

In this section, you enable Azure AD single sign-on in the Azure portal.

To configure Azure AD single sign-on with DATABASICS, perform the following steps:

  1. In the Azure portal, on the DATABASICS application integration page, select Single sign-on.

  2. On the Select a Single sign-on method dialog, select SAML/WS-Fed mode to enable single sign-on.

  3. On the Set up Single Sign-On with SAML page, click Edit icon to open Basic SAML Configuration dialog.

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

    a. In the Sign on URL text box, type a URL using the following pattern: https://<sitenumber>.data-basics.net/<clientname>/saml_sso.jsp

    b. In the Identifier (Entity ID) text box, type a value: DATA-BASICS_SP

     Note

    The Sign on URL value is not real. Update the value with the actual Sign on URL. Contact DATABASICS Client support team to get these values. You can also refer to the patterns shown in the Basic SAML Configuration section in the Azure portal.

  5. On the Set up Single Sign-On with SAML page, in the SAML Signing Certificate section, click Download to download the Federation Metadata XML from the given options as per your requirement and save it on your computer.

  6. On the Set up DATABASICS section, copy the appropriate URL(s) as per your requirement.

    a. Login URL

    b. Azure Ad Identifier

    c. Logout URL

Configure DATABASICS Single Sign-On

To configure single sign-on on DATABASICS side, you need to send the downloaded Federation Metadata XML and appropriate copied URLs from Azure portal to DATABASICS support team. They set this setting to have the SAML SSO connection set properly on both sides.

Create an Azure AD test user

The objective of this section is to create a test user in the Azure portal called Britta Simon.

  1. In the Azure portal, in the left pane, 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, perform the following steps.

    a. In the Name field enter BrittaSimon.

    b. In the User name field type brittasimon@yourcompanydomain.extension
    For example, BrittaSimon@contoso.com

    c. Select Show password check box, and then write down the value that's displayed in the Password box.

    d. Click Create.

Assign the Azure AD test user

In this section, you enable Britta Simon to use Azure single sign-on by granting access to DATABASICS.

  1. In the Azure portal, select Enterprise Applications, select All applications, then select DATABASICS.

  2. In the applications list, select DATABASICS.

  3. In the menu on the left, select Users and groups.

  4. Click the Add user button, then select Users and groups in the Add Assignment dialog.

  5. In the Users and groups dialog select Britta Simon in the Users list, then click the Select button at the bottom of the screen.

  6. If you are expecting any role value in the SAML assertion then in the Select Role dialog select the appropriate role for the user from the list, then click the Select button at the bottom of the screen.

  7. In the Add Assignment dialog click the Assign button.

Create DATABASICS test user

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

To complete prior starting the configuration:

DATABASICS Submit SSO Onboarding Request

Test single sign-on

In this section, you test your Azure AD single sign-on configuration using the Access Panel.

When you click the DATABASICS tile in the Access Panel, you should be automatically signed in to the DATABASICS for which you set up SSO. For more information about the Access Panel, see Introduction to the Access Panel.

2021 DATABASICS, Inc