Elasticsearch Connector on Oracle Analytics Desktop

Danny Ibars

Content

I see there is a connector to Elasticsearch.

I've provided all required fields but I always get an error message

I've tried several different Elasticsearch instances, from local to open vm reachable with curl commands but no luck

Failed to save the connection.
Error occurred while processing the query.

 

Is there any way to see connection logs to understand the running query so I can modify my connection string accordingly???

Version

Version 5.8

EzequielC-Oracle

Hi Danny,

Please, verify the Elastic Search version. It needs to be 5.6.4 or higher.

From the Supported Data Sources documentation:

https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/data-sources-and-data-types-reference.html#GUID-1DDF52B4-2AE0-4E02-8E9A-EE74D372B1A2

Regards,

Ezequiel.

Sumanth V -Oracle

Yes, you can check the Oracle Business Intelligence Server logs for the details of errors. Please refer the below document for more details on how to extract the logs.

https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/troubleshoot-visualization-issues.html#GUID-8A76A972-5E2C-45D5-B470-88ED992E1F1E

Suzanne Gill-Oracle

Here's a link to the OAS logs documentation https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/understand-diagnostic-log-files-and-log-configuration-files.html#GUID-1CA255BF-F32A-4C6E-85D6-916392249811 and ...

Desktop troubleshooting/logs documentation https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/troubleshoot-visualization-issues.html#GUID-8A76A972-5E2C-45D5-B470-88ED992E1F1E.

Good luck!