-
SQL Collector Axiom issue
There is a dataset which is using SQL collector to get data. The sample interval is about 10 mins for example. In case the data is not updated due to error on data source error or something SQL…
-
SQL Collector Tile (version 26)
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,…
-
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…
-
Suppprt for PostgreSQL
It would be really great to have PostgreSQL as a SQL collector option (and even for storing audit data or events). PostgreSQL is one of the most used DBs for apps. Thanks
-
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 26)
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 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 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 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…
-
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 26)
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!