Created on 07-17-2023 08:38 AM - edited 07-17-2023 08:41 AM
@Madhav_VD This is a job that nifi can do itself. You would just tail the log file w/ nifi TailFile.
Once you have the log file going into flowfiles in nifi, you can build your flow to filter lines you want to versus lines you do not want. Then when ready use any flavor of database processor (ExecuteSQLRecord, ExecuteSQL, PutSQL, PutDatabase, etc) to translate the log line into a sql insert statement.