Configure SSO with OneLogin

This guide is intended for Admins setting up SSO SAML with OneLogin. OneLogin is a cloud-based identity and access management solution.

When you configure Single Sign-on (SSO) with OneLogin, your users will be able to create and sign into their Baserow accounts using OneLogin.

If you are looking for information on setting up SSO with other providers:

Single Sign-On feature is a part of the Baserow Enterprise offering. Instance-wide features are only available on the self-hosted Enterprise plan. To learn more about the Baserow enterprise plan, visit our pricing page.

Here’s how to set up OneLogin to sign in to your Baserow account.

Set up SSO SAML with OneLogin

Log in to your OneLogin account as an administrator. Click Administration on the toolbar to go to the Admin panel.

To add apps to your company app catalog, go to Applications > Applications from the admin page then click on Add App:

enter image description here

Search and select the SAML Custom Connector (Advanced):

enter image description here

Enter Baserow as the Display Name of the new app, and make sure Visible in portal is on. Upload icon and add a description to the new SAML connector.

enter image description here

Click Save. You’ll find a new left-side navigation menu after saving. Click Configuration in the sidebar menu.

Next, log in to Baserow. Go to the Admin > Authentication > Provider. Retrieve your Default Relay State URL and Single Sign On URL from your Baserow admin settings modal, following the steps in this guide.

In OneLogin configuration tab, paste your Baserow Default Relay State URL in the RelayState field.

Paste your Single Sign On URL in the next four fields as shown below.

Baserow value Corresponding OneLogin Configuration field
Default Relay State URL RelayState
Single Sign On URL Audience (EntityID)
Single Sign On URL Recipient
Single Sign On URL ACS (Consumer) URL Validator*
Single Sign On URL ACS (Consumer) URL*

Convert your Single Sign On URL into a regular expression and paste that into the ACS (Consumer) URL Validator* field. For information on regular expression, visit this link. Add the required symbols in the ACS (Consumer) URL Validator* field as shown in the picture below to make it a valid regex:

enter image description here

Set the next set of configuration fields as shown below:

OneLogin field Value
SAML initiator OneLogin
SAML nameID format Email
SAML issuer type Specific
SAML signature element Both
SAML encryption method AES-128-CBC
Generate AttributeValue tag for empty values ☑
SAML sessionNotOnOrAfter 1140

enter image description here

Once you’re done, click Save to store the app settings.

After saving, click on the Parameters tab. Then, click the + icon to add 3 custom parameters.

Assign the following field names and check **Include in SAML assertion. Click Save  to go to the next screen then select the corresponding values from the dropdown:

Field name Value
user.email Email
user.first_name First Name
user.last_name Last Name

Set the parameters that will be sent in the SAML response with values as shown below:

enter image description here

Once you’re done, click Save.

To configure the SAML provider in Baserow, you’ll need to download the SAML metadata from the “More Actions” menu in the Applications tab as shown below:

enter image description here

After you’ve accessed the information from the SAML Metadata, copy and paste the information from OneLogin into Baserow.

Connect OneLogin to your Baserow Account

Head back to Baserow Admin > Authentication > Provider.

Configure OneLogin by inputting the domain and metadata information into the corresponding fields in your Baserow Admin Dashboard, following the steps in this guide.

enter image description here

You should be able to log in with OneLogin after completing these steps by visiting your Baserow servers login page. Your users will now be taken to a OneLogin sign-in flow when they attempt to log into Baserow. After logging in with their OneLogin credentials, they will be redirected to the app.

enter image description here

Add users to access OneLogin

You can grant your users access to the newly created application, either by adding to individual Users or by adding to Roles or Workspaces within OneLogin, depending on how you prefer to manage your Users there.

To add users to this application, click on Users in the top bar menu item.

Go to Users > Users and click the New User button to open the User Info page. On the User Info page, verify that the user is activated. Enter the user’s name and email address, along with any other personal information you want to include. Click the Save User button.

enter image description here

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.