tableau-desktop.asciidoc 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. [role="xpack"]
  2. [testenv="platinum"]
  3. [[sql-client-apps-tableau-desktop]]
  4. === Tableau Desktop
  5. Use the {es} JDBC driver and dedicated {es} Tableau Connector to access {es} data from Tableau Desktop.
  6. IMPORTANT: Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this
  7. product, please reach out to its vendor.
  8. [[sql-client-apps-tableau-desktop-prereqs]]
  9. ==== Prerequisites
  10. * https://www.tableau.com/products/desktop[Tableau Desktop] 2019.4 or later
  11. * {es-sql} <<sql-jdbc, JDBC driver>>
  12. * https://www.elastic.co/downloads/tableau-connector[{es} Connector for Tableau]
  13. [[sql-client-apps-tableau-desktop-load-data]]
  14. ==== Load data
  15. First, move or download the JDBC driver to the Tableau Desktop drivers directory:
  16. * Windows: `C:\Program Files\Tableau\Drivers`
  17. * Mac: `/Users/[user]/Library/Tableau/Drivers`
  18. Move the {es} Connector for Tableau to the Tableau Desktop connectors directory:
  19. * Windows: `C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors`
  20. * Mac: `/Users/[user]/Documents/My Tableau Repository/Connectors`
  21. Launch Tableau Desktop. In the menu, click **More...** and select **Elasticsearch by Elastic** as the data source.
  22. [[apps_tableau_desktop_from_connector]]
  23. [role="screenshot"]
  24. image:images/sql/client-apps/apps_tableau_desktop_from_connector.png[Select Elasticsearch by Elastic as the data source]
  25. In the **New connection** modal, enter the information for your {es} instance, and click **Sign In**.
  26. [[apps_tableau_connect]]
  27. [role="screenshot"]
  28. image:images/sql/client-apps/apps_tableau_desktop_connect.png[Sign in]
  29. In the main window, select your {es} instance as the **Database**. Then select a table to load.
  30. [[apps_tableau_prepare]]
  31. [role="screenshot"]
  32. image:images/sql/client-apps/apps_tableau_desktop_prepare.png[Select a table to load]
  33. Finally, generate a report.
  34. [[apps_tableau_report]]
  35. [role="screenshot"]
  36. image:images/sql/client-apps/apps_tableau_desktop_report.png[Generate a report]