Hi,
On the ChangeLogColumn, this apparently has to be added to the
particular table to which the connector binds. And, the 'syncope' user
will need write access to the table. (I'm guessing, so let me know if
I'm way off the path on these.)
If so, is a particular data type required or preferred? Based on the [1]
detail: "Name of the column where the last update-related,
non-decreasing, value is stored. This value can be a number or a
timestamp value", Syncope just needs to stash a monotonically increasing
value for each row. Possibly any of INTEGER, NUMERIC or TIMESTAMP
generic SQL types should work. Is there any reason to pick one over the
others?
Also, do any of the synchronizations use resource-specific logging
features such as are used for replication? Most SQL servers, AD, OpenDJ
and probably others have these. (They can be devilishly
version-specific, which makes for operational trouble.)
[1] https://connid.atlassian.net/wiki/display/BASE/Database+Table
Thanks,
Edward
