beautypg.com

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

background image

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.