Using ODBC data sources

You can choose 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.

When using an ODBC data source, the ODBC data source cannot have the same name as the HMI project and must be either a

System

or

File ODBC

data source. For SQL Server data source, both Windows authentication and SQL server user ID and password are supported.

If you are going to use ODBC data tables, you must first create the data sources on the computer on which the data logger will run.

To do this, you can either click the browse button (...) next to the

ODBC Data Source

field of

Setup

tab, or use the Microsoft ODBC Data Source Administrator that you can find in

Control Panel

>

Administrative Tools

>

Data Sources (ODBC)

.

When you save the data log model that uses the ODBC storage format, FactoryTalk View informs you if the fields in the ODBC table are not in the order of, or of the type, required to log FactoryTalk View data. To remedy this, edit the table, as described in the ODBC documentation that comes with the tool you are using.