OpenSearch | Tableau Exchange

OpenSearch

by Amazon

Description

OpenSearch is a scalable, flexible and extensible open-source software suite for search, analytics and observability applications licensed under Apache 2.0. Powered by Apache Lucene and driven by the OpenSearch Project community, OpenSearch offers a vendor-agnostic toolset you can use to build secure, high-performance, cost-efficient applications. Use OpenSearch as an end-to-end solution or connect it with your preferred open-source tools or partner projects.

Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries, etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualisation. Please check our documentation for more details.

Installation

  1. Download the Connector file (.taco) from https://github.com/opensearch-project/sql-jdbc/blob/main/bi-connectors/TableauConnector/README.md.
  2. Move the .taco file here:
    • Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
    • macOS: /Users/[user]/Documents/My Tableau Repository/Connectors
  3. Start Tableau and under Connect, select the OpenSearch connector. (Note: You’ll be prompted if the driver is not yet installed.
  4. OpenSearch Driver Installation:
    • Go to the Driver Download page.
    • Download the OpenSearch JDBC .jar file and move into the following directory:
      • Windows: C:\Program Files\Tableau\Drivers
      • macOS: /Users/[user]/Library/Tableau/Drivers
  5. Relaunch Tableau and connect using the OpenSearch connector.

Tech Specifications

Version
1.0.1
Works with
Tableau 2021.1 and later

Resources