Logstash | Inserting log files to Oracle Database

Is it possible to insert daily Apache log files to oracle database using logstash. Cans omeone please help with the code. I tried following configuration file code but i am getting an error : couldn’t find any output plugin named jdbc. I tried logstash version : 6.3.2 & 5.6.0

input
{
file
{
path => “C:\Users\ssn\logstash\Input\access.log”
start_position => “beginning”
}
}
output
{

jdbc{
jdbc_connection_string => “jdbc:oracle:thin:xyz/Helloxyz@xyz1101:PORT:1521”
statement => [ “INSERT INTO LOGS (IP_ADDRESS, USER_IDENTIFIER, USERID, REQUEST_TIME, CLIENT_REQUEST, RESPONSE_CODE, SIZEOFOBJECT, COOKIES)
VALUES(?, ? , ?, ?, ? , ?, ?, ?)”, “IP_ADDRESS”, “USER_IDENTIFIER”, “USERID”, “REQUEST_TIME”, “CLIENT_REQUEST”, “RESPONSE_CODE”, “SIZEOFOBJECT”, “COOKIES”]
}

}

Can someone please suggest a way to do this.

Thanks in advance

Hi @ssneha02,

Thanks for being part of the GitHub Community Forum! We’re glad you’re here.

I wanted to jump in here, and mention that if you don’t get the help you’re looking for from this particular community, you might want to try getting help somewhere that focuses on Logstash. It’s definitely possible another GitHub user might have run into this same issue and can help, but the GitHub Community Forum focuses primarily on topics related to GitHub itself or collaboration on project development and ideas. We want to make sure you’re getting the best support you can, but this forum may not be the right place for this particular topic.

Best of luck!