How to connect Elasticsearch with Spotfire Analyst

How to connect Elasticsearch with Spotfire Analyst

book

Article ID: KB0070012

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.11 and higher

Description

Currently there is no dedicated connector option in Spotfire Analyst to connect to Elasticsearch
There is an existing enhancement request on the Spotfire Ideas Portal: https://ideas.spotfire.com/ideas/TS-I-5650

Issue/Introduction

How to connect Elasticsearch with Spotfire Analyst

Environment

All

Resolution

Below are some workarounds which can be used to connect Spotfire Analyst to Elasticsearch:

1) We can connect to Elasticsearch with Dremio connector. 
    NOTE: Dremio connector is only available in TIBCO Spotfire 10.0 and higher.

2) Another way to connect to Elasticsearch is by using the JDBC/Connector connection of TIBCO Data Virtualization(TDV). There is a dedicated adapter for Elasticsearch in the latest release of TDV (version 8.x and higher). You can publish the table(s) as a view inside TIBCO Data Virtualization and then connect to that data source using JDBC/ODBC Connector connection from Spotfire Analyst.

For more information refer the links below:
https://docs.tibco.com/pub/tdv/8.8.0/doc/pdf/TIB_tdv_8.8.0_AdapterGuide_Elasticsearch.pdf?id=82

3) If you wish to connect through the ODBC connection then you can download the Elasticsearch ODBC driver and use the generic ODBC connection in Spotfire Analyst.
    Link to download ODBC driver: https://www.elastic.co/downloads/odbc-client

4) Check the blog below for importing Elasticsearch data into Spotfire using R and a Data Function 
    Reference Link: https://capiot.com/blog/importing-elasticsearch-data-into-tibco-spotfire-using-r/