Connect an Open Distro For ElasticSearch data source to Tableau Desktop via the Tableau Connector to create a basic graph.
- Download and Install Tableau Desktop 2020 and higher
- Install and Configure Open Distro for Elasticsearch
- Download and Install Open Distro for Elasticsearch SQL ODBC driver
- Download Tableau Connector for
SQL by Open Distro for ES
(odfe_sql_odbc.taco). Click on Download option for downloadingodfe_sql_odbc.taco
file.
-
Copy
odfe_sql_odbc.taco
file to My Tableau Repository.- On windows: %User%/Documents/My Tableau Repository/Connectors/.
- On Mac: ~/Documents/My Tableau Repository/Connectors/.
-
Open Tableau using following command
<full-Tableau-path>\bin\tableau.exe -DDisableVerifyConnectorPluginSignature=true
- Click on Connect > More > SQL by Open Distro for ES.
- Enter Server & Port value.
- Select required authentication option. For AWS_SIGV4 authentication, select Integrated Authentication and enter value for Region.
- Use Additional Options section for specifying options like FetchSize, ResponseTimeout. Use
;
to separate values. For example,
FetchSize=2000;ResponseTimeout=20;
- Click on Sign In.
- You will get a list of tables when the connection is successful.
To generate a graph,
- Double click on any required table from the list and click on Update Now to load data preview.
- Data preview will be loaded.
- Click on Sheet 1. You can see a list of attributes under section Data.
- Double click on any required attributes to generate a simple graph.
- You can change visualizations by selecting any active visualization from Show Me.