Example: parts of a data log long file name, Odbc database storage format and schemas, Odbc – Rockwell Automation FactoryTalk View Site Edition Users Guide User Manual
Page 581
22
•
S
ETTING
UP
DATA
LOGGING
22–3
•
•
•
• •
22
•
Pla
ceho
lde
r
This number indicates the sequence files were created in. You can have up to 9999
file sets per day. At midnight, the sequence starts again at 0000.
<Log File Identifier String> is a text string you can specify to help identify the log
file. The maximum string length is 20 characters.
<(type)> is the file type.
The type is enclosed in parentheses. There are three file types: Tagname, Float (for
analog and digital tag values), and String.
Example: Parts of a data log long file name
The data log file named
2006 10 30 0004 Oven Temperatures (Float).dat
was created October 30 2006:
0004 indicates that this is the fourth file set created that day.
Oven Temperatures is the log file identifier string, which the user defined to help
identify the data.
(Float) indicates that this file contains analog or digital tag values.
ODBC database storage format and schemas
Use the ODBC database format to store data using an ODBC data source such as Oracle,
Microsoft SQL Server, or Microsoft Access.
The ODBC format stores data in up to three tables:
Float table
stores analog and digital tag values.
String table
(optional) stores string tag values.
When creating the tables for Float and String data logging to MS SQL Server 2008, ensure that
Microsoft SQL Server 2008 Service Pack 1 has been installed first, or table creation will not be
possible.