Tableau

Prerequisites
Configure Database Connection
Review Tables in Data Source Pane
Visualization
Examples

Overview

Tableau Desktop is a visualization software that provides tools to query, analyze, and aggregate data from multiple data sources. The following guide outlines the initial configuration steps and includes examples of using the Tableau Desktop user interface in order to build charts from historical data stored in the Axibase Time Series Database (ATSD).

Dataset

For the purpose of instruction, we will use the following sample series commands. The series contain the national import and export statistics over a period of 30+ years. The series are seasonally adjusted and are collected on a monthly basis.

To load the data, log in to ATSD and submit these commands on the Metrics > Data Entry page.

Prerequisites

Install Tableau

Install Tableau Desktop 10.2
Copy ATSD.tdc to the Tableau Repository. On Windows the repository is located in the C:\Users\You\Documents\My Tableau Repository\Datasources directory

Install ODBC-JDBC Bridge

Install ODBC-JDBC gateway
Make sure that the ‘Strip Quote’ and ‘Strip Escape’ checkboxes are enabled

If your ATSD installation has more than 10000 metrics, consider adding a tables={filter} property to the JDBC URL to filter the list of tables visible in Tableau.

Configure Database Connection

Launch Tableau
Select Connect > To a Server > Other Databases(ODBC)
Select the ATSD DSN from the dropdown. This is the DSN you specified during ODBC-JDBC bridge setup
Press Connect and wait a few seconds
Leave the Server,Port, Database and String Extras fields empty
Press Sign In

Review Tables

Enter a keyword and click the Search button. For this exercise, we will search for the bi.ex_net1.m table:

Drag-and-drop the table to Canvas area
Press Update Now.

Visualization

Press Sheet 1
Press OK to acknowledge the warning about limitations
Set Datetime to the columns field
Set Value to the rows field

Since time and datetime represent recorded times composed of different data types (long and timestamp), make sure you select only one of these columns in your queries.

Inspect a subset of the visualized data:

Select some data points in the view
Right click and choose View Data