# JDBC connection string

**URL:** <https://discuss.elastic.co/t/jdbc-connection-string/263165>\
**Category:** Beats\
**Tags:** filebeat\
**Created:** [February 3, 2021, 7:45pm UTC](https://discuss.elastic.co/t/jdbc-connection-string/263165 "2021-02-03T19:45:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![525125](https://avatars.discourse-cdn.com/v4/letter/5/7ea924/32.png) [@525125](https://discuss.elastic.co/u/525125)\
**Post date:** [February 3, 2021, 7:45pm UTC](https://discuss.elastic.co/t/jdbc-connection-string/263165/1 "2021-02-03T19:45:43Z")

</div>

Hi Team ,

We want to ingest oracle db (jdbc connection string )  
filebeat -\>logstash --\>elk--\>kibana.  
Could help us what are prerequisites for achieve this.

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [February 3, 2021, 9:18pm UTC](https://discuss.elastic.co/t/jdbc-connection-string/263165/2 "2021-02-03T21:18:10Z")

</div>

What do you want to ingest from the Oracle DB? The Oracle system logs or querying the data?

Beats is used to collect system logs from Oracle.  
Logstash is used to query the data and move to Elastic.

---

<div class="post-metadata">

**Author:** ![525125](https://avatars.discourse-cdn.com/v4/letter/5/7ea924/32.png) [@525125](https://discuss.elastic.co/u/525125)\
**Post date:** [February 4, 2021, 5:34am UTC](https://discuss.elastic.co/t/jdbc-connection-string/263165/3 "2021-02-04T05:34:22Z")

</div>

ingest oracle db

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [February 4, 2021, 1:41pm UTC](https://discuss.elastic.co/t/jdbc-connection-string/263165/4 "2021-02-04T13:41:20Z")

</div>

Then I would recommend a pipeline like Logstash -\> Elastic using the [Logstash JDBC Input](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) a [JSON Filter](https://www.elastic.co/guide/en/logstash/current/plugins-filters-json.html) for transformations, and a [Elasticsearch Output](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-elasticsearch.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:** [March 4, 2021, 3:41pm UTC](https://discuss.elastic.co/t/jdbc-connection-string/263165/5 "2021-03-04T15:41:50Z")

</div>

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