# Connect oracle to elastic / kibana

**URL:** <https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436>\
**Category:** Elasticsearch\
**Created:** [July 14, 2023, 7:06pm UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436 "2023-07-14T19:06:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oytoch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oytoch/32/123458_2.png) [@Oytoch](https://discuss.elastic.co/u/Oytoch)\
**Post date:** [July 14, 2023, 7:06pm UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/1 "2023-07-14T19:06:18Z")

</div>

Hi,  
I try to understand kibana / Elasticsearch to interface my oracle database in order to make dashboard with kibana ( BI)

I work with an "on premise" version

First question, is it possible to do that with kibana ?  
Second, how ? I saw connector, intégration, maybe i need enterprise version ?

Thanks you for tour help  
Thomas

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 14, 2023, 7:33pm UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/2 "2023-07-14T19:33:00Z")

</div>

Bonjour Thomas et bienvenue 😉

How the data is sent to Oracle? I guess you have an application which does that right?

If so, can you modify the application?

---

<div class="post-metadata">

**Author:** ![Oytoch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oytoch/32/123458_2.png) [@Oytoch](https://discuss.elastic.co/u/Oytoch)\
**Post date:** [July 14, 2023, 8:17pm UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/3 "2023-07-14T20:17:47Z")

</div>

Thanks David 😊

I have an ERP who uses the data base and scheduled tasks.

I can change the app, but what change ?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 14, 2023, 8:49pm UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/4 "2023-07-14T20:49:21Z")

</div>

If you can modify the app, the easiest thing to do is to send your entities in both systems: the database and Elasticsearch .

---

<div class="post-metadata">

**Author:** ![Oytoch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oytoch/32/123458_2.png) [@Oytoch](https://discuss.elastic.co/u/Oytoch)\
**Post date:** [July 15, 2023, 11:15am UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/5 "2023-07-15T11:15:34Z")

</div>

So if i understand, I cant directly synchronise my db with elastic using something like a connector ?

I imagine that Elastic is not made to extract data from a database to make indicators with kibana.

In your website I saw this tutorial david.pilato.\*r/blog/2015-05-09-advanced-search-for-your-legacy-application/ (replace \* by f)  
Maybe i need ton add an ETL ?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 17, 2023, 9:03am UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/6 "2023-07-17T09:03:53Z")

</div>

> [@Oytoch](#):
>
> So if i understand, I cant directly synchronise my db with elastic using something like a connector ?

I don't see a direct connector for Oracle in our [official connectors page](https://www.elastic.co/guide/en/enterprise-search/current/connectors.html). But there is something related: [Elastic Oracle connector reference | Enterprise Search documentation [8.11] | Elastic](https://www.elastic.co/guide/en/enterprise-search/current/connectors-oracle.html)

> Maybe i need ton add an ETL ?

You can use Logstash. See this: [Synchroniser Elasticsearch avec un SGBDR grâce à Logstash et JDBC | Elastic Blog](https://www.elastic.co/fr/blog/how-to-keep-elasticsearch-synchronized-with-a-relational-database-using-logstash)

> In your website I saw this tutorial: [Advanced search for your Legacy application - David Pilato](http://david.pilato.fr/blog/2015-05-09-advanced-search-for-your-legacy-application/)

In this article I'm showing what I recommended: modify the application so it's much easier IMO and real time.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 14, 2023, 9:04am UTC](https://discuss.elastic.co/t/connect-oracle-to-elastic-kibana/338436/7 "2023-08-14T09:04:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
