Workflow in jdbc

[Lexon171]

Hello! I have a jdbc driver that is linked to a database informix. On the subscriber channel, changes are written to the database using a stored procedure that I call from the driver.
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?

[geoffc]

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).

[Lexon171]

Did I understand correctly what to configure so that the jdbc driver writes changes not to the user class, but to some other class. Start workflow with this class. And if the changes are accepted, then write to the user class.

[geoffc]

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.

[Lexon171]

Today I noticed that there is an action "start wotkflow" in the publisher channel policies. In this activity, I can send mutable attributes and use workflow. Haven't tried this method yet, but most likely this is what you need. I can not figure out what to write in "inter recipient dn"

[geoffc]

Start Workflow i s available pretty much everywhere in Policy. 

I am not quite sure what you are suggesting now?