-
How To Install and Configure the ODBC Client (version 24)
The Canary ODBC Client is used for generating reports using SQL queries and populating data from the Canary Historian into SQL databases. It is a server/client based architecture in which the ODBC…
-
Schema (version 24)
Canary exposes 9 tables to query against: aggregates assetinstances assettypes assettypetags currentdata data tagproperties tags views aggregates Returns the name and description for each aggregate…
-
Querying the Historian using a Linked Server in Microsoft SQL Server (version 24)
Configuring the Linked Server Ensure the ODBC Service is installed/licensed on the Canary Historian and the ODBC client is installed on the SQL server. Open Microsoft SQL Server Management Studio and…
-
Querying the Historian Using Power BI (version 24)
Ensure the ODBC Server is installed/licensed on the Canary Historian and the ODBC Client is installed on the client machine wishing to query the Historian.…
Articles and updates from Canary Community