If you know how to use Web Data Connectors in Tableau, already have a valid API token and know the login URL for your Bridge account, then you can skip the rest of this document. The only other thing you need is the URL for the Bridge Web Data Connector: https://tableau-connector.bridgeapp.com/
If you want more details on how to set up the Bridge connector, read on.
To the use the Bridge connector for Tableau you need the following:
- A copy of Tableau Desktop
- A Bridge API Token, encoded for Basic Auth
- The URL you use to login to Bridge
- For Tableau Server the Safe List needs to be updated. More details are available here: https://help.tableau.com/current/server/en-us/datasource_wdc.htm
NOTE: For the Tableau Server Safe List, the Bridge Tableau connector uses the following:
- Domain: bridgeapp.com or subdomain.bridgeapp.com where subdomain is the customer’s unique Bridge URL. It is the same URL that is used to login to Bridge.
- Port: 443
To Get the Bridge API Token
- Login to Bridge as an Admin user and navigate to Admin > General > Account Settings > API
- From the API page, click on + Add Token to create a new API Token
- Select the Role that you want this token to have for the Tableau connector. Bridge recommends, Account Admin or Admin. Keep in mind that whoever has this token can access all the User and Learn / LMS-related information in your Bridge account via the APIs.
- Give the Token a name.
- And optimally set an expiration date for the Token if you want it to stop working at some point in the future.
- When Bridge displays the Key, Secret and Authorization (encoded token), at a minimum make sure that you copy the Authorization (encoded token). You will need this to use the connector. This is the only time that you will be able to copy the Secret and Authorization (encoded token). If you lose those values, you will need to delete this token and create a new one.
Bridge Login URL
- Most Bridge customers login to Bridge with a URL that is similar to this: https://customername.bridgeapp.com except that customername is a value that is unique to your account. When you are setting up the Tableau Connector you will need to know the login URL. When the connector prompts you to enter the URL, enter the entire URL.
Setup the Bridge Connector in Tableau
To set up the Bridge Connector and start importing data to Tableau.
1. Open Tableau Desktop
2. On the left click the option under Connect To Server for Web Data Connector
3. When the Web Connector window opens, enter this for the web data connector URL https://tableau-connector.bridgeapp.com/. Tableau will automatically take you to the next screen
4. In the URL field enter your Bridge login URL, for example, https://customername.bridgeapp.com
5. In the Key field enter the Authorization (encoded URL) token that you got from your Bridge Admin or generated in your Bridge Account
6. Click the Set Credentials and URL button to continue
7. Use the Select List to choose which Bridge Data you want to import to Tableau
a. List Courses include information about all the Courses you have created in Bridge. The optional parameters will allow you to filter the list of Courses, by things like updated after, created before, etc.
b. List Course Enrollments include information about users that have been enrolled in a course in Bridge. You have the choice of limiting the import to a specific Course or importing enrollments for all Courses
c. List User includes the user account details for all the users in Bridge. The optional parameters will allow you to filter the list of Users by things like updated after, created before, include deleted, etc.
8. Each time you select the Table you want to import, you need to click the Add button
9. After clicking the Add button, you can set optional parameters for that Table to limit what data is imported
10. Click the Done button to return the list of Tables
11. After you have selected all the Tables you want to import to Tableau click the Finish button
12. Tableau will display a status dialog. Once complete, click the Update Now button to see a preview of the data that is being imported
13. If you selected more than one Table, you should select the common field in each table so you can build reports using all of the data
a. The Course Enrollments and Courses Tables both have a Course ID field
b. The Course Enrollments and Users Tables both have a User ID field
14. Once you have created the relationships between the reports (if needed) Tableau will use the Bridge APIs to retrieve and import the data
15. Now you can create whatever visualizations you want with the standard Tableau tools
This guide contains each of the fields that are imported to Tableau. For each field, it includes the Tableau Field Name, the data type for the field, a short description, and the name of the field in the Bridge API response.