your database front-end

Azure Single-Sign-on Setup

The following describes how to set up Single-Sign-on in dbFront using Azure (Azure.com).

Note: Microsoft offers a Free Azure Active Directory account which can be somewhat helpful for testing Single-Sign-on.  For pricing and limits see: Azure Active Directory Pricing.  The two most significant limits of the free version are:

  1. No support for groups (can't test groups including admin access),
  2. No Public Certificate (therefore not secure).

Information Collection

When setting up Azure Single-Sign-on you need to collect or decide on the following pieces of information:

  1. Determine a display name for your application. e.g. "dbFront - Records Maintenance",
  2. Determine the root URL for your dbFront install.  This would be something like:
    • https://dbFront.YourCompany.com/dbFront/ (public server with SSL)
    • http://localhost/dbFront/ (Non-SSL testing URL)
    • NOTE: Azure requires SSL for all except "localhost".
  3. Create a unique application id:  A suggested value is "sp.dbFront.YourCompany.com",
  4. Determine / Create an Azure group for administrators: e.g. "dbFrontAdmins".

Azure Application Setup Steps

  1. Browse to Azure and logon: https://portal.azure.com,
  2. On the Azure Home screen click on the App registration services link to view the configured applications,
  3. Click on the New registration to configure a new application,
  4. This will open a window with the following prompts;
    1. Name: Set with the Display name previously chosen,
    2. Supported account types: Set as appropriate for your needs,
    3. Redirect URI: This should match the root URL for your dbFront install,
      e.g. "https://dbFront.YourCompany.com/dbFront/default.aspx",
      Note: The "/default.aspx" must be included when using Azure, 
  5. Click on the blue  Register  button to create your new Azure application,
  6. This will open your new Azure application in the [Overview] screen,Azure Settings
  7. From the [Overview] screen:
    1. Save the Application (client) ID and enter in dbFront as the dbFront Application Id (see below)
      e.g. "7a0a500e-2240-467b-a4dc-4151d91907db"
    2. Inside the [Overview] screen click on [Endpoints],
      (a link above the details beside [Delete]),
      1. A side-window with multiple endpoints will appear,
      2. Save the SAML-P sign-on endpoint and enter in dbFront as the Azure Endpoint Url (see below)
        e.g. "https://login.microsoftonline.com/92c67466-b89b-46a5-9c0f-1a6804dee116/saml2"
      3. Close the [Endpoints].
  8. Click on [Manage] / [Branding] and update:
    1. Publisher Domain: Update the domain to match your application domain,
    2. Update other settings as desired.
  9. Click on [Manage] \ [Manifest] and update the manifest JSON:
    1. groupMembershipClaims: from null to "SecurityGroup" in quotes,
    2. Save the Manifest changes and exit.

Azure Groups and Users

Please review the Azure documentation for instructions on creating and assigning users and groups to the dbFront application.

dbFront Application Setup Steps

Once the application is set up in Azure, you can then proceed with the setup in dbFront.

The Azure specific instructions are:

  1. Single-Sign-On Service: Azure,
  2. dbFront Application Id: As collected from [Overview] config above,
  3. Azure Endpoint Url: As collected from [Endpoints] config above,
  4. Azure Public Certificate: Enter if provided, leave blank for the Free Azure,
  5. Azure Admin Group: Enter the name of the Azure admin group that should have Admin access to dbFront,
  6. Logout Redirect Url: Enter "https://www.office.com/apps?auth=1".
    This special URL will allow users who log out of dbFront to return to the Microsoft Apps menu where they can either log out completely or start another application.

dbFront - Field Preferences

For complete instructions on completing the dbFront Single-Sign-on setup see: Single-Sign-on

Trouble Shooting

Content you want the user to see goes here.
close