Business Intelligence Tool Integration Add-On

Jump Ahead To:

• Integrate with Domo
• Integrate with Tableau Desktop
  • Tableau Web Data Connector (WDC) 3.0

Overview

QBench offers an add-on that integrates with compatible Business Intelligence (BI) Tools that support JSON over an HTTPS connection. These are configured with Web Data Sets to generate a JSON file for specific fields and a specific Filter. Each Web Data Set has its own unique URL that you can feed into your BI Tool which refreshes its data every night around 11pm PST. To create a Web Data Set, navigate to Configuration -> Application -> Web Data Sets and click + New Web Data Set. Here is an example of a Web Data Set configuration:

• Name: Name of your Web Data Set
• URL: Auto-generated URL which you will use to feed into your BI Tool
• Data Type: The data type this Web Data Set is for
• Global Filter: The Global Filter which includes the entities that you are creating a Web Data Set for
• Basic HTTP Authentication Password: The password needed in order to access the auto-generated URL
• Allowed IP Addresses: Optional IP address whitelisting for enhanced security (only applicable if your BI Tool setup supports this)

Web Data Set Fields

You can specify any field related to the data type of your Web Data Set. In the example above, this is a Web Data Set for Tests, so each field indicates a value related to a Test. You can also indicate Worksheet fields if your workflow utilizes Worksheets. The resulting JSON file will only include the fields you specify in this section.

Integration with Domo

1. Click "Search Connectors"
2. Search for "JSON Connector" and select it
3. In the Credentials section
   1. Click the "Select Account" dropdown and select "Add account..."
   2. For Username, input a valid QBench admin account email
   3. For Password, paste in your Web Data Set's Basic HTTP Authentication Password
   4. 
4. Click next
5. In the Details section
   1. For Connection Method, select HTTP Request
   2. For URL To JSON File, paste in the Web Data Set's URL
   3. 
6. Click next
7. In the Scheduling section
   1. Set how often you want your data to update. We recommend updating every day at 9am UTC to ensure your Web Data Set has had time to refresh its data before it gets loaded into Domo
   2. Set the Update Method to Replace.
   3. 
8. In the Name & Describe Your DataSet, give your DataSet a relevant name and description
9. Click Save and Run

Integration With Tableau Desktop

Watch the video below to learn how to integrate QBench with Tableau Desktop.

Tableau Web Data Connector (WDC) 3.0

QBench has built a Tableau connector using Tableau's new Web Data Connector SDK https://help.tableau.com/current/api/webdataconnector/en-us/index.html 

How to Install

1. Download the QBench web data set connector file.
   1. The file is located at the bottom of this article. It is named "qbenchwebdatasetconnector-1.0.0.taco".
2. Visit the Tableau support page for instructions on where to place the ".taco" file after you have completed the download.
3. Restart your Tableau Desktop App.
4. When the app starts, there will be a new connector called "QBench Web Data Set Connector"
5. Click on "QBench Web Data Set Connector" and enter in the required credentials.