I am using DB Connect v2, talking to a MySql database. When I configure the "DB Output operation", in the step "Map the Splunk Fields to Table Columns", there is a checkbox called UPSERT, which is excellent! However, I am asked to pick to one field which is the Unique Key. However, my table has a composite key (composed of 3 fields).
Does DB Connect v2 "DB Output" support composite key when I use UPSERT?
I would rather create another filed with concatenated value of 3 fields as Unique Key and use that for the upsert. Using this approach needs another database column needs to be created, we can also store the individual column values using "Splunk Fields to Table Columns"