SQL Collector

always check the compatibility matrix below before installing a new version compatibility collectors of all versions >= v1 0 0 are compatible with all factry historian versions >= v4 0 0, in both directions however, for certain functionalities, certain minimum versions of the collector and factry historian are required more information is always available in the release notes feature compatibility matrix this is the compatibility matrix for version listed on this page if you have downloaded a newer version than the one listed on this page please check the release notes of that version feature sql collector version factry historian version multiline query string >= v1 0 11 >= v6 3 collector auto update >= v1 1 0 >= v6 4 0 v1 7 0 released on 03/09/2026 changes updated the base collector to v4 3 0 the collector no longer queries the database while it has no active measurements the collector now decides per row whether the last update time may pass it a row whose measurement key matches no measurement holds the last update time back, so a measurement configured later still collects it a row with an unreadable timestamp is skipped and logged bug fixes fixed the collector reading the whole table on every query interval when it had not collected any data yet it now starts from the moment of its first start set the last update time in the collector state to collect older rows fixed rows being collected twice, or being skipped, around a restart, a pause or a resume fixed crashes when measurements were added, updated or activated while the collector was running fixed the collector state failing to update after an upgrade from a version older than v1 3 0 fixed the collector health staying on an old error after the queries recovered or after the collector was paused health now also reports "no active measurements" fixed rows being skipped when the query timeout ended a query result halfway the collector read the part it received as the whole result fixed the database heartbeat of a paused collector staying alive after a resume every pause and resume added one, and each reported a connection status of its own fixed a paused collector being reported as collecting the database heartbeat could report the connection status after the collector stopped fixed a last update time set in historian being replaced when the collector was paused and resumed while a batch was on its way to the historian the next resume skipped the rows that value asked for the collector now warns when a query returns rows it cannot collect rows that match no measurement, rows with an unreadable timestamp, and rows it cannot read it warns once per kind per query, with a count, instead of once per row v1 6 0 released on 19/08/2026 bug fixes fixed the collector staying stuck on "error executing query" when the database session died without the driver reporting it the collector now rebuilds the connection after two consecutive query failures note a query that keeps failing at execution also triggers a reconnect every two query intervals, until the query is fixed or the collector is paused fixed querytimeout not cancelling running queries on odbc connections updated the odbc driver to fix a possible deadlock or crash when a query completes while it is being cancelled v1 5 2 released on 16/07/2026 changes updated the base collector to v3 5 3 v1 5 1 released on 04/06/2026 bug fixes fixed a reconnect regression after query preparation errors the sql client now fully resets the database handle so heartbeat can retry connection and statement preparation fixed health/status handling while disconnected polling no longer reports repeated "error executing query client not connected to db" and no longer overwrites "error preparing query" until reconnect succeeds v1 5 0 released on 07/05/2026 changes added support for sqlite on all platforms the old "sqlite3" driver name is still supported but will be changed to "sqlite" internally added support for custom timestamp layouts for parsing timestamps returned as strings or integers timestamps returned as native time values by the driver are not affected the timestamp layout can be set with the new "timestamplayout" setting, supported values are rfc3339 (default), unix, unixmillis, unixmicros, unixnanos or a custom go time layout v1 4 0 released on 22/01/2026 changes updated the base collector to v3 5 2 docid\ djs1gflkyd1m31dxqh5cu v1 3 0 released on 13/02/2025 changes added support for odbc datasources on linux/amd64 and windows removed support for sqlite datasources on anything but linux/amd64 last update time of the collector is now in the collector state and can be changed with factry historian v1 2 3 released on 29/01/2025 changes disabled streaming until a data loss fix is implemented updated the base collector to v2 7 3 docid\ djs1gflkyd1m31dxqh5cu v1 2 2 released on 02/01/2025 changes updated the base collector to v2 7 1 docid\ djs1gflkyd1m31dxqh5cu v1 2 1 released on 06/11/2024 changes made the query string optional, an empty query string will be executed on the database updated the base collector to v2 6 1 docid\ djs1gflkyd1m31dxqh5cu v1 2 0 released on 03/10/2024 changes updated the base collector to v2 6 0 docid\ djs1gflkyd1m31dxqh5cu v1 1 4 bug fixes revert the change to escape username and password for connection string as this does not work for all database types v1 1 3 bug fixes fixed missing collector health change after query timeout fixed escape username and password for connection string v1 1 2 released on 07/06/2024 changes added support for performance monitoring with pyroscope bug fixes restored windows 7 compatibility updated base collector to v2 4 8 docid\ djs1gflkyd1m31dxqh5cu v1 1 1 changes fixed a bug where the collector would not pause a measurement updated base collector to v2 4 3 docid\ djs1gflkyd1m31dxqh5cu v1 1 0 changes added support for auto updating requires historian server >= v6 4 0 added query timeout setting updated base collector to v2 4 0 docid\ djs1gflkyd1m31dxqh5cu v1 0 11 changes made query string setting multiline, requires historian v6 3 v1 0 10 changes removed 32 bit builds due to a dependency not supporting it v1 0 9 changes changed the ase package v1 0 8 changes added username and password fields to collector settings bug fixes fix collector health not always updating correctly v1 0 7 bug fixes fixed heartbeat running twice after unpausing fixed measurements not being picked up after unpausing changes updated the base collector to v1 2 14 docid\ djs1gflkyd1m31dxqh5cu v1 0 6 changes updated the base collector to v1 2 12 docid\ djs1gflkyd1m31dxqh5cu v1 0 5 changes updated the base collector to v1 2 9 docid\ djs1gflkyd1m31dxqh5cu v1 0 4 changes updated the base collector to v1 2 8 docid\ djs1gflkyd1m31dxqh5cu 1 0 3 bug fixes fixed reading of tags 1 0 1 changes add drivers for sap hana/ase 1 0 0 initial release of the sql collector includes drivers for postgres oracle sqlserver mysql sqlite3