Inst ToolsInst ToolsInst Tools
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Search
  • Books
  • Software
  • Projects
  • Process
  • Tools
  • Basics
  • Formula
  • Power Plant
  • Root Cause Analysis
  • Electrical Basics
  • Animation
  • Standards
  • 4-20 mA Course
  • Siemens PLC Course
Reading: FactoryTalk Studio and SQL Server for Data Logging
Share
Notification Show More
Font ResizerAa
Inst ToolsInst Tools
Font ResizerAa
  • Courses
  • Design
  • PLC
  • Interview
  • Control System
Search
  • Courses
  • Automation
    • PLC
    • Control System
    • Safety System
    • Communication
    • Fire & Gas System
  • Instrumentation
    • Design
    • Pressure
    • Temperature
    • Flow
    • Level
    • Vibration
    • Analyzer
    • Control Valve
    • Switch
    • Calibration
    • Erection & Commissioning
  • Interview
    • Instrumentation
    • Electrical
    • Electronics
    • Practical
  • Q&A
    • Instrumentation
    • Control System
    • Electrical
    • Electronics
    • Analog Electronics
    • Digital Electronics
    • Power Electronics
    • Microprocessor
  • Request
Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Inst Tools > Blog > PLC Tutorials > FactoryTalk Studio and SQL Server for Data Logging

FactoryTalk Studio and SQL Server for Data Logging

Step-by-step guide to connect FactoryTalk Studio and SQL Server for effective data logging in your SCADA platform.

Last updated: March 16, 2025 6:53 pm
Viral Nagda
PLC Tutorials
No Comments
Share
6 Min Read
SHARE

When you are working on a SCADA platform, you are mostly required to log data in a database for control and monitoring purposes. Without database linking, there is no point in buying such expensive SCADA systems. In today’s times, if you have data of the whole plant every minute, then you will be able to adaptly control your factory operation swiftly. One such SCADA system used widely is FactoryTalk View Studio of Rockwell Automation. In this post, we will see how to link FactoryTalk View Studio Site Edition with the SQL server for data logging.

FactoryTalk Studio and SQL Server for Data Logging

You will require the below software to do this step:

  1. FactoryTalk View Studio Site Edition (any latest version or usually more than 12.0 as preferred)
  2. Microsoft SQL Server
  3. ODBC Data Sources

Now, let us start this linking process seeing everything step by step:

  1.  The very first step is to install an SQL server and keep it ready with an instance. For security purposes, use SQL server authentication, which requires entering a username and password. We will use this authentication only for further activities. Remember to save the credentials in the SQL server, once it has been entered.
  2. In SQL Server, create a database named REPORT. In that database, create three tables – FloatTable, StringTable, and TagTable. This step ensures that your SQL server configuration is complete. Refer to the below image for creating columns inside each of these tables:
FactoryTalk Studio and SQL Server for Data Logging
Float Table
FactoryTalk View Studio Site Edition
String Table
FactoryTalk View SE Data logging in MS-SQL
Tag Table
  1. Next, we will configure the SCADA program. In the FTV Studio SE, in the data log model, create a model named REPORT. In this data model, there are five tabs – setup, paths, file management, log triggers, and tags in the model.  Refer to the below image for more details.
Data logging and reporting in FTView SE
  1. Let us see the first tab – setup. This tab is used to connect to an ODBC data source and provide SQL authentication credentials. Refer to the below image. Here, you need to first define an ODBC data source. The steps are –

A] After clicking the box near the ODBC data source, go to the system data source.

B] Click new.

C] Click system data source and hit next.

D] Click SQL server and hit finish.

E] Write the name as REPORT, assign the server path of your PC, and hit next.

F] Click with SQL server authentication and enter your SQL server credentials.

G] Click change the default database to REPORT (the one you created in SQL earlier) and hit next.

H] Click Finish.

I] Once done, your ODBC data source has been created. You can test the source after clicking finish by clicking the test data source button. Now, assign this source in the field of ODBC data source in the image shown. Assign a tag table, float table, and string table, which will show when you click their corresponding boxes (will be created once your ODBC has been linked). 

