Migrate from dboutput to dbxoutput

[jamesmarlowww]

How would I convert this dboutput to a dbxoutput with db connect 2?

I have had a go converting it but I haven't had any luck. I haven't been able to find any examples or any documentation on it. It would be appreciated if you could please point me in the right direction or set me straight here 🙂

The only documentation I have found is "dbxoutput output=string" but that hasn't been enough to get it going

| dboutput type=sql database=MyDB streaming=true "INSERT /+APPEND/ INTO interaction_measure_data
(log_date,interaction_name,total_count,avg_response_time)
VALUES
($log_date$,$interaction_name$,$total_count$,$avg_response_time$)"

[duartet]

Hi,

I'm migrating DB Connect v1 to v3 and I have the exact same problem. After defining the output in DB Connect, how are the previous type, database, table and streaming converted?

Regards,
Tiago

[jcoates_splunk · Accepted solution]

hi,

you need to use the UI to make the output, then call it from the command line.