1660317469873 Ct2105coverdataanalyticsherov3

Updated toolbox for analytics

May 24, 2021
The roster of data analytics software, services and support accessories fluctuates quickly and widely. Here are some of the latest players.

Amazon Timestream is a time-series database service for IoT and operational applications that can store and analyze many events at less cost than relational databases.

Apache Kafka open-source, distributed streaming platform for real-time analytics. It reports that it delivers messages at network-limited throughput using a machine cluster with latencies as low as 2 milliseconds; safely store data streams in a distributed, durable, fault-tolerant cluster; efficiently stretch clusters  over availability zones, or connect separate clusters across geographies; scale production clusters up to 1,000 brokers, trillions of messages daily, petabytes of data and hundreds of thousands of partitions; and expand and contract storage and processing.  

Cassandra, or Apache Cassandra, is a free, open-source distributed database management system designed to handle lots of data across servers with high availability with no single point of failure.

Cloudera provides Apache Hadoop-based software, support, services and training.

deviceWise from Telit is an IIoT platform that lets users automatically connect devices and applications; seamlessly integrate around existing system architectures or build new ones; collect, analyze and visualize machine data; create dashboards with drag-and-drop logic widgets; and turn data into key performance indicators without requiring custom code to link IoT and enterprise applications. 

FactoryStudio software and FrameworX agnostic, non-instrusive IoT engine from Tatsoft aggregate, process, analyze and visualize real-time data. Their open standards and native interfaces with existing SCADA systems and historians let users implement a device-centric approaches that easily accesses, streams and interprets real-time production data.

Hadoop, or Apache Hadoop, is an open-source, Java-based programming framework that supports processing and storage of large data sets in a distributed computing environment with MapReduce programming. It divides files into large blocks, sends them to a cluster's nodes, and moves code packs into those nodes to parallel process information.

Intelligence Hub software from HighByte provides connectivity to technologies like OPC UA, MQTT, SQL, Azure, AWS and REST-based web services, providing a user experience that's natural for operations personnel, while creating the necessary models to meet the requirements of IT. It serves as a generalized DataOps layer that can take in any kind of data, model it for data governance, and automatically transform the results into a format that can be ingested by Azure, AWS, other databases or historians, or any other platform that may need to use it.

This provide one place where users can document what assets are where, and report what they're are doing. This preparation includes removing noise from signals, normalizing data with the same units and definitions, and contextualizing data by adding metadata.

KEPServerEX from Kepware a connectivity platform that provides one source of automation data to all of a user's applications. Its design lets users to connect, manage, monitor and control diverse automation devices and software applications through a single, intuitive user interface. KEPServerEX networks via OPC and IT-centric communication protocols, including SNMP, ODBC and web services.

Node-RED is a flow-based development tool for visual programming that can be used for data analytics. It was developed for wiring together hardware devices, APIs and online services for IoT, and uses a web browser-based flow editor to build JavaScript functions. Application elements can be shared and saved for reuse. Flows created in Node-RED are stored using JSON, and MQTT nodes can make properly configured TLS connections.

Konstanz Information Miner Analytics Platform is free, open-source software for creating and "productionizing" data science. It accesses, merges and transforms data from all sources; models and visualizes information to make sense of it with user-selected tools; supports enterprise-wide data science practices; and leverages insights gained from data. 

Mongo DB is a free, open-source, cross-platform, document-oriented database program classified as a NoSQL database program, and uses JSON-like documents with schemas.

MySQL is an open-source database and Oracle's big data intelligence platform and application. Dynamic SQL is a programming method that lets users build SQL statements dynamically at runtime.

PI System software from OSIsoft connects sensor-based data, operations and people to manage process efficiency, asset health, quality and resource management. It works through server-based technology, makes historical and real-time data immediately accessible, and gives users end-to-end enterprise visibility.

Power BI from Microsoft is a business analytics service that delivers business intelligence and interactive visualizations via a simple interface that lets users create dashboards and reports. It delivers cloud-based BI services, as well as a desktop-based interface, and provides data warehousing, including data preparation, data discovery and interactive dashboards.

Seeq is a software application dedicated to process data analytics, which lets users search data, add context, cleanse, model, find patterns, establish boundaries, monitor assets, collaborate in real time, and interact with time series data. It connects to and works with all types of process data historians.

Snowflake is cloud-based data platform and fully-managed service that’s simple to use, but can power nearly unlimited, concurrent workloads. It's used for data warehousing, data lakes, data engineering, data science, data application development, and for securely sharing and consuming shared information. Snowflake's architecture logically separates and natively integrates storage, computing and services. This lets users and their data workloads access one data copy without impacting performance. The company adds that it abstracts the complexity of underlying cloud infrastructures, allowing users to run data solutions seamlessly across multiple clouds and regions for one, consistent experience. 

SQL Server Analysis Services (SSAS) from Microsoft is an online, analytical processing and data mining tool in Microsoft SQL Server. SSAS analyzes data spread over multiple files, tables or databases. Microsoft business intelligence and data warehousing services in SQL Server include integration, reporting and multidimensional and tabular analysis. 

Tableau is data visualization software that joins databases and graphics.

TrendMiner is a predictive analytics tool for the process industries, while its Context Hub software is designed to integrate input from laboratory information management systems (LIMS), enterprise resource planning (ERP) and computerized maintenance management systems (CMMS) and other sources, and provide a holistic view of all of them. It can also download data from Excel files, perform time-series analytics (TSA), and put production data in contexts used by LIMSs, ERPs and CMMSs.

About the author: Jim Montague
About the Author

Jim Montague | Executive Editor

Jim Montague is executive editor of Control. 

Sponsored Recommendations

Measurement instrumentation for improving hydrogen storage and transport

Hydrogen provides a decarbonization opportunity. Learn more about maximizing the potential of hydrogen.

Get Hands-On Training in Emerson's Interactive Plant Environment

Enhance the training experience and increase retention by training hands-on in Emerson's Interactive Plant Environment. Build skills here so you have them where and when it matters...

Learn About: Micro Motion™ 4700 Config I/O Coriolis Transmitter

An Advanced Transmitter that Expands Connectivity

Learn about: Micro Motion G-Series Coriolis Flow and Density Meters

The Micro Motion G-Series is designed to help you access the benefits of Coriolis technology even when available space is limited.