We should use a trustworthy web data connector.
There are sample web data connector available and written by tableau.
Facebook Sample Connector
Googlesheets Sample Connector
Incremental Update Sample Connector
JSON Sample Connector
Socrata Sample Connector
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:
Install dependencies with npm:
npm install --production
Start the test web server:
Open a browser and navigate to the following URL:
After that we can see the simulator screen on our web browser.
Trying the sample
In the WDC URL field, confirm that the URL is set to the sample USGS Earthquake Data connector:
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?
First create a new file named earthquakeWDC.html and save it in the top-level directory of the webdataconnector repository.
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.
Now we are all set. Save all and start the server by typing npm start in cmd
Open browser and go to https://localhost:8888/Simulator/earthquakeWDC.html
USGS Earthquake Feed
Get Earthquake Data!
IF everything works fine when we click 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.
If everything works fine, then we should get the visualization
Here we have successfully obtained the data and put it into tableau.
|Data Visualization and Dashboarding Fundamentals|
Get Updates on Tech posts, Interview & Certification questions and training schedules