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=823) 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-client4) 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/