How to migrate data from db oracle to ES use Logstash?

I have around 1 millions record in db oracle and I want migrate to ES.
Logstash:

input {
  jdbc {
    jdbc_driver_library => "/Users/ninhnguyen/Desktop/ojdbc7.jar"
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    jdbc_connection_string => "jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.152.10.89)(PORT = 1500))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = VNCC)))"
    jdbc_user => "USERSTORE"
    jdbc_password => "123"
    schedule => "*/1 * * * * *"
    statement => "select * from ind_view"
  }
}

output {
elasticsearch {
      hosts => ["10.159.27.117:30007"]
      index => "vnconnect_umuser"
      document_type => "vnconnect_umuser"
      document_id => "%{um_id}"
  }
}

After run bin/logstash -f sql.conf and I have check with post man response always return hits total = 10000

I don't know migrated all data to ES?

The answer is telling you that you have more than 10000 hits (gte 10000).

If you want the exact number read this page: Search your data | Elasticsearch Guide [7.15] | Elastic

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