| sidebar_label | slug | keywords | description | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
Tableau Online |
/en/integrations/tableau-online |
|
Tableau Online streamlines the power of data to make people faster and more confident decision makers from anywhere. |
import MySQLCloudSetup from '@site/docs/en/_snippets/_clickhouse_mysql_cloud_setup.mdx'; import MySQLOnPremiseSetup from '@site/docs/en/_snippets/_clickhouse_mysql_on_premise_setup.mdx';
Tableau Online can connect to ClickHouse Cloud or on-premise ClickHouse setup via MySQL interface using the official MySQL data source.
Login to your Tableau Cloud site and add a new Published Data Source.
<img src={require('./images/tableau_online_01.png').default} class="image" alt="Creating a new published data source" style={{width: '75%', 'background-color': 'transparent'}}/>
Select "MySQL" from the list of available connectors.
<img src={require('./images/tableau_online_02.png').default} class="image" alt="Selecting MySQL connector" style={{width: '75%', 'background-color': 'transparent'}}/>
Specify your connection details gathered during the ClickHouse setup.
<img src={require('./images/tableau_online_03.png').default} class="image" alt="Specifying your connection details" style={{width: '75%', 'background-color': 'transparent'}}/>
Tableau Online will introspect the database and provide a list of available tables. Drag the desired table to the canvas on the right. Additionally, you can click "Update Now" to preview the data, as well as fine-tune the introspected field types or names.
<img src={require('./images/tableau_online_04.png').default} class="image" alt="Selecting the tables to use" style={{width: '75%', 'background-color': 'transparent'}}/>
After that, all that remains is to click "Publish As" in the top right corner, and you should be able to use a newly created dataset in Tableau Online as usual.
NB: if you want to use Tableau Online in combination with Tableau Desktop and share ClickHouse datasets between them, make sure you use Tableau Desktop with the default MySQL connector as well, following the setup guide that is displayed here if you select MySQL from the Data Source drop-down. If you have an M1 Mac, check this troubleshooting thread for a driver installation workaround.
As it is not possible to provide the SSL certificates via the Tableau Online MySQL connection setup wizard, the only way is to use Tableau Desktop to set the connection up, and then export it to Tableau Online. This process is, however, pretty straightforward.
Run Tableau Desktop on a Windows or Mac machine, and select "Connect" -> "To a Server" -> "MySQL". Likely, it will be required to install the MySQL driver on your machine first. You can do that by following the setup guide that is displayed here if you select MySQL from the Data Source drop-down. If you have an M1 Mac, check this troubleshooting thread for a driver installation workaround.
<img src={require('./images/tableau_desktop_01.png').default} class="image" alt="Create a new data source" style={{width: '75%', 'background-color': 'transparent'}}/>
:::note In the MySQL connection setup UI, make sure that the "SSL" option is enabled. ClickHouse Cloud's SSL certificate is signed by LetsEncrypt. You can download this root cert here. :::
Provide your ClickHouse Cloud instance MySQL user credentials and the path to the downloaded root certificate.
<img src={require('./images/tableau_desktop_02.png').default} class="image" alt="Specifying your credentials" style={{width: '50%', 'background-color': 'transparent'}}/>
Choose the desired tables as usual (similarly to Tableau Online), and select "Server" -> "Publish Data Source" -> Tableau Cloud.
<img src={require('./images/tableau_desktop_03.png').default} class="image" alt="Publish data source" style={{width: '75%', 'background-color': 'transparent'}}/>
IMPORTANT: you need to select "Embedded password" in "Authentication" options.
<img src={require('./images/tableau_desktop_04.png').default} class="image" alt="Data source publishing settings - embedding your credentials" style={{width: '50%', 'background-color': 'transparent'}}/>
Additionally, choose "Update workbook to use the published data source".
<img src={require('./images/tableau_desktop_05.png').default} class="image" alt="Data source publishing settings - updating the workbook for online usage" style={{width: '50%', 'background-color': 'transparent'}}/>
Finally, click "Publish", and your datasource with embedded credentials will be opened automatically in Tableau Online.
All the known limitations has been fixed in ClickHouse 23.11. If you encounter any other incompatibilities, please do not hesitate to contact us or create a new issue.