Overview of the ODBC Collector
The ODBC collector collects data from an application based on an ODBC driver and stores the data in an on-premise Historian server or a cloud destination. It supports collecting of all the Historian supported data types of data from the ODBC server.
Topology: The ODBC collector supports a distributed model, where the ODBC server, the collector, and the Historian server are installed on different machines. Typically, however, the collector is installed on the same machine as the ODBC server and sends data to a remote Historian server.
Features:
- You can browse the source for tags and their attributes on an ODBC server that supports browsing.
- Only the unsolicited data collection is supported; when changes to the ODBC source tags are detected, they are sent to the Historian server. The minimum poll interval is 100ms. The collector duplicates raw samples from the ODBC server into the Historian data archive.
- The supported timestamp resolution is 1ms.
- Floating point, integer, and string data are supported.
Supported Data Attributes:
| Historian Data Type | ODBC Server Data Type |
|---|---|
| ihByte | Byte |
| ihFloat | SingleFloat |
| ihDoubleFloat | DoubleFloat |
| ihInteger | SingleInteger |
| ihDoubleInteger | DoubleInteger |
| ihScaled | Not applicable |
| ihFixedString | Not applicable |
| ihVariableString | Not applicable |
| ihBlob | Not applicable |
| ihTime | Not applicable |
| ihInt64 | Not applicable |
| ihUInt64 | Not applicable |
| ihUInt32 | Not applicable |
| ihUInt16 | Not applicable |
| ihBool | Not applicable |
Limitations:
- A single collector instance can collect data from a single ODBC server. To collect data from multiple ODBC servers, you must add multiple instances.
- Only good and bad quality types are supported. OPC Quality and OPC Subquality are not supported.
- If you want a domain user to use the ODBC collector, after you add an instance
of a collector, when you later configure it, do not provide values in the
User Name and Password fields.
This is because the ODBC driver uses Windows authentication.
