Canary Community
Search
How to enable Javascript
Sign Up
Login
Welcome to the Community!
Search the community
Feedback
Forum
Knowledge Base
Explore & Learn
Roadmap & Releases
Home
Tags
ODBC Client
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
Why does my ODBC query return a value of NaN?
When querying the historian using an ODBC connection, sometimes it returns NaN for a value.
Big_Bird
Hi everyone! I post questions for the Canary Team to answer.
Big_bird
2 yrs ago
1
reply
105
1
Last reply
Steve Mason
2 yrs ago
Questions & Answers
Answered
Answered
Schema (version 23)
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
8 mths ago
388
ODBC Client
Querying the Historian using a Linked Server in Microsoft SQL Server (version 23)
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
6 mths ago
674
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
2
replies
724
Last reply
Steve Mason
11 mths ago
ODBC Client
0
ODBC Driver - Auto Piviot Option
Is it possible to add a feature in Canary ODBC driver that automaticly pivots the tag names to columns. See the SQL PIVOT below. SELECT * FROM ( SELECT tag_name, time_stamp,…
jaiscott
jaiscott
1 yr ago
62
Data Connectivity
Querying the Historian Using Power BI (version 23)
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
6 mths ago
389
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
319
ODBC Client
How To Install and Configure the ODBC Client (version 23)
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
6 mths ago
772
ODBC Client
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
657
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
286
ODBC Client
Canary ODBC Client
I'm having a problem querying Canary from ODBC (even though the plant in question has a license for this). Testing the connection in ODBC Data Sources works AND I can connect and see tables in Excel…
James Wise
Top Contributor
wise_james
updated
2 yrs ago
5
replies
305
Last reply
Steve Mason
2 yrs ago
Questions & Answers
Querying the Historian using a Linked Server in Microsoft SQL Server (version 21)
Configuring the Linked Server Install and configure the ODBC Client if it is not already Open Microsoft SQL Server Management Studio and right-click 'Linked Servers' to create a 'New Linked Server'.…
updated
2 yrs ago
456
ODBC Client
How To Install and Configure the ODBC Client (version 21)
The Canary ODBC Client is used for generating reports using SQL queries and populating data from the Enterprise Historian into SQL databases. It is a server/client based architecture in which the…
updated
2 yrs ago
611
ODBC Client
Schema (version 21)
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
2 yrs ago
169
ODBC Client
Querying the Historian Using Power BI (version 21)
Open Power BI and select 'Get data' Search for 'ODBC' then click 'Connect' The 'From ODBC' window will appear. Expand 'Advanced options' to type in a SQL query.…
2 yrs ago
372
ODBC Client
Recent activity
Home
Feedback
Issues and Bug Report
Bugs or Issues
Product Ideas and Feature Requests
Data Logging
Virtual Views
Calculations & Events
Axiom
Data Connectivity
Excel Add-in
Forum
Latest News
Axiom Showcase
Questions & Answers
Knowledge Base
Version 23
Getting Started
System Admin Duties
Client Tools
Version 22
Getting Started
System Admin Duties
Client Tools
Version 21
Getting Started
System Admin Duties
Client Tools
Explore & Learn
Upcoming Events
In-Person Events
Coaching Sessions & Webinars
On Demand Learning
RFP Common Responses
Canary Academy
Previous Coaching Sessions
Project Boot Camp
Roadmap & Releases
Roadmap
Canary System Release Notes
Ignition Module Release Notes
Distributor Release Links
View all topics
Support Center
Open a Support Ticket
View Support Ticket Status