FactoryTalk Transaction Manager User Guide

1 user Guide rockwell automation Publication RSSQL-UM001I-EN-P-June 2014 Supersedes Publication RSSQL-UM001H-EN-P-April 2011 Customer Support Telephone Online Support 2014 rockwell automation Technologies, Inc. All Rights Reserved. This document and any accompanying rockwell Software products are copyrighted by rockwell automation , Inc. Any reproduction and/or distribution without prior written consent from rockwell automation , Inc. is strictly prohibited. Please refer to the license agreement for details. FactoryTalk , FactoryTalk Activation, FactoryTalk Diagnostics, FactoryTalk Directory, FactoryTalk Live Data, FactoryTalk Metrics, FactoryTalk Services Platform, FactoryTalk Transaction Manager , FactoryTalk VantagePoint, FactoryTalk ProductionCentre, Report Expert, rockwell , rockwell automation , rockwell Software, and RSBizWare are trademarks of rockwell automation , Inc.

2 Any rockwell automation logo, software or hardware not mentioned herein is also a trademark, registered or otherwise, of rockwell automation , Inc. For a complete list of products and their respective trademarks, go to #/tab4. ActiveX, Microsoft, Microsoft Access, SQL Server, Visual Basic, Visual C++, Visual SourceSafe, Windows, Windows ME, Windows NT, Windows 2000, Windows Server, Windows XP, Windows 7, Windows Vista, and Windows 8 are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Adobe, Acrobat, and Reader are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.

3 ControlNet is a registered trademark of ControlNet International. DeviceNet is a trademark of the Open DeviceNet Vendor Association, Inc. (ODVA) OLE for Process Control (OPC) is a registered trademark of the OPC Foundation. Oracle, SQL*Net, and SQL*Plus are registered trademarks of Oracle Corporation. All other trademarks are the property of their respective holders and are hereby acknowledged. This product is warranted in accordance with the product license. The product s performance may be affected by system configuration, the application being performed, operator control, maintenance, and other related factors.

4 rockwell automation is not responsible for these intervening factors. The instructions in this document do not cover all the details or variations in the equipment, procedure, or process described, nor do they provide directions for meeting every possible contingency during installation, operation, or maintenance. This product s implementation may vary among users. This document is current as of the time of release of the product; however, the accompanying software may have changed since the release. rockwell automation , Inc. reserves the right to change any information contained in this document or the software at any time without prior notice.

5 It is your responsibility to obtain the most current information available from rockwell when installing or using this product. Contacting rockwell Copyright Notice Trademark Notices Other Trademarks Warranty rockwell automation Publication RSSQL-UM001I-EN-P-June 2014 3 Table of Contents Chapter 1 What Is FactoryTalk Transaction Manager ? .. 11 What Can FactoryTalk Transaction Manager Do For Me? .. 12 Understanding FactoryTalk Transaction Manager Concepts .. 13 Transaction Control Manager Service .. 13 FactoryTalk Transaction Manager Service and Control Connectors .. 14 Control Connectors .. 15 Enterprise Connectors.

6 16 Configuration Server .. 16 transactions .. 16 FactoryTalk .. 17 FactoryTalk Services Platform Components .. 17 Intended Audience .. 19 Where Can I Go for Help? .. 19 Chapter 2 Installing and Activating FactoryTalk Transaction Manager .. 21 Distributed Installations .. 21 Chapter 3 Starting FactoryTalk Transaction 23 Exploring the FactoryTalk Transaction Manager user Interface .. 23 Title Bar .. 25 Menu Bar .. 25 Toolbar .. 26 Configuration Tree .. 27 Configuration and Connector Status .. 28 Configuration Server Status .. 29 Workspace .. 30 Transaction States .. 30 Status Bar .. 31 Configuration Checklist.

7 31 Step 1: Defining and Naming a New Configuration .. 33 Step 2: Defining 34 Step 3: Defining Data Points .. 35 Welcome To FactoryTalk Transaction Manager Getting Started Exploring the FactoryTalk Transaction Manager user Interface Table of Contents 4 rockwell automation Publication RSSQL-UM001I-EN-P-June 2014 Step 4: Defining Data Objects .. 35 Step 5: Defining transactions .. 36 Step 6: Verifying transactions .. 37 Miscellaneous .. 37 Viewing Configuration Properties .. 38 Starting Configurations .. 38 Stopping Configurations .. 40 Starting and Stopping Connectors .. 40 Monitoring Configurations.

8 40 Understanding FactoryTalk Transaction Manager External Files .. 41 Using the Service Console .. 42 Chapter 4 Introducing FactoryTalk Transaction Manager Services .. 45 Control Connectors .. 46 FactoryTalk Live Data .. 46 DDE .. 47 RSLinx Classic OPC .. 47 RSView32 .. 48 Generic OPC .. 48 Enterprise Database Connectors .. 49 Microsoft OLE DB .. 49 ODBC .. 50 Oracle OCI .. 50 Enterprise Application Connectors .. 50 Microsoft COM+ .. 51 Time-series Data Compression .. 51 FactoryTalk Metrics .. 51 Enterprise Connector Options .. 51 FactoryTalk Transaction Manager Service .. 52 Transaction Control Manager Service.

9 53 Configuration Server .. 53 Chapter 5 Introducing Data Points .. 55 FactoryTalk Live Data Data Points .. 57 Selecting a Collection Mode .. 58 Understanding FactoryTalk Transaction Manager Services Defining Data Points Table of Contents rockwell automation Publication RSSQL-UM001I-EN-P-June 2014 5 Scheduled: Maintain the Current Subscribed Value .. 58 Device Scheduled: Request the Current Value From the Device .. 58 Unscheduled: Send Subscribed Value Whenever It Changes 59 Consecutive Data Point and Data Block Support .. 59 Selecting Timeout Properties .. 60 Data Valid .. 60 Data Retrieval Timeout.

10 61 Selecting a Substitution Option .. 62 Preventing Stale and Mismatched Data .. 63 Specifying Quality .. 63 OPC Data Points .. 64 RSLinx Classic OPC Data Points .. 65 Generic OPC Data Points .. 65 RSView32 Data Points .. 65 DDE Data Points .. 66 Chapter 6 Introducing Data Objects .. 67 Enterprise Database Objects .. 68 Oracle Call Interface (OCI) Data Objects .. 69 Microsoft SQL Server Data 69 ODBC Data Objects .. 69 Enterprise Application 70 Microsoft COM+ Data Objects .. 70 FactoryTalk Metrics Data Objects .. 70 Enterprise Connector Error 70 Inserting and Updating Data Table Records .. 72 Stored Procedures.