Hi,
I need to transfer Splunk extracts to Sql Server such that every record is written to Sql Server exactly one time. It doesn't need to be real time, for example, an hourly periodicity would be fine.
Currently, I am repeating the output every hour, and searching for the previous hour. This works but it is fragile and, given that Splunk may be down at times, the data saved to the database is incomplete.
We need the equivalent of a "rising column" -- Splunk should output all new records.
In SQL, I would select all records with a timestamp greater than the MAX of the previously written data.
What is the recommended approach using DB Connect V2?
Thanks,
Peter
... View more