How to connect Elasticsearch with TIBCO Spotfire Analyst

How to connect Elasticsearch with TIBCO Spotfire Analyst

Currently there is no dedicated connector option in TIBCO Spotfire Analyst to connect to Elasticsearch. 
There is an existing enhancement request on TIBCO Ideas Portal: https://ideas.tibco.com/ideas/TS-I-5650 Below are some workarounds which can be used to connect TIBCO 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 TIBCO Spotfire Analyst.

For more information refer the links below:
https://www.tibco.com/press-releases/2018/tibco-data-virtualization-8-sets-standard-scalability-performance-and-workload
https://docs.tibco.com/pub/tdv/8.2.0/doc/pdf/TIB_tdv_8.2.0_Adapter_Guide.pdf (page 577).

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 TIBCO 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/