Elasticsearch or Opensearch

Question

Hi,

Can I use (connect as datasource or dataflow) Elasticsearch or Opensearch in OAC?

Thanks

User10862057-Oracle · Answer

Thanks your answer, but I can't configure the REST API, I have tried about 30 different way without success. Is anybody connected OAC to Elasticsearch/Opensearch yet?

Gianni Ceresa · Answer

The best answer for what data source exists, is usually in the doc:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/listed-supported-data-sources-oracle-analytics-cloud.html

And if you don't find yours, then you need to look for "indirect" connections via APIs or other forms of integration, as Brendan pointed out.

Brendan T · Answer

Most data sources can be be used. It's a matter of how to connect to them. Try using DataFlow or JDBC connector or a REST API. One of those options should work for you.