Best Practices

Asset hierarchy definition help

I have a dataset populated by a CSV collector and I am trying to create a virtual view to put the tags into an asset hierarchy. The tag names are of the form CsvTag.<site>.…

• Answered

Events Table Optimization

We are trying to optimize performance of the Events and Event Properties table, is it advisable to add Indexing and table partitions to achieve this?

Scaling on Virtual View

Hi all- I currently have some tags I am historizing that have a different scale associated with them as I store (10x / 100x / 500x). I am currently using virtual views and I am looking for a way to…

Accessing Calculated Tags

I have created a few calculations within my Cals & Events Tab. I was wondering if it was possible to access these tags within Axiom. If so, how would I be able to do this?

Wonderware (AVEVA) historian to Canary? Options?

I've been tasked with collecting Wonderware Galaxy Objects' process values into Canary via a Wonderware/AVEVA historian data source. I know the AVEVA historian has a SQL interface,…

Data Compression

Hi Everyone, I have some data showing that during the night, the hourly scheduled calculations give me a result of zero. When I check the data the next day,…

Get Tag Data Given a list or array?

Hi all, I'm currently working on a project that involves retrieving specific tag data from the historian. I have a list or array of timestamps for a particular tag,…

Using Axiom for Line Display

I want to use Axiom to show live time progress above production lines. Ideally, they will be on 24/7 and reset data at shift change Is there any issues with Axiom timing out if it is up on a screen…

Moving data between historians

Hello community! I'm exploring the Redundant Logging architecture, where a data collector+sender pair will move data to a primary and redundant historian servers.…

• Answered

Architecture Question

Multiple industrial sites with occasional network connectivity issues Multiple legacy control systems in place, all support OPC Business users want to see some process tags in a cloud BI system…

Canary as Site Historian vs others (Ignition, OSI PI, AWS)

For a Site Historian requirement, I am exploring the historians available in the market and understanding where each Historian fits well. Can anyone throw light on the following questions?…

Consume csv files without the Engineering units row

Hi everyone, I have an operator's logs screen in Ignition processed as a dataset, which I later export as a csv file for Canary's csv collector to consume.…