Skip to main content

 

Eptura Knowledge Center

Tableau business intelligence

  1. Last updated
  2. Save as PDF

Introduction

https://www.tableau.com/

While Tableau can connect to many data sources, it is not capable of connecting to the Azure Table Storage that we use in our provision of data for Power BI. However, cdata.com provides a third-party ODBC connector that enables this connection.

https://www.cdata.com/

Installation

Download and install the ODBC drivers from https://www.cdata.com/drivers/azure/download/odbc/

  1. Go to the ODBC Data Source Admin panel.
    ODBC Data Source Administrator (64-bit) panel
  1. Add a new DSN.

Connection Properties:
The Account is the storage account name.
The Access Key is the long, complex Access key.
Leave the default settings for everything else.

  1. Test your connection.
    The connect test was successful message

Tableau

  1. Add a new connection, select ODBC driver and choose the connection you just created.
  1. Select the Booking, Booking Items tables, and create a local database (Extract mode).

This will take some time to build.

Tableau screen