beautypg.com

Choosing the data to be logged, Logging data to odbc data sources, Logging data to an existing odbc data source – Rockwell Automation FactoryTalk View Site Edition Users Guide User Manual

Page 587: Choosing the data to be logged – 9, Logging data to, Logging data to an existing, Odbc

background image

22

S

ETTING

UP

DATA

LOGGING

22–9

• •

22

Pla
ceho

lde

r

You can also combine types of logging. For more information, see page 22-14.

For details about options in the Log Triggers tab, click Help.

Choosing the data to be logged

In the Data Log Models editor, use 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.

For details about options in the Tags in Model tab, click Help.

Logging data to ODBC data sources

You can store logged data in an existing ODBC data source, or you can create a new
ODBC data source.

Logging data to an existing ODBC data source

You can log data to an existing ODBC data source, but its tables must contain fields that
are formatted for the FactoryTalk View data log.

There are two ways to prepare tables for data logging to an existing database:

Set up the FactoryTalk View data log fields in the existing ODBC tables before
setting up a data log model.

Create new tables in the existing database automatically or manually, from within the
Data Log Models editor.

To use the tables in an existing ODBC data source

1. Add fields for the data log data to the tables in the ODBC database.

For information about modifying the ODBC database tables, see the documentation
for the ODBC database you are using.

2. Set up a data log model, as described in Help. Specify the existing ODBC database as

the ODBC Data Source, and then specify the tables you edited.

To create new tables in an existing ODBC data source

1. Specify the name of the existing ODBC data source in the ODBC Data Source field

of the Data Log Models editor.

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.