Tutorial: Azure Active Directory single sign-on (SSO) integration with Airtable

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

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

To learn more about SaaS app integration with Azure AD, see What is application access and single sign-on with Azure Active Directory.

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.
  • Airtable single sign-on (SSO) enabled subscription.

Scenario description

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

  • Airtable supports SP and IDP initiated SSO
  • Airtable supports Just In Time user provisioning

Note

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

To configure the integration of Airtable into Azure AD, you need to add Airtable 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 Airtable in the search box.
  6. Select Airtable 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 single sign-on for Airtable

Configure and test Azure AD SSO with Airtable 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 Airtable.

To configure and test Azure AD SSO with Airtable, complete the following building blocks:

  1. Configure Azure AD SSO - to enable your users to use this feature.
  2. Configure Airtable SSO - to configure the single sign-on settings on application side.
    • Create Airtable test user - to have a counterpart of B.Simon in Airtable 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 Airtable 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 edit/pen icon for Basic SAML Configuration to edit the settings.

    Edit Basic SAML Configuration

  4. On the Basic SAML Configuration section, the user does not have to perform any step as the app is already pre-integrated with Azure.

    Airtable Domain and URLs single sign-on information

  5. Click Set additional URLs and perform the following step if you wish to configure the application in SP initiated mode:

    In the Sign-on URL text box, type a URL: https://airtable.com/sso/login

  6. Click Save.

  7. On the Set up single sign-on with SAML page, in the SAML Signing Certificate section, find Certificate (Base64) and select Download to download the certificate and save it on your computer.

    The Certificate download link

  8. On the Set up Airtable 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 Airtable.

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

  2. In the applications list, select Airtable.

  3. In the app's overview page, find the Manage section and select Users and groups.

    The "Users and groups" link

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

    The Add User link

  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're expecting any role value in the SAML assertion, in the Select Role dialog, select the appropriate role for the user from the list and then click the Select button at the bottom of the screen.

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

Configure Airtable SSO

Follow the instructions given in the link to configure single sign-on on Airtable side.

Create Airtable test user

In this section, a user called B.Simon is created in Airtable. Airtable supports just-in-time user provisioning, which is enabled by default. There is no action item for you in this section. If a user doesn't already exist in Airtable, a new one is created after authentication.

Test SSO

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

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

Additional resources