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
ODBC without data on "data" table
Hi everyone, I'm trying to query from an ODBC client and I can only see data from the "aggregates" and "views" tables. When I try with the "data" table, the results are always empty.…
rodrigopoyanco
rodrigopoyanco
2 wk ago
4
replies
51
Last reply
Steve Mason
9 days ago
Questions & Answers
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…
updated
10 mths ago
353
ODBC Client
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
10 mths ago
471
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
9 mths ago
789
ODBC Client
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…
updated
1 mth ago
622
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
831
Last reply
Steve Mason
1 yr 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
74
Data Connectivity
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
330
ODBC Client
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.…
updated
1 mth ago
374
ODBC Client
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
9 mths ago
457
ODBC Client
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…
updated
1 mth ago
727
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
9 mths ago
946
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
704
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
314
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
351
Last reply
Steve Mason
2 yrs ago
Questions & Answers
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
112
1
Last reply
Steve Mason
2 yrs ago
Questions & Answers
Answered
Answered
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 24
Getting Started
System Admin Duties
Client Tools
Version 23
Getting Started
System Admin Duties
Client Tools
Version 22
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