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

[Björn]

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

[Heinvandenheuvel · Accepted solution]

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.

[Björn]

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

Cheers,
Björn