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 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 base collector docid\ t1yxxmmun80y fxbd2raf v1 2 2 released on 02/01/2025 changes base collector docid\ t1yxxmmun80y fxbd2raf v1 2 1 released on 06/11/2024 changes made the query string optional, an empty query string will be executed on the database base collector docid\ t1yxxmmun80y fxbd2raf v1 2 0 released on 03/10/2024 changes base collector docid\ t1yxxmmun80y fxbd2raf 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 base collector docid\ t1yxxmmun80y fxbd2raf v1 1 1 changes fixed a bug where the collector would not pause a measurement base collector docid\ t1yxxmmun80y fxbd2raf v1 1 0 changes added support for auto updating requires historian server >= v6 4 0 added query timeout setting base collector docid\ t1yxxmmun80y fxbd2raf 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 base collector docid\ t1yxxmmun80y fxbd2raf v1 0 6 changes base collector docid\ t1yxxmmun80y fxbd2raf v1 0 5 changes base collector docid\ t1yxxmmun80y fxbd2raf v1 0 4 changes base collector docid\ t1yxxmmun80y fxbd2raf 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