Load data from custom reports built in Report Builder directly into Tableau Desktop using our updated Tableau Web Data Connector. This integration helps recruiting teams to drastically speed up their ability to create and easily refresh dashboards created using Tableau.
Want this integration? Ask your Customer Success Manager about the SmartConnect add-on.
You may still be using the old Tableau Web Data connector which connects to our Analytics data services. The old integration is no longer under active development. We will be sunsetting it in the near future. We encourage all customers to move to Report Builder and the new Tableau Web Data connector as soon as possible.
To take advantage of this integration, you will need to download Tableau Desktop and have an active license. Admin users will also need to provide their SmartRecruiters API key (or SmartToken) to import data into Tableau.
Select your report
- Open up your Report Builder report list by clicking Analytics in the top navigation.
- Find the report name you want to import into Tableau.
- Click on actions dropdown and select Open in Tableau.
- Copy the unique URL in the pop-up modal.
- Open your Tableau Desktop application.
- Under To a Server, choose the Web Data Connector option in the right hand side panel.
- You will be prompted to paste the unique URL into the Web Data Connector dialog. Press Enter.
Find API key
In order to complete the import, you'll need to supply your unique SmartToken API key
To find it:
- Navigate to Settings / Admin.
- Click Apps & Integration in the Configuration list.
- Click on the Credentials tab
- If you've never generated an API credential, click the New Credential button. If you've an existing API key, you may use it.
- Choose API Key to continue to generate a new key.
- Provide a name and a description for your API key and click Generate to create the new API key
- Click Copy to copy the API key to your clipboard.
- Go back to Tableau and your open Web Data Connector window.
- Provide your SmartToken.
- You will now be shown some details about report including:
- Report name
- Data fields (columns) in the report
- Report creation date
- Latest date when report was modified
- Click Import.
- Your data will be imported into Tableau. The Tableau Web Data Connector dialog will close automatically.
From there, you can customize and save the SmartRecruiters dataset like a normal Tableau workbook. The data imported to Tableau is supplied via our Reporting API. The dataset imported into Tableau is always up to date with the latest report file that you've generated in Report Builder, either from ad-hoc report generation or from scheduling your custom report.