Create a Salesforce user provisioning report for Hoopla

Learn how to build the report in Salesforce that keeps your users in sync with Hoopla

By adding users this way, they will login to Hoopla using their Salesforce credentials via Single Sign-On (SSO).

Create a User Report in Salesforce

1. In the Salesforce Report Builder, create a new report based on the User object.

2. Ensure the format is set to “Tabular”. If you are creating teams with the master report, use Summary format grouped by the field that you would like to create the teams under (Role, Profile, Manager, etc).

3. Add criteria that will return the set of users who should be added to Hoopla. Setting the report to Active Users only will automatically add and subtract users from Hoopla as you add/subtract employees or change people’s roles in Salesforce.

4. Only one report can be used to provision users, so make sure it includes the right people!

5. Add the “Email” field and the “User ID” field as columns in the report; just click and drag each field from the left menu to the report. (You should also have First Name, Last Name, and Username as columns, by default.)

6. Run the report and save it. Tip: Create a report folder in Salesforce called “Hoopla Reports” to keep things better organized.

You can now create teams in the Master User report by Grouping the report by the field you would like the teams to be made of. Teams will be created in the system with the exact names of the fields. If you already have the exact names in as a Team, the system will sync to it, otherwise, it will create a new team.

Map the Report to Hoopla User Provisioning

1. Go to the Salesforce Integration area in the Hoopla Admin panel.

2. Click Select Report under User Provisioning and find the report you built.

3. Hoopla will automatically check this report once per day. You can choose “Run Now” anytime to sync any changes in the report. (note: it may take a few minutes to complete)

Salesforce Profile Photos

The first time users sync with Hoopla, Salesforce profile photos will automatically be applied as the default Hoopla profile photo. Users and Admins can then customize the photo in Hoopla as desired. Any subsequent changes to Salesforce profile photos will notautomatically sync over to Hoopla.

More Info

For more help on building Salesforce reports check out these resources from Salesforce:

Video from Salesforce describing how to build reports.

http://salesforce.vidyard.com/watch/-8deIXAgRiNA7zJnyTr_3w

Salesforce Help on Report Building

https://help.salesforce.com/articleView?id=analytics_overview.htm&type=5

Related articles

• Salesforce users unable to login to Hoopla Fix the account-not-connected error on Login with Salesforce by making sure the user meets your Salesforce user report criteria.
• Verify a Hoopla player’s Salesforce login Verify a player’s Salesforce user account so they can sign in to Hoopla with the Login with Salesforce option.
• Connect Salesforce to Hoopla Connect your Salesforce org to Hoopla, see which permissions it requests, and fix common authorization and data sync problems.