I have to ingest the new records which are all update din database.I dont have sorted column to use last_sql_value and also timestamp column.so how can i ingest the incremental data
If you have neither a sequence nor a timestamp in your data then I don't think you can unless your database supports triggers when new values are added. But that's really a database question and not a logstash question.
how to use the database triggers?
That is very much specific to the database that you are using. In general, a trigger is a PL/SQL function that is called when a row is modified in a table. That function could execute an HTTP POST into a logstash http input (there are several other options for which input to use). I cannot give you more than a 30,000 foot overview.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.