HistorianODBC Data Collector Features and Datatypes
ODBC collector Features
The following table outlines the features of the ODBC Data Collector.
| Feature | Capability |
|---|---|
| Browse Source for Tags | Yes*(on a ODBC server that supports browsing) |
| Browse Source for Tag Attributes | Yes |
| Polled Collection | No |
| Minimum Poll Interval | 100 ms (milliseconds) |
| Unsolicited Collection | Yes |
| Time stamp Resolution | 1 ms |
| Floating Point Data | Yes |
| Integer Data | Yes |
|
String Data | Yes |
| Python Expression Tags | No |
| Time Assigned |
Note: You must set this field to Source as the ODBC Data Collector unsolicited tags.
|
| Quality |
Note: The ODBC collector does not support OPC Quality and OPC Subquality.
|
Supported Data Types
The following data types are supported:
| Historian Data Type | ODBC Source Datatype |
|---|---|
| ihScaled | NA |
| ihFloat | SingleFloat |
| ihDoubleFloat | DoubleFloat |
| ihInteger | SingleInteger |
| ihDoubleInteger | DoubleInteger |
| ihFixedString | NA |
| ihVariableString | NA |
| ihBlob | NA |
| ihTime | NA |
| ihInt64 | NA |
| ihUInt64 | NA |
| ihUInt32 | NA |
| ihUInt16 | NA |
| ihByte | Byte |
| ihBool | NA |
Note: The ODBC Source data type should be mapped with the corresponding Historian data type. For the data types which are NA, if the source contains data related to that Historian data type, user should include the corresponding ODBC Source data type in the Mapping file. Example: If Source contains data of ihBlob Historian data type, you should include the corresponding Source data type in the mapping file.
