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

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.