All Apps and Add-ons
Highlighted

Migrate from dboutput to dbxoutput

Path Finder

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 interactionmeasuredata
(logdate,interactionname,totalcount,avgresponsetime)
VALUES
($log
date$,$interactionname$,$totalcount$,$avgresponsetime$)"

Highlighted

Re: Migrate from dboutput to dbxoutput

Champion

hi,

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

View solution in original post

Highlighted

Re: Migrate from dboutput to dbxoutput

Path Finder

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

0 Karma