Canary Community

How to enable Javascript

ODBC Client

All topics

Articles and updates from Canary Community

Filter
Tags

Follow

How To Install and Configure the ODBC Client (version 22)
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…
- updated 1 yr ago
- 726
- ODBC Client
Schema (version 22)
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…
- updated 1 yr ago
- 321
- ODBC Client
Querying the Historian using a Linked Server in Microsoft SQL Server (version 22)
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…
- updated 1 yr ago
- 2replies
- 892
- Last replySteve Mason1 yr ago
- ODBC Client
Querying the Historian Using Power BI (version 22)
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.…
- updated 1 yr ago
- 336
- ODBC Client

Back to top

Articles and updates from Canary Community

Support Center

Open a Support Ticket

Recent activity