-
How to turn off Compression on SQL Collector Tags.
How to turn off Compression on SQL Collector Tags. I want all values from my SQL Collector. Example this happed today Timestamp Value 2025-03-10 11:41:55.978 31.79 2025-03-10 11:25:34.045 31.…
-
SQL Collector Tile (version 25)
Connections - number of configured sessions Tags - total number of tags being logged TVQs - total number of updates logged in last hour Version - version number of the SQL Collector service The SQL…
-
SQL Collector Tile (version 24)
Connections - number of configured sessions Tags - total number of tags being logged TVQs - total number of updates logged in last hour Version - versioning number of the SQL Collector service The…
-
SQL Collector Tile (version 25)
Connections - number of configured sessions Tags - total number of tags being logged TVQs - total number of updates logged in last hour Version - version number of the SQL Collector service The SQL…
-
Wonderware (AVEVA) historian to Canary? Options?
I've been tasked with collecting Wonderware Galaxy Objects' process values into Canary via a Wonderware/AVEVA historian data source. I know the AVEVA historian has a SQL interface,…
-
SQL Data Collector for generic ODBC data source
I had an ODBC data source that I wanted to collect data from; looking at the SQL data collector, I see that it only supports MSSQL, MySQL, and Oracle, but a generic ODBC connection is not possible.…
-
How To Configure the SQL Collector (version 23)
Overview Canary does not like reading from production tables (for various reasons) so we use a queue table that contains rows ready to be processed. Once we process those rows we remove them from the…
-
How To Configure the SQL Collector (version 24)
Overview Canary does not like reading from production tables (for various reasons) so we use a queue table that contains rows ready to be processed. Once we process those rows we remove them from the…
-
How To Configure the SQL Collector (version 25)
Overview Canary does not like reading from production tables (for various reasons) so we use a queue table that contains rows ready to be processed. Once we process those rows we remove them from the…
-
Migrate GE historian data to Canary
Hi folks, has anyone experienced such a data motion from GE to Canary? I was thinking at using HDA client but Canary lacks that, right? So it’s only CSV and SQL? The db is 10gb+ so CSV might be hard.…
Welcome to the community!