Hi Team,
Here is my scenario,
I am currently doing POC to read error records from oracle Database tables and pumping to ElasticSearch - DataLens.
I am using Logstash-5.6.3 currently, Added the JDBC Input plugins, Able to connect DB and read records. Tried output plugin to write into file(Json). It works fine.
My object is to pump the records to Elastic Search - DataLens.
I am currently blocked in Output plugin configuration because of HTTP API key. I am unable to get the correct output configuration for HTTP API key.
HTTP API key is something like this: “_df3fdgs43grh3f5f3sh343gggggsadf"
My logstash Config file is,
input {
jdbc {
jdbc_connection_string => "jdbc:oracle:thin:@"
jdbc_driver_library => "/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_validate_connection => true
schedule => "* * * * *"
jdbc_user => "DBusername"
jdbc_password => "DBPassword"
statement => "SELECT * from DBTable"
}
}
output {
elasticsearch {
hosts => "https://in.datalens.host:port/nonprod/elasticsearch/merchgroup-MuthuTest-logs"
manage_template => false
x-api-key => “_df3fdgs43grh3f5f3sh343gggggsadf"
}
stdout { }
}
Could you anyone help me in finding the configuration?
Thanks,
Muthu