This post is in reference to the associated Github repo at https://github.com/mortie23/tableau-wdc.

Tableau WDC

Quick example of a Tableau Web Data Connector (WDC) pointing to the output of a SAS proc json.
Reason: For example, your source data is in SAS, and your BI tool is Tableau. You want a way to publish the data to Tableau and you have access to a webserver.

Automate the generation of the WDC package

Before we start, if you have lots of datasets or need to make lots of changes to a dataset, then creating or modifying the javascript becomes tedious. I’ve built a simple Node.js package to automate this. See Tableau Web Data Connector Node Generator post if you are interested.

Tutorial

This is based on this tutorial.
https://tableau.github.io/webdataconnector/docs/wdc_tutorial.html

Generate the data

To generate the JSON I installed WPS Community edition.

libname this "./data";
proc json out="./json/class.json";
  export this.class;
run;

Deploy the HTML/JS/JSON

To get this demo going, copy the files in the Github repo to a location on your webserver. In this example I’ll be using my mortie23.github.io/

Test the WDC

Open up Tableau (in this case I’m just using Tableau Public Desktop).

Add a data connection

Browse the the published WDC HTML page

Get the data

Click Get Class Data! and you should be able to build a dashboard from the JSON data now.