Chapter 9. Write to a Database

Table of Contents
9.1. Introduction
9.2. Quick Start
9.3. Configuring the Queue, Store and Forward
9.4. Setting up the DSN (Data Source Name)
9.5. Configuring a Database Table
9.6. Key Columns
9.7. Assigning a Trigger
9.8. Setting Trigger Conditions
9.9. Configured Actions
9.10. Data Logging vs ODBC Historian

9.1. Introduction

The DataHub program can write data to any ODBC compliant database or text file[2].

With this feature of the DataHub program you can:

  • Log data to any ODBC-compliant database, such as MS Access, MS SQL Server, MySQL, Oracle, and many more.

  • Log from any data source connected to a DataHub instance.

  • Log to existing database tables, or create new tables as necessary.

  • Log data to a text file using the LogFile.g script.

[Note]

To write data from a database into a DataHub instance, please see Chapter 10, Query a Database.

The DataHub ODBC Data Logging interface provides an easy way to connect to a DSN, create or select a table, assign data point properties to table columns, and assign a trigger and conditions for logging points. The fastest way to learn how to use the interface is by watching the web-site video or by using the Quick Start.



[2] Text logging can be configured through DataHub scripting.