 Introduction to MSSQL for
FactoryTalk Metrics
 Create a FactoryTalk Metrics
Database and User
 Configure a System DSN
 Install FactoryTalk Metrics
 Administrating FactoryTalk
 Create FactoryTalk Metrics Plant
 Configure FactoryTalk Metrics
 Configure FactoryTalk Metrics
Workcell Schedules
 Configure FactoryTalk Metrics
 Configure FactoryTalk Metrics
Performance Parameter Events
 Configure FactoryTalk Metrics
Fault Metrics
 Create FactoryTalk Metrics
Reports and Filters
 Use FactoryTalk Metrics
 Using Report Expert
Course Purpose
FactoryTalk® Metrics is a complete, windows-based solution for the analysis of
time-series process and production data. FactoryTalk Metrics provides a set of
tools to analyze the performance of production assets. FactoryTalk Metrics
provides a performance rating, based on the widely used Overall Equipment
Effectiveness (OEE) model, for every production asset. The OEE metric
provides a simple way to quickly determine if a production asset is performing
In this course, you’ll learn to use the reporting, graphing, and querying
functionality that make FactoryTalk a complete and very easy-to-use solution
for data collection and analysis.
Metrics Configuration Course Description
GMST10-PP668A-EN-E Copyright ©2014 Rockwell Automation, Inc. All Rights Reserved. Printed in USA.
Who Should Attend
This course is intended for engineers, and plant managers
who need to collect PLC data, and analyze and report that
A familiarity with the Windows Server 2008 user
interface and a basic understanding of Allen-Bradley PLC
processors is required. We also recommend knowledge of
basic client/server database concepts. A familiarity with
basic networking concepts is also strongly recommended.
Knowledge or experience with Microsoft SQL Server is
also helpful.
Technology Requirements
All technology is provided for student use in the
classroom by Rockwell Automation. It is not necessary
for students to bring any technology with them when
attending this course.
Student Materials
To enhance and facilitate your learning experience, the
following materials are provided as part of the course
 Student Manual, which contains the key concepts,
definitions, and examples presented in the course and
includes the hands-on exercises.
Course Length
This is a three-day course.
Course Number
The course number is FTM.
To Register
To register for this or any other Rockwell Automation
training course, contact your local authorized AllenBradley
Distributor or your local Sales/Support office for
a complete listing of courses, descriptions, prices, and
You can also access course information via the Web at
All trademarks and registered trademarks are property of their respective

We’re Here to Help

Please enter your question below—or call us toll-free at 866-483-7289. To make sure we get your request or information to the right person, please include the nature of your issue or concern. If you’d like us to contact you, we’ll make every attempt to reach you within two business days.


Log in with your credentials

Forgot your details?