PCo Multiple Destination System vs Many Agent Instances vs MII Tx

[scottp]

I'm looking for some advice on the optimal way to configure PCo to handle some fairly large notifications that are to be written to several ODBC Destination Systems.

The Data from the PLC is in the following format per output;

Header (~15 tags)

Item (~ 4 tags) 60 Items per output

Sub-Item (~ 3 tags) 20 sub-items per Item per output

The destination systems are specific DB tables for each of the above, so a single output from the machine should result in 1 insert to the Header table, 60 inserts to the Item table and 1200 inserts to the Sub-Item table.

We also need to reset the trigger tag after the process is completed.

For similar scenarios where we have less instances of the Item or Sub-Item I have been using Multiple Call Destination Systems to provide a single Notification Destination and Responce that can be used to reset the trigger tag on completion. Largest so far has 103 'steps' and is working OK based on some poor test data.

The scenario above would mean 1261 steps and probably take me several days to configure as PCo isn't exactly fast to add steps and configure (even if you edit the config XML and upload)

If I switched to creating a Notification per Item, I could reuse a muiltiple call destination system per Item but would then have 61 notifications and need to reset the trigger tag after all 61 notificaitons had fully processed - this is something I don't know how to achieve (if it is possible).

The last option I can think of is to send all of tags in a single notification to MII and build a transaction to perform the inserts. MII is running on a different network domain so there is a risk of network issues which I'm trying to minimise by using PCo as much as possible.

Can anyone suggest the optimal method to solve the above using only PCo, or should I be using MII as the machine output is too big/complex to manage in PCo?

If MII is the best option, is there a general rule for when to use PCo and when to switch to MII (e.g. max tags, number of inserts to a database, etc)?

Thanks, Scott.

[Kevin_Hunter]

Hi Scott,

I would need to understand more about the use case before I could answer the question. I will contact you via email.

Thanks

Kevin