---

How To Connect SQL Server In Factorytalk View For Datalogging

open your FactoryTalk view studio and then In FactoryTalk View Studio, in the Explorer window, open the Data Log folder. Right-click the Data Log Models icon, and then select New. now datalog model editor will open your screen we already discuss file set storage format in this article we discuss only sql and ODBC server connectivity with FactoryTalk view studio.for Connecting SQL server to FactoryTalk View Application Data logging select storage format as ODBC data source.

Factorytalk View ODBC Tables Name

when you select storage format as ODBC data source you see three tables name Tag table, string table and float table. The ODBC format stores data in up to three tables:

• FactoryTalk view ODBC Float table this is main table all logged value store in this table. It stores analog and digital tag values.
• FactoryTalk view ODBC String tableit is an optional table used for storing string values. All string data and tag stored in string table.
• FactoryTalk view ODBC Tag table it stores the tag name. It is also an optional table. Tag names in an index so that they can be referenced using a 2- or 4-byte numeric field.

The ODBC tables are created with the default names TagTable, FloatTable, and StringTable. In the Data Log Models editor, you can change these names before creating the tables, or you can specify the names of different tables but i recommend use name as it is.

How To Log Data To ODBC Data Sources In Factorytalk View Se

You can store logged data in an existing ODBC data source, or you can create a new ODBC data source. for creating a new ODBC data source follow these steps

Creating a new ODBC data source FactoryTalk view se To create a new ODBC data source, click the browse (...) button next to the ODBC Data Source text box.

Select the System Data Source tab. Use an existing DSN or select New to create a new one. For a new DSN(Data Source Name)

Select System Data Source. And click next

select sql server and click next. And next pop window click finish

Enter a Name and Description of your DSN. Select Server (always select server where you create a database). sometimes server not listed so enter manually. And Click Next

select authentication mode of your DSN. you can choose windows authentication or sql server authentication. Use same credentials as your database server. after click next

select database which we created beginning of article.(plcblogdatalog). If you not select database than by default it logged data in maser database. Click next and then finish.

after finising above step test your data source if successfully connected than move to following step otherwise write a comment or send a mail so i can help you.

after successfully test The DSN configured should now be set as the ODBC Data Source select your dsn and click ok.

press create table button for creating table in your database. When commend completed a message will pop up "ODBC table were successfully created".

ODBC backup path for datalog in FactoryTalk view studio

you can set backup path for your ODBC data source. Select enable ODBC backup path than set absolute or relative path. backup files prevents to loss of any type of data if database server is not reachable or not accessible so the backup file take a backup if required you can restore these data by using backup file.

Purge Old Records From The Database In Factorytalk View Studio Datalog

in file management tab help to delete old records from the database using standard relational database tools or SQL queries. You can also set up FactoryTalk View to delete records in the ODBC database after a specified time. select time when you want to delete old record in file management tab.

Specify When To Store Data In Factorytalk View Studio Datalog

use log trigger tab to define when data logged into database. you can store data periodically, when specific value occur or on demand. in periodic trigger data store in data base at specific time interval. in on change value store at specific value. On demand data store when particular even come.

How To add tag in ODBC Data source| FactoryTalk Data Log Model

Use Tag in Modal Tab to Add Tag in Datalog Model. The Tags In Model Tab To Specify Which Tags Will Be Scanned For Data. A Data Log Model Can Contain Up To 10,000 Tags. Browse Tag And Add To Datalog Model. All Type Of Tag You Can Use For Data Logging.

Save ODBC Data Source Factorytalk Data Log Model

after all setting in data log model press ok and set the component name of datalog model. this component you can use for event, manually or automatic data logging etc.

Start Data Logging In FactoryTalk Datalog Model

to start data logging in factory talkview datalog model you can use command line DataLogOn than data model name as DataLogOn 'plcblog' or right click on datalog model component and click to start.

Stop Data Logging In FactoryTalk Datalog Model

to stop data logging in factory talkview datalog model you can use command line DataLogOFF than data model name as DataLogOFF 'plcblog' or right click on datalog model component and click to STOP.

check your datalogging in ms-sql server

open miscrosoft sql server management studio and select your database and open your table you see your all three table are created Format for ODBC tag table. Open Float table and following is format of ODBC float and string tables

• DateAndTime The date and time the tag values were logged.
• Millitm The millisecond time the tag values were logged.
• TagIndex The index number for the tag. The tag name that corresponds to this number is listed in the tag name table
• Val The analog or digital value of the tag.
• Status Blank if communications are working properly. E in a communication error. S if the tag value is stable. U if the tag is uninitialized.
• markerInternal tag marker.

Format for ODBC tag table The following table shows the format for ODBC tag table.

• TagNameThe tag name as in scada.
• TagIndexThe index number assigned to the tag name.
• TagTypewhich type of your tag. 2 if tag is Analog ,3 if tag Digital,4 if tag is String.
• TagDataType this column helps to find data type of logged data tag. -1 for Integer, 0 for Long, 1 for Float, 2for String