Web Data Connector to connect to data that is accessible over HTTP and that doesn't already have a connector. A web data connector is an HTML file that includes JavaScript code. We can create our own web data connector or can use a connector that is already exist and written by someone else. The web data connector must be hosted on a web server running locally on your computer, on a third-party web server, or on Tableau Server.
We should use a trustworthy web data connector.
There are sample web data connectors available and written by tableau.
1. Facebook Sample Connector
2. Googlesheets Sample Connector
3. Incremental Update Sample Connector
4. JSON Sample Connector
5. Socrata Sample Connector
6. XML Sample Connector
A web data connector uses REST API and converts the data to JSON and passes it to tableau.
Example: Setting up the environment
We need git and npm (node js package manager and node js installed)
Get the WDC SDK (web data connector software development kit)
Open a terminal in the directory where you want to download the WDC SDK. Then run the following command to clone the WDC git repository:
git clone https://github.com/tableau/webdataconnector.git
Change to the directory where you downloaded the repository:
cd webdataconnector
Install dependencies with npm:
npm install --production
Start the test web server:
npm start
Open a browser and navigate to the following URL:
https://localhost:8888/Simulator/index.html
After that, we can see the simulator screen on our web browser.
Checkout Tableau Server Tutorial
Trying the sample
In the WDC URL field, confirm that the URL is set to the sample USGS Earthquake Data connector:
../Examples/html/earthquakeUSGS.html
Click the Start Interactive Phase button to display the user interface for the earthquake WDC.
Click the Get Earthquake Data button.
Click the Fetch Table Data button to download the data and display it in a table.
Related Page: How To Build Your First Advanced Dashboard In Tableau?
1. First create a new file named earthquakeWDC.html
and save it in the top-level directory of the webdataconnector repository.
2. Create a javascript file for the connector. Name it earthquakeWDC.js
and save it in top level directory
Create an event listener for the UI button in Html page.
WDC will get data in JSON format and pass it to the tableau. So let’s create schema for that.
3. Now we are all set. Save all and start the server by typing npm start in cmd
4. Open the browser and go to
https://localhost:8888/Simulator/earthquakeWDC.html
Checkout Tableau Interview Questions
IF everything works fine when we click the Get Earthquake data button we should see the result.
Now pass this to tableau.
On the start page, in the Connect pane, click More Servers… > Web Data Connector.
https://localhost:8888/Simulator/earthquakeWDC.html
If everything works fine, then we should get the visualization
Here we have successfully obtained the data and put it into a tableau.
Tableau Advanced |
Tableau Server |
Data Visualization and Dashboarding Fundamentals |
Tableau Prep |
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
Name | Dates | |
---|---|---|
Tableau Training | Dec 24 to Jan 08 | View Details |
Tableau Training | Dec 28 to Jan 12 | View Details |
Tableau Training | Dec 31 to Jan 15 | View Details |
Tableau Training | Jan 04 to Jan 19 | View Details |
Viswanath is a passionate content writer of Mindmajix. He has expertise in Trending Domains like Data Science, Artificial Intelligence, Machine Learning, Blockchain, etc. His articles help the learners to get insights about the Domain. You can reach him on Linkedin