[Logstash] Oracle DB Input

Logstash - OracleDB 연동할 때 사용했던 Input 입니다.

input {
  jdbc {
    jdbc_validate_connection => true
#Path to download jdbc deriver and add in class path
    jdbc_driver_library => "/appdata/logstash/driver_library/ojdbc6.jar"
# ORACLE Driver Class
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
# ORACLE database jdbc connection string
    jdbc_connection_string => jdbc:oracle:thin:@HOSTNAME:PORT/Service
#The user and password to connect to database
    jdbc_user => "username"
    jdbc_password => "password"
#Timezone
    jdbc_default_timezone => "Asia/Seoul"
#schedule
    schedule => "0 3 * * *"
    statement => "SELECT * FROM view_table_name"
    jdbc_validation_timeout => 100000

- HOSTNAME 또는 IP Address 사용 가능

- Service 자리에는 아래와 같이 두가지 형태로 작성 가능

  1) jdbc:oracle:thin:@[호스트][:포트]:SID(DB Instance name)
  2) jdbc:oracle:thin:@//[호스트][:포트]/서비스

 둘 중 하나를 입력해야하는데 보통 위에걸로 입력함