# 2.8. Tableau¶

## 2.8.1. Introduction¶

The tableau integration works with our ODBC driver.

We will guide you through the process of:

• installing the driver

• connecting to it in tableau

• querying directly to import data

## 2.8.2. Installation¶

You can install the driver with our specific ODBC driver setup: qdb-odbc-driver-[version]-windows-64-bit-setup or its 32bit counter part.

You can choose the folder where you want it installed and that’s it!

Caution: Using the uninstaller will automatically remove the driver.

You can check detailed instructions in the installation part ODBC documentation.

## 2.8.3. Datasource¶

The best way to create a datasource is to open a powershell window and using odbcconf.exe

odbcconf.exe CONFIGDSN "qdb_odbc_driver" "DSN=quasardb|Driver=qdb_odbc_driver|URI=qdb://127.0.0.1:2836"


It’s especially useful if you wish to connect to a secured cluster:

odbcconf.exe CONFIGDSN "qdb_odbc_driver" "DSN=quasardb|Driver=qdb_odbc_driver|URI=qdb://127.0.0.1:2836|UID=user_name|PWD=user_private_key|KEY=cluster_public_key"


You can add as many parameters as you wish in the secondary string.

Here is a list of the most common parameters, you can either set them in the dsn or the connection string you use.

Parameter

Description

LOGDIR

A path to the folder in which you wish our log file to be stored

URI

A cluster URI you wish to connect to

UID

PWD

The password associated with the user

KEY

The cluster public key file content

DSN

The name of the datasource

DESCRIPTION

A description of this specific datasource

Any unmentionned field will be filled with a default value.

## 2.8.4. First connection¶

You can then click on Connect -> To a Server -> More… >

Then click on Other Databases (ODBC):

You will need a datasource for this part, you can refer to the windows section of the ODBC documentation.

You can then select qdb_odbc_driver in the DSN field, then click on connect:

The String Extras will show up after the connection succeeded.

If the server is not running, or the connection fails you will see the following message:

Make sure a server is running, and check the datasource connection details match with your server.

Well done, you’re now connected to the qdb datasource.

## 2.8.5. Querying data¶

In this example we will assume we have a timeseries ts with a column col.

You can create it in qdbsh with the following statements:

$> qdbsh --cluster qdb://127.0.0.1:2836 quasardb shell version 3.9.6 build 6a6663c98 2020-12-02 16:29:16 +0100 Copyright (c) 2009-2020, quasardb SAS. All rights reserved. Need some help? Check out our documentation here: https://doc.quasardb.net qdbsh > CREATE TABLE ts(col int64) qdbsh > INSERT INTO ts($timestamp, col) VALUES(2020-01-01, 1)

qdbsh > INSERT INTO ts($timestamp, col) VALUES(2020-01-02, 2)  To query data, double-click on the New Custom SQL: A window shall open, enter the following query: SELECT$timestamp, col FROM ts


You can click on Preview Results, a window with the following results should show up:

Or click Ok.

Before going to the sheet, extract the data in the top right corner:

Then go to the sheet in the bottom left corner:

It will ask you to save the extraction, a few warnings may show up, continue to the main sheet.

Example of a warning:

Once in the main sheet, select \$timestamp as the x axis, and col as the y axis:

Select this graph type:

By default the unit for the timestamp is YEAR, click on the downward arrow and select exact date: