-
How To Install and Configure the ODBC Client (version 26)
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 26)
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 26)
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 26)
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.…
Welcome to the community!