AVEVA Historian vs. Azure Databricks

Paired with Citect SCADA or System Platform, this is an excellent process historian. It also works well collecting OPC data. For basic data storage, retrieval, and analysis, this is well suited. This is not well suited for very large deployments. Multiple instances would need to be used to scale up, and the data fed into a second-tier/enterprise historian for corporate user consumption.

Incentivized

Centralised notebooks are out directly into production. This can lead to poorly engineered code. It is very good for fast queries and our data team are always able to provide what we ask for. It is a big cost to our business so it is important it runs efficiently and returns on our investment.

Incentivized

• Data storage--multiple data sources stream data in real time; it is stored without issue
• Data retrieval--small to moderate queries and trends are generally fast and efficient
• Cost effectiveness--it is one of the cheaper (non-enterprise) historian offers and therefore is good value for money (with a reduced feature set)

Incentivized

• Data Processing and Transformations based on Spark
• Delta Lakehouse when clubbed with an external cloud storage
• Governance using Unity Catalog to unify IAM
• Delta Live Tables is a product, which although relatively newer, has a great potential with the visuals of a pipeline.

Incentivized

• Query performance--for very long-term/large queries; the latest version which we are yet to commission has some improvements in this area
• User interface--the trend, query, and Excel add-ins are basic and could do with a refresh; web-based clients are a paid add-on and less full featured, so not a true replacement
• Connectivity--Wonderware System Platform driver packs are required for additional data source types, where native connectors are not provided by other products

Incentivized

• Intuitive interface
• Ease of use
• Providing FAQ or QRGs

Incentivized

The developers are able to switch between Python and SQL in the Notebook which allows the collaboration of SQL analyst and Data scientist. The integration of Mosaic AI allows users to write complex codes in natural languages. Unity catalog has centralized the security and governance features and simplified the process of maintaining it

Incentivized

AVEVA Historian, formerly Wonderware, was the best of the process tier historians in terms of reliability and functionality. It is still under development and not a "dead" product. It is also more cost effective than the more full-featured enterprise historians, such as PI, which our organization is not yet ready for. The feature set is at the right cost level, coupled with current support, were the key factors in the decision.

Incentivized

I have found Azure Databricks to be much better than Snowflake for handling bigger, diverse data types. Snowflake is much simpler and better for smaller warehousing. The real time processing is much better in Azure Databricks and we have much more language options. Snowflake is more expensive but simpler to use. Both are great for different needs.

Incentivized

• Increased efficiency, reduction in labour for preparing reports--data is available to be queried and reported with less effort
• Increased production efficiency--near real-time data availability and comparisons to historical data has been used to make faster and better operational decisions
• Increased reliability--data has been used for maintenance optimization and planning purposes

Incentivized

• The support team is amazing, they help you at every stage of the projects, from sales to delivery.
• On a framework level, it has had an amazing impact and has reduced the clients overall data platform costs by a staggering 65%
• There has been a 40% Manual work requirement on average for the clients when they move to Azure Databricks Data Platform

Incentivized