Rockwell Automation FactoryTalk Transaction Manager User Guide - Manual (Page 97)

7
●
Creating Transactions
●
●
●
●
●
97
Unidirectional Transactions
Unidirectional transactions in FactoryTalk Transaction Manager use
information from the control system to add records to a database table,
update the contents of existing records, or call stored procedures that do not
contain output parameters.
Unidirectional transactions are commonly used to log production data to a
database, including:
 Performance monitoring.
 Quality analysis sampling.
 Real-time production information collecting.
 Material consumption tracking.
 Product tracking.
 End of job/batch/shift reporting.
Unidirectional transactions are the simplest transaction type. They can be
used to perform database Insert or Update commands. They can also be used
to perform simple stored procedures, provided no output parameters or
return codes exist. In most applications, unidirectional transactions account
for the majority of transaction volume. Data may be collected frequently
from a large number of data points.
Bidirectional Transactions
Bidirectional transactions in FactoryTalk Transaction Manager take data
from the control system and call a stored procedure that exercises some
logic, and then provides the software with output values that can be written
back to the control system. You can also set up bidirectional transactions so
that data is not sent to a database, but only downloaded from a database to a
control system.
This transaction type is the most powerful because it allows transactions to
interact with a database stored procedure or Microsoft COM+ method. This
capability makes it possible for FactoryTalk Transaction Manager to