The tableau integration works with our ODBC driver.
We will guide you through the process of:
installing the driver
adding a datasource
connecting to it in tableau
querying directly to import data
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.
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.
A path to the folder in which you wish our log file to be stored
A cluster URI you wish to connect to
The username you log in with
The password associated with the user
The cluster public key file content
The name of the datasource
A description of this specific datasource
Any unmentionned field will be filled with a default value.
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.
If the connection suceeded, click on sign in to continue.
Well done, you’re now connected to the qdb datasource.
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: