Tableau live Reports using Web/REST API through Presto Server

Posted on September 4, 2019 Updated on September 4, 2019

Problem Statement:

Tableau couldn’t fetch live data through web data connector

Solution Approach :

One of the solution is to use Presto ODBC driver in Tableau so that Tableau can connect to Presto and access the data from Presto’s catalog. In the next step need to build the Custom HTTP Connector for Presto which will fetch the metadata/data from Web API. This solution will be as shown below:

Conclusion:

This way we can fetch the live data from WebAPI without using any commercial odbc / jdbc drivers or bridge.

Reference :

https://downloads.tableausoftware.com/drivers/simba/SimbaPresto1.1-64-bit.msi

https://help.tableau.com/current/pro/desktop/en-us/examples_web_data_connector.htm

https://prestodb.github.io/docs/current/develop/example-http.html