DSXchange

Hi All.

We have a requirement where we need to write a common Audit component,
This will capture the details about the interface run, like start time, end time, status, some other operational data etc.

The operational data is to be written to a Message Queue in the form of XML message and the data is to be written to queue at the end of interface.

Our interfaces are like

Sq-> Parallel -> end.

Where and how can i fit this common audit component, I know we can connect to MQ through parallel jobs, but as the sequencer is controlling the flow, is there a way i can connect to MQ through Sequence job?

Also as i need to share this across all the interfaces, shall i write it as a shared container and parameterize??

You are using the DSODB as the source right?

Yes.

s_avneet wrote:Also as i need to share this across all the interfaces, shall i write it as a shared container and parameterize??

Yes.

Your auditing would happen either after the job ends, or at a given time in the day.

Like an hourly job updating stats on your MQ...

Not sure why you have a question on the Sequencer as it will not be the entity doing the SQl extract from the DSODB tables, nor the MQ connection stage to push messages out. It could/would be the part to initiate that.

Really depends on how you want your auditing to happen.

I would recommend added a "DSODBRPT" user id with Read Only access to all of the tables. You do not want someone thinking they are smart messing with those tables with the default user id that has full access (drop even) to those tables.