topic Store Changes Setting - possible to add DB User Account that initiated the change? in Qlik Replicate

Store Changes Setting - possible to add DB User Account that initiated the change?

Björn — Wed, 02 Feb 2022 08:34:16 GMT

Hello,

we are replicating an Oracle DB and do have a question about the Store Changes Setting.

Is there a hidden setting that would enable to add the user that initiated the change into the change table for every change in the database (update, delete, add, ...)? Or could we place this as feature request somewhere 😉

Best,
Björn

Re: Store Changes Setting - possible to add DB User Account that initiated the change?

Heinvandenheuvel — Wed, 02 Feb 2022 15:20:29 GMT

There is no hidden setting, only a well documented method to add a username column to a target table.

In the task design; double click on the targeted table; transform; add column; Fx; Headers; AR_H_USER.

In the documentation search for AR_H_USER:

"AR_H_USER The user name, ID or any other information that the source provides about the Change initiator.
This header is supported on the Microsoft SQL Server, IBM DB2 on iSeries (ARC), and Oracle (version 11.2.0.3
and higher) source endpoints only." - so you are in luck with the Oracle source.

Hein.

Re: Store Changes Setting - possible to add DB User Account that initiated the change?

Björn — Wed, 02 Feb 2022 16:27:02 GMT

Hello,
thanks for the pointer to the documentation and the explanation. I think that's what we need.

Cheers,
Björn