Camunda Elastic Search DB integration

Hi Team,

We have configured Camunda Optimize Elastic ENV on Azure cloud and docker container, do we have any option of integrating Oracle DB with it.

Thanks
Sanjeev Kumar N

Hi @Sanjeev_kumar_N

thanks for reaching out.
If you configured Optimize and Elastic successfully, what would be the reason for integrating with Oracle DB? Currently Optimize only works on top of Elasticsearch.
Best
Felix

Thanks for the update.

Does camunda-optimize Elasticsearch uses any default database or do we need to integrate with any external DB ?

We have followed below steps for configuring Camunda BPM (Licensed) and camunda-optimize (with an embedded Elasticsearch).

For camunda BPM have created /opt/camunda dir and untared the camunda BPM “camunda-bpm-ee-tomcat-7.13.3-ee.tar” (integrated with Oracle DB)
For camunda-optimize have created /opt/camunda/camunda-optimize dir and untared the tar “camunda-optimize-3.1.0-demo.tar”
and started the respective services for both Camunda BPM and camunda-optimize “embedded Elasticsearch”

Installation Procedure for Camunda BPM

Downloaded the pre-packed distribution of enterprise edition.
Unpack the distro to a directory.
Start Camunda BPM Run by executing the start script "start.sh for Linux"
Access the Camunda webapps (Cockpit, Tasklist, Admin) via http://localhost:8080/camunda/app/.
Access the REST API via http://localhost:8080/engine-rest (e.g. http://localhost:8080/engine-rest/engine).

====== Demo Distribution with Elasticsearch ==========

Downloaded demo distribution containing Elasticsearch, we have download the archive with the latest version
and extract it to the desired folder “/opt/camunda/camunda-optimize” (have created camunda-optimize dir).
Start Optimize by running the script ./optimize-demo.sh on Azure cloud Linux VM.

======= Diretory structure ===========
camunda@devcam:/opt/camunda# ll
total 452
drwxr-xr-x 7 camunda camunda 4096 Sep 12 17:49 ./
drwxr-xr-x 4 root root 4096 Sep 12 12:48 …/
-rw-rw-r-- 1 camunda camunda 273 Jul 22 12:23 LICENSE
-rw-rw-r-- 1 camunda camunda 398506 Jul 22 12:16 LICENSE_BOOK-7.13.3-ee.txt
-rw-rw-r-- 1 camunda camunda 255 Jul 22 12:16 NOTICE
-rw-rw-r-- 1 camunda camunda 1791 Jul 22 12:16 README.txt
drwxr-x— 2 camunda camunda 4096 Aug 12 13:01 camunda-h2-dbs/
drwxrwxr-x 9 camunda camunda 4096 Sep 11 17:01 camunda-optimize/ --------------> camunda-optimize
-rw-rw-r-- 1 camunda camunda 301 Aug 12 13:01 camunda.log
drwxrwxr-x 2 camunda camunda 4096 Sep 12 13:28 lib/
drwxrwxr-x 3 camunda camunda 4096 Aug 12 12:57 server/
-rw-rw-r-- 1 camunda camunda 120 Jul 22 12:16 shutdown-camunda.bat
-rwxr-xr-x 1 camunda camunda 149 Jul 22 12:16 shutdown-camunda.sh*
drwxrwxr-x 5 camunda camunda 4096 Aug 12 12:57 sql/
-rw-rw-r-- 1 camunda camunda 275 Jul 22 12:16 start-camunda.bat
-rwxr-xr-x 1 camunda camunda 944 Jul 22 12:16 start-camunda.sh*

We are able to access the links

Camunda BPM:
http://localhost:8080/camunda/app/.
REST API via http://localhost:8080/engine-rest/engine

Camunda-optimize
http://localhost:8090

Refered link:
https://docs.camunda.org/enterprise/download/ Camunda BPM Download
https://docs.camunda.org/enterprise/download/#camunda-optimize camunda-optimize Download
https://docs.camunda.org/optimize/2.3/technical-guide/setup/installation/ For installation

Thanks
Sanjeev