# Loading Oracle into Elastic with Logstash

**URL:** <https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957>\
**Category:** Logstash\
**Created:** [July 28, 2020, 5:49pm UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957 "2020-07-28T17:49:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Queyon](https://avatars.discourse-cdn.com/v4/letter/q/4af34b/32.png) [@Queyon](https://discuss.elastic.co/u/Queyon)\
**Post date:** [July 28, 2020, 5:49pm UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957/1 "2020-07-28T17:49:36Z")

</div>

I'm trying to load Oracle data into Elastic with Logstash.  
The query returns a number of rows, but it only loaded one record into Elastic.  
Is there anything wrong with my config file?

input {  
jdbc {  
jdbc\_driver\_library =\> "C:\jdbc\lib\ojdbc8.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@hostname:port:SID"  
jdbc\_user =\> "my\_user"  
jdbc\_password =\> "my\_password"  
statement =\> "SELECT \* FROM MY\_TABLE"  
}  
}  
output {  
elasticsearch {  
index =\> "my\_index"  
document\_id =\> "%{table\_id}"  
hosts =\> "hostname:9200"  
}  
}

---

<div class="post-metadata">

**Author:** ![kelk](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kelk](https://discuss.elastic.co/u/kelk)\
**Post date:** [July 28, 2020, 8:31pm UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957/2 "2020-07-28T20:31:32Z")

</div>

Try putting the [tracking column](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) too..

```auto
input {
  jdbc {
    statement => "SELECT * FROM MY_TABLE"
    use_column_value => true
    tracking_column_type => "numeric"
    tracking_column => "some_primary_key_or_sequence"
    last_run_metadata_path => "/elastic/tmp/testing/confs/test-jdbc-int-sql_last_value.yml"
    # ... other configuration bits
  }
}

```

---

<div class="post-metadata">

**Author:** ![Queyon](https://avatars.discourse-cdn.com/v4/letter/q/4af34b/32.png) [@Queyon](https://discuss.elastic.co/u/Queyon)\
**Post date:** [July 28, 2020, 9:46pm UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957/3 "2020-07-28T21:46:15Z")

</div>

Still only one record was loaded.  
But thanks for your reply.

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [July 28, 2020, 9:57pm UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957/4 "2020-07-28T21:57:34Z")

</div>

> [@Queyon](#):
>
> document\_id =\> "%{table\_id}"

If every document has the same [table\_id] field this will keep overwriting the document and you will only have one document in elasticsearch.

---

<div class="post-metadata">

**Author:** ![Queyon](https://avatars.discourse-cdn.com/v4/letter/q/4af34b/32.png) [@Queyon](https://discuss.elastic.co/u/Queyon)\
**Post date:** [July 29, 2020, 12:02am UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957/5 "2020-07-29T00:02:13Z")

</div>

You get the point!  
Thanks. It works well now.

---

<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 26, 2020, 12:02am UTC](https://discuss.elastic.co/t/loading-oracle-into-elastic-with-logstash/242957/6 "2020-08-26T00:02:18Z")

</div>

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