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

Appendix A
143
FactoryTalk Transaction Manager Sample
Applications
External Trigger Sample Application
The External Trigger sample application illustrates how an external
application can trigger a FactoryTalk Transaction Manager transaction. Use
external triggering to create a custom user interface to the FactoryTalk
Transaction Manager application or to integrate FactoryTalk Transaction
Manager functionality into an existing software system.
The Extras directory on the FactoryTalk Transaction Manager product CD
contains the External Trigger sample application discussed in this appendix.
Contents
The example application contains the following elements:
 A Microsoft Excel spreadsheet named ExternalTriggerSample.xls. The
integer number in cell A1 is the data point that is sent to the database.
 A Microsoft SQL database with a table named ExternalTriggerSample
that contains three columns: ExternalTriggerDatabaseID (an
Autonumber field), ExcelValue, and a timestamp.
 A FactoryTalk Transaction Manager configuration that contains a
single unidirectional transaction named ExternalTriggerTransaction.
This transaction obtains a data value from cell A1 in an Excel
spreadsheet and appends a record named ExternalTriggerSample in the
Microsoft SQL database. The transaction is defined so that it can be
triggered by an external application.