Skip to content

Latest commit

 

History

History
70 lines (42 loc) · 2.95 KB

README.md

File metadata and controls

70 lines (42 loc) · 2.95 KB

CrateDB tableau's connector.

Validate and Release connector GitHub Release Static Badge Static Badge

For simple queries and graphs, you can use the default PostgresSQL connector, but for more advance usage SQL compatibility issues and nuanced SQL functionalities get into play, we circumvent/fix those limitations with our custom connector.

How to use.

You will need two things:

The postgresql jdbc driver and the cratedb connector..

Get the Postgresql jdbc driver.

Download the driver from here and put it in:

  • Windows: C:\Program Files\Tableau\Drivers
  • Mac: ~/Library/Tableau/Drivers
  • Linux: /opt/tableau/tableau_driver/jdbc

The latest PostgreSQL jdbc tested driver is postgresql-42.7.4.jar.

The latest CrateDB jdbc tested driver is cratedb-jdbc-standalone-2.7.0

Note: postgresql-42.7.5.jar does not seem to work.

Get the CrateDB connector.

You can find the connector in the release section.

Put it in:

Tableau Desktop

  • Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
  • MacOS: /Users/[user]/Documents/My Tableau Repository/Connectors

Tableau Prep Builder

  • Windows: C:\Users\[Windows User]\Documents\My Tableau Prep Repository\Connectors
  • MacOS: /Users//Documents/My Tableau Prep Repository/Connectors

Tableau Server

  • Windows: C:\Program Files\Tableau\Connectors
  • Linux: /opt/tableau/connectors

For older versions see https://help.tableau.com/current/pro/desktop/en-us/examples_connector_sdk.htm

Disabling signature verification.

The current release of the connector is not signed. This issue is being addressed, but in the meantime, verification can be disabled.

  • On Tableau Desktop, please use this command-line argument: -DDisableVerifyConnectorPluginSignature=true

  • On Tableau Server, you can disable signature verification by setting native_api.disable_verify_connector_plugin_signature to true via TSM.

More information can be found here

State of the driver.

This custom connector aims to offer the best Tableau experience possible, this is a work in progress since PostgresSQL compatibility is not 100% and is bound to change over time.

We test compatibility issues with Tableau's connector sdk: TDVT suite. Progress is tracked in #2