Awesome

Introduction

The Tableau plugin for GridDB makes it possible to access GridDB databases from Tableau.

Required software

Tableau Desktop 2020.3 or later
GridDB V4.3 or later

How to install

Copy the GridDB JDBC driver Copy the GridDB JDBC driver (gridstore-jdbc-4.X.X.jar) to the following directory.
```
C:\Program Files\Tableau\Drivers\
```
Copy the GridDB plugin file

Locate griddb_jdbc.taco in the following directory.
```
C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
```

Run Tableau.exe with the following argument

-DDisableVerifyConnectorPluginSignature=true

"C:\Program Files\Tableau\Tableau 2020.3\bin\tableau.exe" -DDisableVerifyConnectorPluginSignature=true

How to use

Select [To server] -> [Others] after running Tableau
Select [Toshiba GridDB JDBC]
Input GridDB information in the dialog

Server: specify GridDB cluster information by the fixed list method
　(Example 1：192.168.10.10:20001)
　(Example 2：192.168.10.11:20001,192.168.10.12:20001,192.168.10.13:20001)

Username: specify a GridDB user name
Password: specify a GridDB password
ClusterName: specify a GridDB cluster name Database: specify a GridDB database name
Press the [Sign in] button

Note

Note 1: Limitations in the versions released until Tableau Desktop 2020.3.1.

If there are multibyte characters in the path in which you specify where to locate the GridDB Tableau connector, an error occurs when you load the connector. As a result, it is not displayed on the Tableau screen.

This issue will be fixed on Tableau 2020.3.2.

If you use an older version, follow the below guide.

Change the path of griddb_jdbc.taco to a location without multibyte characters
(e.g. C:\tableau_taco)
Run tableau.exe with the following additional argument
-DConnectPluginsPath=[the path where griddb_jdbc.taco is located] (e.g. -DConnectPluginsPath="C:\tableau_taco")

"C:\Program Files\Tableau\Tableau 2020.3\bin\tableau.exe" -DDisableVerifyConnectorPluginSignature=true -DConnectPluginsPath="C:\tableau_plugin"

Limitations

Join condition

You can not use the Right Join and the Full Join statements.
Filter

The below conditions, which you can specify when you select [Conditions] of a filter, can not be used.
[Median] [Percentile] [Sample standard deviation] [Population standard deviation] [Sample variance] [Population variance]
Column of TIMESTAMP type
If you choose TIMESTAMP type columns as [Row] and [Column], you can use the options like [Quater Second quater], [April May], etc., whereas you can not use the options like [Quater 2015 second quater], [April 2015 May], etc.

File structure

This software contains the below files:
- connectionBuilder.js
  The script file creating a JDBC destination URL.
- connection-fields.xml
  The file in which connection dialog fields are saved.
- connection-metadata.xml
  The file in which the fields related to database, scheme, and table metadata of the screen opened after connection are saved.
- connectionProperties.js
  The file used when opening a JDBC connection. A username and a password are saved.
- connectionResolver.tdr
  The file in which vendor unique parameters are saved.
- dialect.tdd
  The file in which SQL dialect is saved.
- manifest.xml
  The file in which the connector name is saved. Tableau uses the name to add it to the list of available connectors in the UI.

(For your reference) How to create a taco file

Required software to create a taco file
- Python 3.7.3 or later
- Java JDK
- git
How to create a taco file

Please take a look at "Package and Sign Your Connector for Distribution"
https://tableau.github.io/connector-plugin-sdk/docs/package-sign to see the detail.

The procedure to create a taco file on an Windows OS is as below:

Clone the repository of Tableau Connector SDK
Clone the repository of Tableau Connector SDK by git.
```
git clone https://github.com/tableau/ connector-plugin-sdk.git
```
Create an virtual environment by venv
Create an virtual environment where a procedure that creates an taco file by venv is done.
At first, move to the connector-packager folder created by the clone command in the command prompt.
```
Example)
cd connector-plugin-sdk\connector-packager
```
Create a new environment and activate it.
```
python -m venv .venv
.\.venv\Scripts\activate 
```
Install required modules
Install required modules needed to create a taco file.
```
python setup.py install
```

Create a taco file Create a taco file.

python -m connector_packager.package [The file path of connection-fields.xml, connectionBuilder.js, etc.] --dest [Taco file output path] -l [Log file output path]

The taco file and the log file are output in the destination path.

Community

Issues
Use the GitHub issue function if you have any requests, questions, or bug reports.
PullRequest
Use the GitHub pull request function if you want to contribute code. You'll need to agree GridDB Contributor License Agreement(CLA_rev1.1.pdf). By using the GitHub pull request function, you shall be deemed to have agreed to GridDB Contributor License Agreement.