JavaScript is off. Many parts of this site require JavaScript to function properly.

Reports

Make sense of your data with several reporting options. Share your findings and improve your processes.

reports

Excel Add-In

The Excel Add-in provides access to tag information, raw data, aggregate data, and event statistics. A Microsoft Excel ribbon bar allows you to quickly get to the functions you need.

add trends
play_circle_filled

Quickly access entire lists of tag names, tag properties, and tag data context.

Watch Video
calculation trends
play_circle_filled

Access any Canary historian and extract raw data values for a set time period.

Watch Video
trend limits
play_circle_filled

With over 30 available data aggregates, select the desired processed data based on time interval.

Watch Video
aggregated data
play_circle_filled

Browse the existing Events service and filter results by multiple properties or search for undefined Events with the AdHoc Events tool.

Watch Video
close

XL Reporter

editor

Created by SyTech, XL Reporter is built around the familiar environment of Excel and is recommended for automated reporting. The scheduler can automatically produce reports within Excel Workbooks, as encrypted PDF files, or as web pages. You can easily distribute reports by email, FTP, file server, and printer.

View Datasheet

ODBC Connector

Use other third party reporting options like Spotfire, Tableau, Dream Reports, and more by making SQL queries from the data tables of the Enterprise Historian with Canary’s ODBC connection.

aggregated data
play_circle_filled

Connecting spotfire to the historian using the ODBC connector.

Watch Video

Question/Answer

keyboard_arrow_rightkeyboard_arrow_downWhat is processed data?

Processed data is calculated using an aggregate and time interval. A common use of processed data is to get the average values of the raw data over specified time intervals.

keyboard_arrow_rightkeyboard_arrow_downWhat are aggregates?

Aggregates are the calculation algorithms used when retrieving processed data. Some aggregates are TimeAverage, Minimum, Maximum, Total, Start, PercentGood, Count, and more.

keyboard_arrow_rightkeyboard_arrow_downCan I access the database using SQL queries?

Yes, you can use the ODBC Connector to make SQL queries into the database.

keyboard_arrow_rightkeyboard_arrow_downCan I schedule reports?

Yes, XL Reporter allows for scheduled reports via email, FTP, file server, or printer.

keyboard_arrow_rightkeyboard_arrow_downCan I connect the Canary database to other reporting tools?

Indeed, you can. Choose between our ODBC Connector, HDA Connector, or our API.

Affordable Pricing

View Pricing
arrow_upward