Chapter 10. Write to a Database

Table of Contents
10.1. Introduction
10.2. Quick Start
10.3. Configuring the Queue, Store and Forward
10.4. Setting up the DSN (Data Source Name)
10.5. Configuring a Database Table
10.6. Key Columns
10.7. Assigning a Trigger
10.8. Setting Trigger Conditions
10.9. Configured Actions

10.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 11, 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.