J] Tick login required and enter your user ID and password.

H] Click the Ok button.

ODBC Database
  1. Now, in the second and third tab of paths and file management, it is not required to configure, as it is by default.
  2. In the fourth tab of log triggers, there are three options – periodic (which logs in fixed intervals you set), on change (which logs when a tag value changes), and on-demand (which logs based on a logic written in SCADA event). Select your desired style.
  3. In the fifth tab of tags in the model, configure the tags you need to log in SQL server.
  4. With this step, your datalog model configuration has been done.
  5. Now, you will have to call or start the service of this datalog model when the backup runs. So, create a macro named startup and write the following syntax – DATALOGON REPORT. This will start your datalog model named report that you created earlier. Once started, it will remain on.
logic written in SCADA event
  1. Once done, your SCADA backup too has been configured. So, everything has been configured properly, you can now run the backup and see that data logs in the SQL server in the following way shown below:
SCADA backup too has been configured
Float Table
data will be logged in SQL server
Tag Table

So, as long as SCADA is running, data will be logged in SQL server. In this way, we saw how to link FactoryTalk Studio and SQL server for data logging.

Read Next:

  • PID in Studio 5000 Function Blocks
  • Door Lock with Delay PLC Exercise Problem
  • PLC Program for Daily Alarm using Real-Time Clock
  • Produced Tags and Consumed Tags in Studio 5000
  • PLC Emergency Stop Example Programming Tutorial
Don't Miss Our Updates
Be the first to get exclusive content straight to your email.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
You've successfully subscribed !

Continue Reading

Siemens S7 300 and STEP 7 PLC program using SIMATIC Software
What is Trace Function in Tia Portal?
Electrical Cabinet Air Conditioner – Enclosure Cooling, Maintenance
Introduction to PLC – Advantages of PLC
DCS
PLC Example to Control LEDs Via Switches
Share This Article
Facebook Whatsapp Whatsapp LinkedIn Copy Link
Share
Leave a Comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Stay Connected

128.3kFollowersLike
69.1kFollowersFollow
210kSubscribersSubscribe
38kFollowersFollow

Categories

Explore More

What is Hot Standby in PLC?
Difference between Timer and Counter – PLC Basics
Transmitters 4-20mA Current Failure Alarm Limits
Types of Noise in Electronics
Developing PLC Logic for Water Pumping and Chemical Addition
Industrial Automation and Control Systems (IACS)
Difference between DCS, PLC, and RTU ?
SAVE and BR Memory Instructions in Siemens PLC Programming

Keep Learning

Address Overlapping in Tia Portal

How to Check Address Overlapping in Tia Portal?

Industrial motor control using PLC instruction list programming

PLC Instruction List for Motor Reverse and Forward Direction

Web SCADA HMI

Web-based SCADA HMI Software

Comparison Instructions in PLC Programming

Comparison Instructions in PLC Programming

Top Free PLC Software

Top Free PLC Software

Boolean Algebra to PLC Logic

From Boolean Algebra to PLC Logic

Faceplates

What are Faceplates? How to Create a Faceplate? HMI Visualization

PLC Circuit with Switches

PLC Example with Switches

Learn More

Basic components of a Thermowell

What is Thermowell and How-to choose Thermowell Probe Length ?

Power Factor Meter Principle

Power Factor Meter Principle

Alternative Vessel Level Indication

What is the Simple Alternative Vessel Level Indication?

Time Response Analysis

Standard Test Signals Objective Questions

Thermocouple Testing

Thermocouple Cold Junction Compensation

DP type Flow Transmitter Calibration

DP type Flow Transmitter Preventive Maintenance and Calibration

DCS System Cabinet

Yokogawa DCS System Maintenance Procedures

Convert Linear mA to Square root mA

Convert Linear mA to Square root mA

Menu

  • About
  • Privacy Policy
  • Copyright

Quick Links

  • Learn PLC
  • Helping Hand
  • Part Time Job

YouTube Subscribe

Follow US
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?