Data Log Models editor - Setup tab

Type a brief description of the model. This is for your information only.

This is a user-defined string, up to 20 characters long, which becomes part of the log file’s name if long file names are supported.

If you choose the ODBC storage format, long file names apply only to the backup files.

Choose this storage format to log data to proprietary file sets with the extension

.DAT

.

This field is displayed if

File Set

is selected.

If you are logging string tags, type the maximum number of characters to be logged for all string tags in the model.

Choose this storage format to log data to tables in an ODBC database such as Microsoft SQL Server (fully tested), Microsoft Access, or Oracle. ODBC backup files are stored as binary files which you cannot view.

Type the System ODBC data source name, or the path and file name of the file-based data source, that data will be logged to. The path is not required if you are using the default ODBC location for file-based data sources.

You can also click the browse button to select an existing data source or create a new ODBC data source.

Type the name of an existing ODBC tag table, or click the browse button to select an existing one. This table is optional. The table name cannot have spaces in it.

Type the name of an existing ODBC float table, or click the browse button to select an existing one. The table name cannot have spaces in it.

Type the name of an existing ODBC string table, or click the browse button to select an existing one. The table name cannot have spaces in it.

Click this button to create the

Tag

,

Float

, and

String

tables automatically, if they do not already exist.

If FactoryTalk View is unable to create the tables automatically, you must create the tables manually. Refer to the documentation supplied with the ODBC tools for information about creating the tables manually.

If an index cannot be created during automatic creation of data log tables, you must create the index manually. Append the text

Index

to the table name when naming the index. Specify the

DateandTime

field as the indexed field. Refer to the documentation supplied with the ODBC tools for information about creating an index.

For example, the following SQL statement will create an index based on the table name FloatTable:

For faster queries, create a clustered index for FloatTable using an SQL statement such as the following:

Enter a user ID and password that will enable the user to connect to the database.

Select this box if:

The ODBC database and HMI server are not located on the computer on which you are configuring the application.
The SQL Server data source' authentication is configured as user ID and password.

However, if the SQL Server data source' authentication is configured as Windows authentication, you don't need to configure this setting. But you need to add the current Windows user to SQL Server database with sufficient permission for logging data.