Updating Users for SSO


When single sign-on (SSO) is enabled in your Workfront instance, you can log into Workfront with your SSO credentials.

If you have an existing system that is already populated with users associated with SSO credentials, you can import the users' IDs into Workfront by importing a .csv file into Workfront. 
For more information about integrating Workfront with an SSO system, see "Understanding Single Sign-On in Workfront."

Understanding SSO Usernames

Depending on what SSO solution you use, the username in your SSO environment can be called any of the following:

  • SSO Username
  • Federation ID 
  • Federation Username
  • LDAP Username
  • AD Username
  • Active Directory Username

In Workfront, all these names are stored in the SSO Username field, on the user object. 

In order for your users to be able to use their SSO credentials to log in to Workfront, you must update their profile to include their SSO Username, in addition to their Workfront username.

As a system administrator, you can bulk update the SSO Username field for your Workfront users by using a list of usernames and importing it in Workfront. This list must contain the Workfront User ID (GUID) as well as the corresponding SSO Username for each user and it must be saved as a .csv or a .tsv file. This process either updates existing SSO Usernames in Workfront, or adds a new SSO Username, if one is missing for users. 

Preparing the Import File

You can start preparing your import file by building a report of all users in Workfront that must have their SSO Username fields updated.

To prepare the import file:

  1. Build a user report in Workfront.
    For more information about building user reports in Workfront, see "Creating a Report."
    Select the following fields in your report:
    Name: The full name of the Workfront user.
    ID: The ID is the Workfront alphanumeric GUID.
    SSO Username: Select the SSO Username field to ensure there are no usernames you are overwriting with your import. This field should be blank for all users, if your users have not yet been updated for SSO.
    Save the report. 
  2. Click Export at the top of the report and export the report to Excel. 
  3. Open the exported Excel file, and start adding your SSO Usernames for each user in the report in the SSO Username column.
  4. Eliminate all columns in the Excel file, except for the ID and the SSO Username columns. 
  5. Eliminate the column headers and ensure there are no blank rows at the top of the report.
    The file you are using for updating your Workfront users with the SSO usernames must meet the following requirements:
    • It should contain just two columns, in this order: 
      • The first column should display the Workfront user ID (the user GUID as found in Workfront). 
      • The second column should contain the SSO Username, as it displays in your SSO system. 
    • The columns should have no headers, and there should not be any empty rows at the top of the list of names.
  6. Save the report as a .csv or .tsv file on your computer.

Updating Users for SSO

The process of updating users for SSO either adds the SSO Username field to your Workfront users if one is not present, or updates the value for the SSO Username for your Workfront users, if there is a value already associated with the users. 

To update users for SSO:

  1. Click Setup, in the upper-right corner of any Workfront page.
  2. Click System then Update Users For SSO.
  3. Click Choose File to browse for the file you prepared.
    For more information about how to prepare the correct file, see "Preparing the Import File."
  4. Select the file from where it is saved on your computer.
  5. Click Save.
    This will enable all users to log in to Workfront using their SSO credentials. 
    The Only Allow <SSO Configuration> Authentication setting is enabled for all users included in the CSV at this time.
    For more information about user settings, see "Editing User Accounts."

Verifying SSO Usernames for Workfront Users

  1. Run a user report with SSO Username information.
    For more information about building a user report with SSO Username information, see "Preparing the Import File".
  2. Notice that the SSO Username column is populated for each user. Ensure that the values for the SSO Username column match the SSO Username on your SSO server. 
  3. If the SSO Username column is blank, update your users' SSO Usernames.
    For more information about updating your users for SSO, see "Updating Users for SSO".


This article last updated on 2018-11-02 11:02:10 UTC