Tableau Conference 2015: Viva Las Vizzes!

Wow, what an amazing week!

A huge THANK YOU to all of our Tableau customers and to our Tableau Conference team for putting on another spectacular Tableau Conference!

I enjoyed catching up with customers, seeing patients at the Tableau Doctor clinic, helping out in several of our Hands-on-Training sessions, and attending the keynotes.

Check out Ellie Fields' recap of the Devs on Stage keynote for what new features are on the horizon!  I'm especially pumped about cross-database joins, workbook version control, enhanced support for device specific dashboards, vizzes in the tooltip, additional built-in statistics like k-means clustering, our new apps, and more... There is just too much to list!

I hope you can all join us for TC16 in Austin, TX.  It's never too early to register.

See ya'll there!

Embedding Tableau into SFDC via iframe

Looking to get started with Tableau embedded into SFDC?

Below you'll find a quick outline for creating a Visualforce tab and embedding Tableau via an <iframe>.  The steps outlined also include extending access to the Salesforce1 mobile app.  If you require richer integration, you can use the SFDC canvas adapter to create an app within the SFDC Canvas framework. (not covered in this post)

While logged in as a Salesforce Admin, select your username, and click Setup.

Click Develop and create a new VisualForce page.

 Here I embed a Dashboard using a simple iframe.  Don't forget all your embed parameters.

Then under Create, select Tabs, and create a new VisualForce Tab.

Select the VisualForce Page we just created and select a style.

Next, under Administration Setup, select Mobile Administration.

Select Mobile Navigation...

Then add the VisualForce Tab you created to the Navigation Menu Items Selected.

 Let's test it out.  I'm using Google Chrome with the Salesforce1 Simulator.

Then, while logged into SFDC, click this icon.

 Navigate... and enjoy!

Stay tuned for a future article on authentication options...

Using Tableau with Vertica?

Check out this whitepaper on Tableau/Vertica best practices.

Monitor Cluster Health with Tableau Server

Heeyy Mon,

You have a Tableau Server?  Need to monitor CPU, RAM, network, and hard-disk usage?  Cache-hit ratio, request latency, active sessions, and more?  Check out TabMon!

Looking for past versions of Tableau?

If you ever need to download a different version of Tableau, you can find it here.

Connecting Tableau to Presto

Here is a short, but hopefully useful one.  I have several customers I support that are using Presto.  In case you are looking to connect Tableau to Presto, here is a collection of options:

Presto Github ODBC driver: https://github.com/prestodb/presto-odbc/releases

'Prestogres' by Treasure-Data: https://github.com/treasure-data/prestogres

Presto WDC: https://github.com/facebook/presto/pull/3104 

Teradata also announced enterprise support for Presto back in June, so more options should be coming.

Please add comments if you have successfully connected via other means.

Intro to the Web Data Connector

One of the new features that I am most excited about in Tableau 9.1 is the Web Data Connector (WDC).  It simplifies the process of connecting Tableau to data that doesn't already have a native connector.  It allows you to connect to virtually anything that can be queried over http or https, including web services, JSON, XML, and REST APIs.  Be sure to bookmark the Web Data Connector Developers section of the community if this is of interest to you.

Although some assembly is required, a Web Data Connector is essentially a simple HTML page with a bit of Javascript code that queries an http target and builds a TDE (Tableau Data Extract).  Because the connector is something you can build with a bit of script, you can even combine multiple datasources in a single workflow.  Think of all the possibilities!

Well let's say you want to connect to Google sheets.  How do you get started?  Well if someone out there is already hosting a WDC for Google sheets, you can just connect using that URL when prompted.  For reference, here is a list of community created WDCs so far, some hosted, some that you'll have to host yourself.  Try out the import.io connector if you want to connect to some web data fast.

If you don't have a hosted option available, you may need to host it yourself.  One option is to spin up a web server on your local machine so that you can call your html page through the Web Data connector option in Tableau Desktop. The documentation in the aforementioned resources will include details on how to setup Python as a local web server as an example.

If you want to make this WDC available across your organization, and/or make scheduled refreshes of the extract available, you will need to import the .html file into Tableau Server.  By importing the WDC to Tableau Server, it becomes centralized, secure, and no longer requires Tableau Desktop users to spin up their own local server!  Now go connect to some web data and publish something cool to Tableau Public (using public data of course)!