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.

Enroll now for the ultimate Tableau Training from Mindmajix.

We should use a trustworthy web data connector.

There are sample web data connector 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:

Subscribe to our youtube channel to get new updates..!

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.

Web Data Connector

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

Related Page: How To Build Your First Advanced Dashboard In Tableau?

Create HTML page

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 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 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 browser and go to

https://localhost:8888/Simulator/earthquakeWDC.html

HTML FILE

HTML File - 1

HTML File - 2

JS FILEJS File - 1

JS File - 2

JS File - 3

Checkout Tableau Interview Questions

IF everything works fine when we click Get Earthquake data button we should see the result.

Tables of EarthquakeFeed Column Metadata

Now pass this to tableau.

On the start page, in the Connect pane, click More Servers… > Web Data Connector.

Web Data Connector

Enter the URL of a WDC and press Enter.
Web Data Connector
Our url: https://localhost:8888/Simulator/earthquakeWDC.html

If everything works fine, then we should get the visualization

Tableau Map

Here we have successfully obtained the data and put it into tableau.

Explore Tableau Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

List Of Tableau Courses:

 Tableau Advanced
 Tableau Server
 Data Visualization and Dashboarding Fundamentals
 Tableau Prep