Support for Tableau Linux Server

[cristianc-ty]

Greetings,

First and foremost I want to thank you for this awesome project, it works flawlessly for Tableau Desktop.

What I'm trying to do however is to install the connector on Tableau Linux Server following the steps from: https://tableau.github.io/connector-plugin-sdk/docs/run-taco#set-up-tableau-server

The ClickHouse ODBC driver is in place and works fine, I can connect to clickhouse and run queries.

The problem seems to appear when I'm trying to load the clickhouse tableau connector in Tableau Linux Server.

Some of the relevant log lines I found:

 {"ts":"2021-06-29T08:53:58.939","pid":1809,"tid":"38f3","sev":"warn","req":"YNq1dq8NLwBjJbuNh2ZvqgAAAF8","sess":"-","site":"-","user":"-","k":"excp","e":{"excp-error-code":"0x09DF5C3F","excp-source":"Client","excp-status-code":"FAILED_PRECONDITION"},"v":{"class":"clickhouse_odbc","dse-type":"DataSourceClassMissing","excp-msg":"Tableau doesn't recognize the data source type 'clickhouse_odbc'. It might not be available in this version of Tableau, or it might be a connector plugin that's not installed on this system.\n","excp-type":"ConnectivityException","is-bad-request":false,"is-capability-probe-failure":false,"is-local-configuration-error":false,"is-remote-configuration-error":false,"msg":"ConnectivityException::Init"}}
 {"ts":"2021-06-29T08:46:08.112","pid":1779,"tid":"33f2","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"connector-plugin-error","e":{"excp-error-code":"0x3834CF96","excp-source":"NeedsClassification","excp-status-code":"UNKNOWN"},"v":"Failed to validate /home/cristianc/tableau_connectors/tableau_odbc_connector"}
 {"ts":"2021-06-29T08:46:08.112","pid":1779,"tid":"33f2","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"connector-plugin","v":"Loading connector plugin /home/cristianc/tableau_connectors/tableau_odbc_connector"}
 {"ts":"2021-06-29T08:46:08.112","pid":1779,"tid":"33f2","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"connector-plugin-error","e":{"excp-error-code":"0x350ED310","excp-source":"Configuration","excp-status-code":"UNKNOWN"},"v":"Some connector plugins failed to load:"}
 {"ts":"2021-06-29T08:46:08.112","pid":1779,"tid":"33f2","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"connector-plugin-error","e":{"excp-error-code":"0x9303C451","excp-source":"Configuration","excp-status-code":"UNKNOWN"},"v":"/home/cristianc/tableau_connectors/tableau_odbc_connector failed to load"}

Thanks for letting me know if Tableau Linux Server is supported actually at all and if so if you happened to see this problem before.

All the best, Cristian

[cristianc-ty]

Update: something that worked as a workaround was to package it as a taco file and self sign it then put that to the tableau linux server and add my certificate to the allowed list.

[jorgecabrera85]

Update: something that worked as a workaround was to package it as a taco file and self sign it then put that to the tableau linux server and add my certificate to the allowed list.

Hi cristianc-ty, could you please share the steps for the workaround you mentioned?

Thanks in advance! JC

[cristianc-ty]

I followed the steps from https://tableau.github.io/connector-plugin-sdk/docs/package-sign to build a self signed taco file, added my public key to the tableau trust store with "keytool -importcert -file your_public_cert.cert -keystore /opt/tableau/tableau_server/packages/repository.20212.21.0610.0336/jre/lib/security/cacerts -alias your_alias" then placed the taco file to "/var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Connectors/clickhouse_odbc.taco" and restarted the server with "tsm restart"

[jorgecabrera85]

Thank you cristianc-ty! I will give this a try and see if it works. I will post back once I have the results.

Thanks again! jc

[dima-altinity]

@cristianc-ty @jorgecabrera85 its strange that Server was not load connector from folder directly.

Very soon this connector will be published in Tableau Gallery of TACO package and you dont need to do this workaround. Stay tuned.