Inst ToolsInst ToolsInst Tools
  • Courses
  • Videos
  • Q & A
    • Interview
      • Instrumentation
      • Electronics
      • Electrical
      • Practical Questions
    • MCQ
      • Instrumentation MCQ
      • Electrical MCQ
      • Electronics MCQ
      • Control Systems MCQ
      • Analog Electronics MCQ
      • Digital Electronics MCQ
      • Power Electronics MCQ
      • Microprocessor MCQ
      • Multiple Choice Questions
  • EE
    • Electronics
      • Electronics Q & A
      • Electronic Basics
      • Electronic Devices & Circuits
      • Electronics Animation
      • Digital Electronics
    • Electrical
      • Electrical Basics
      • Electrical Q & A
      • Power Electronics
      • Electrical Machines
      • Electrical Animation
      • Power Systems
      • Switchgear & Protection
      • Transmission & Distribution
  • Measure
    • Control Valves
    • Calibration
    • Temperature
    • Pressure
    • Flow
    • Level
    • Analyzers
    • Switches
    • Vibration
    • Solenoid Valve
  • Control
    • PLC Tutorials
    • Control Systems
    • Safety Instrumented System (SIS)
    • Communication
    • Fire & Gas System
  • More
    • Design
    • Tools
    • Animation
    • Basics
    • Formulas
    • Standards
    • TextBooks
    • Common
    • Software
    • Excel Tools
    • Erection & Commissioning
    • Process Fundamentals
    • Videos
    • Books
Search
All rights reserved. Reproduction in whole or in part without written permission is prohibited.
Reading: FactoryTalk Studio and SQL Server for Data Logging
Share
Notification Show More
Font ResizerAa
Inst ToolsInst Tools
Font ResizerAa
  • Courses
  • PLC Tutorials
  • Control Systems
Search
  • Courses
  • Videos
  • Q & A
    • Interview
    • MCQ
  • EE
    • Electronics
    • Electrical
  • Measure
    • Control Valves
    • Calibration
    • Temperature
    • Pressure
    • Flow
    • Level
    • Analyzers
    • Switches
    • Vibration
    • Solenoid Valve
  • Control
    • PLC Tutorials
    • Control Systems
    • Safety Instrumented System (SIS)
    • Communication
    • Fire & Gas System
  • More
    • Design
    • Tools
    • Animation
    • Basics
    • Formulas
    • Standards
    • TextBooks
    • Common
    • Software
    • Excel Tools
    • Erection & Commissioning
    • Process Fundamentals
    • Videos
    • Books
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

What is a Control Panel and its types?
What is Human Machine Interface (HMI) ?
Up Counter PLC Program
How to Protect Siemens PLC using Password?
Parallel Tanks Level Control using PLC Ladder Diagram Tutorial
Configuration of Profibus Network in Siemens PLC
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
208kSubscribersSubscribe
38kFollowersFollow

Categories

Explore More

Difference Between Normal Counters and Fast Counters – Learn PLC
T Flip Flop PLC Ladder Diagram
FB Block in Siemens PLC Programming
Attendance System PLC Program using CX-Programmer
PLC based 4 Way Traffic Light Control System
Industrial Automation and Control Systems (IACS)
1 to 8 Demultiplexer PLC ladder diagram
Basic PLC Alarm Programming Example

Keep Learning

Playground Swing Logic Exercise Program in PLC

Playground Swing Logic Exercise Program in PLC

How to Control VFD with PLC using Ladder Logic

Car Wash Program using Functional Block Diagram (PLC)

Car Wash Program using Functional Block Diagram (PLC)

Allen Bradley SLC 500 PLC Programming

Basics of PID Controllers

PID Controllers in Closed Loop Control Systems – PLC Basics

What is an instruction list language?

Structured Text vs. Instruction List for PLC Programming

Faceplates

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

PLC Code to Start & Stop Motor and Pump as per Logic

PLC Code to Start & Stop Motor and Pump as per Logic

Learn More

Difference Between MPCB and MCCB

Difference Between MPCB and MCCB

multiphase-flowmeter-working-principle

What are Multiphase Flow Meters? – Working Principle, Advantages

Mathematical Models of Physical Systems

Transfer Functions Objective Questions

Example of Controlling the PLC Output using Push Buttons

Example of Controlling the PLC Output using Push Buttons

Instrumentation Deliverables Generated from 3D Modeling

Instrumentation Deliverables Generated from 3D Modeling

Resistance Temperature Detectors Errors

Resistance Temperature Detectors (RTD) Sources of Error

The Principle of Dead Weight Pressure Tester

The Principle of Dead Weight Pressure Tester

HMI screen for operator

Auto Tiffin Box Filling Station

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?