# How to import ORACLE DB Data to Kibana (After Establishing the connection)

**URL:** <https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452>\
**Category:** Elasticsearch\
**Created:** [May 23, 2019, 1:41pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452 "2019-05-23T13:41:23Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 23, 2019, 1:41pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/1 "2019-05-23T13:41:23Z")

</div>

Hello,

I established a Oracle DB connection using Logstash. I am a complete beginner and I do not know what to do next.

I created conf file where my configuration for Oracle DB connection is written.

Localhost 9200, 9600 and 5601 are working now.

I couldn't find a way to reach my data in Kibana GUI. Am I missing a point?

My config file is

```
input {
jdbc {
    jdbc_connection_string => "jdbc:oracle:thin:@//00.100.00.0:0001/PRELIVE1"
    jdbc_user => "***"
    jdbc_password => "***"
    jdbc_driver_library => "C:\Users\Hakansu\Downloads\ojdbc6.jar"
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    statement => "SELECT * from Sales"
}
}
output {
    elasticsearch {
        index => "contacts"
        document_type => "contact"
        #document_id => "%{uid}"
        hosts => "localhost:9200"
    }
}

```

Any help is appreciated.

Best

---

<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:** [May 23, 2019, 1:55pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/2 "2019-05-23T13:55:49Z")

</div>

What are Kibana logs? What is happening when you open [http://localhost:5601](http://localhost:5601) ?

---

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 23, 2019, 2:00pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/3 "2019-05-23T14:00:03Z")

</div>

it directly goes to [http://localhost:5601/app/kibana](http://localhost:5601/app/kibana) and I cannot find where I can reach my DB data

---

<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:** [May 23, 2019, 2:12pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/4 "2019-05-23T14:12:43Z")

</div>

Could you open Dev Tools app and go to the console? [http://0.0.0.0:5601/app/kibana#/dev\_tools/console?\_g=()](http://0.0.0.0:5601/app/kibana#/dev_tools/console?_g=())

And type:

```auto
GET /_cat/indices?v

```

And share the result here? Formatted with `</>` icon or with markdown.

---

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 23, 2019, 2:16pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/5 "2019-05-23T14:16:12Z")

</div>

the result is following

```
health status index uuid pri rep docs.count docs.deleted store.size pri.store.size
green open .kibana_1 GUKFkvp_TrOZtv3gnENeBA 1 0 43 0 923.1kb 923.1kb
green open .kibana_task_manager ILKsGNgOQsePS1vT_beE5A 1 0 2 0 46.2kb 46.2kb
yellow open contacts R19ay3ytSvulXh_BElnfWg 1 1 0 0 230b 230b
green open kibana_sample_data_ecommerce 86KbNeNIQHi-NIN9BaBb2Q 1 0 4675 0 4.8mb 4.8mb
```

---

<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:** [May 23, 2019, 2:36pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/6 "2019-05-23T14:36:00Z")

</div>

Great. So you have an index named `contacts` but it is empty.

Either you created manually.  
Or Logstash created it.

If the later, then it means that Logstash did not read any "event" from the database.

I'd recommend to change the logstash output to `stdout` just to check if anything is read from the database.  
Or check logstash logs. May be something is wrong.

I wonder if this is correct:

```auto
jdbc_driver_library => "C:\Users\Hakansu\Downloads\ojdbc6.jar"

```

And should not be:

```auto
jdbc_driver_library => "C:/Users/Hakansu/Downloads/ojdbc6.jar"

```

But it might be better to ask in #logstash forum then...

---

<div class="post-metadata">

**Author:** ![boyaronur](https://avatars.discourse-cdn.com/v4/letter/b/858c86/32.png) [@boyaronur](https://discuss.elastic.co/u/boyaronur)\
**Post date:** [May 25, 2019, 11:05am UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/7 "2019-05-25T11:05:08Z")

</div>

Hello David,

Thanks a lot.

I added stdout to my conf file as you said, now the output of the `GET /_cat/indices?v` is the following

```
health status index uuid pri rep docs.count docs.deleted store.size pri.store.size
green open .kibana_1 GUKFkvp_TrOZtv3gnENeBA 1 0 43 0 923.1kb 923.1kb
green open .kibana_task_manager ILKsGNgOQsePS1vT_beE5A 1 0 2 0 13.5kb 13.5kb
green open .monitoring-kibana-7-2019.05.25 NVCHVJyFQGuM19GpVl56wQ 1 0 30 0 37.4kb 37.4kb
yellow open contacts R19ay3ytSvulXh_BElnfWg 1 1 200128 0 50.2mb 50.2mb
green open .monitoring-es-7-2019.05.25 ingGxdRWQAOaledgYp3YaA 1 0 309 182 297.6kb 297.6kb
green open kibana_sample_data_ecommerce 86KbNeNIQHi-NIN9BaBb2Q 1 0 4675 0 4.8mb 4.8mb

```

Contacts index is not empty anymore.

My problem here is that I cannot reach this data in kibana. I want to create dashboard using this data but all I can reach is the kibana\_sample\_data\_ecommerce.

How can I use this data to create a dashboard?

Thank you.

---

<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:** [May 25, 2019, 12:16pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/8 "2019-05-25T12:16:20Z")

</div>

That's another question better to ask in #kibana. But first watch some webinars, read [https://www.elastic.co/guide/en/kibana/current/getting-started.html](https://www.elastic.co/guide/en/kibana/current/getting-started.html)

---

<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:** [June 22, 2019, 12:16pm UTC](https://discuss.elastic.co/t/how-to-import-oracle-db-data-to-kibana-after-establishing-the-connection/182452/9 "2019-06-22T12:16:24Z")

</div>

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