Workflow in jdbc
On the publisher channel I have mapped the idm directly to the user class. Can I make sure that all changes that occur in the informix database and are transmitted through the publisher channel first go through the workflow approval, and if the answer is yes, then add changes to idm, if negative, then do not add changes to idm?
There is no direct way, out of the box
What you can do is in the JDBC driver, catch all publisher channel events, bundle them up in some fashion and submit it to a workflow that shows the data, and if approved, the workflow makes the changes. If not, ditch the event.
It is hard to solve this super generically but not hard for a somewhat constrained use case. (Small set of objects and classes).
Something like that. Basically in the Publisher channel, Pub-command, likely, you catch a modify and read teh data and send toa PRD. The problem is, doing this in a general, works for all data, fashion is hard.
Any solution you come up with will likely be very site specific. Which is fine, but as I say a general solution is hard.