Ratings and Reviews 0 Ratings

Total
ease
features
design
support

This software has no reviews. Be the first to write a review.

Write a Review

Ratings and Reviews 1 Rating

Total
ease
features
design
support

Alternatives to Consider

  • RaimaDB Reviews & Ratings
    12 Ratings
    Company Website
  • DbVisualizer Reviews & Ratings
    585 Ratings
    Company Website
  • Google Cloud SQL Reviews & Ratings
    554 Ratings
    Company Website
  • Teradata VantageCloud Reviews & Ratings
    1,121 Ratings
    Company Website
  • Google Cloud BigQuery Reviews & Ratings
    2,027 Ratings
    Company Website
  • Criminal IP Reviews & Ratings
    457 Ratings
    Company Website
  • Yeastar P-Series PBX System Reviews & Ratings
    116 Ratings
    Company Website
  • Dragonfly Reviews & Ratings
    16 Ratings
    Company Website
  • StrongDM Reviews & Ratings
    102 Ratings
    Company Website
  • CompanyCam Reviews & Ratings
    5,585 Ratings
    Company Website

What is PipelineDB?

PipelineDB acts as an enhancement to PostgreSQL, enabling the effective aggregation of time-series data specifically designed for real-time analytics and reporting needs. It allows users to create continuous SQL queries that consistently compile time-series data while only saving the summarized results in conventional, searchable tables. This method resembles extremely efficient, self-updating materialized views that do not require manual intervention for refreshing. Importantly, PipelineDB does not write raw time-series data to disk, which significantly boosts the performance of aggregation operations. The continuous queries produce their own output streams, facilitating the easy integration of various continuous SQL processes into intricate networks. This capability guarantees that users can develop sophisticated analytics solutions that adapt in real time to incoming data, making it a powerful tool for data-driven decision-making. Moreover, the ability to link multiple data streams enhances the potential for comprehensive insights from diverse datasets.

What is DataPortia?

DataPortia serves as an advanced on-premises platform for capturing and reporting industrial data, boasting integrated AI analytics capabilities. It effortlessly connects with a variety of automation systems using the OPC UA protocol, which is compatible with brands like Siemens, ABB, Valmet, Beckhoff, Schneider, Honeywell, and Rockwell, enabling the acquisition of over 2000 measurement points per second while storing time-series data in PostgreSQL or TimescaleDB. Key features include: - Dynamic real-time dashboards that showcase gauges, charts, bar graphs, and tables for enhanced data visualization. - Interactive trend analysis powered by ECharts, which offers a drag-to-zoom functionality for improved user interaction. - Comprehensive reporting features that allow data export in both CSV and PDF formats. - The capability to automate report scheduling on a daily, weekly, monthly, or customized basis, optimizing operational workflows. - AI-powered data analytics facilitated by a local Ollama LLM, which provides insights into anomalies, forecasts, cost efficiencies, and personalized reports, all independent of cloud reliance. - Management capabilities for OPC UA alarms and conditions, alongside analytical tools and data export options. - Direct access to read OPC UA history from the server's historian for streamlined data retrieval. - Support for calculation circuits, accommodating both cumulative and non-cumulative formulas to satisfy a range of analytical requirements. - Features that enable the transferring, copying, and merging of tags across connections, which enhances data management flexibility. - A robust TimescaleDB time-series database designed for efficient data storage and retrieval, ensuring the effective handling of large datasets. Overall, this extensive array of functionalities establishes DataPortia as an essential resource for contemporary industrial data management, making it integral to the optimization of operations and decision

Media

Media

Integrations Supported

Luzmo
PostgreSQL
Vertica

Integrations Supported

AADvance Control System
ABB Ability System 800xA
AVEVA InTouch HMI
CitectHMI
SIMATIC HMI
SIMATIC PCS 7
SIMATIC PCS neo
SIMATIC SCADA
SIMATIC STEP 7
SIMATIC WinCC
Valmet DNA

API Availability

API Availability

Has API

Pricing Information

Pricing not provided

Pricing Information

4000€/one-time
Perpetual licensed.
Price will scale by the number of OPC UA connections.
Free Trial Offered?

Supported Platforms

SaaS

Supported Platforms

Windows
On-Prem
Linux

Customer Service / Support

Web-Based Support

Customer Service / Support

Web-Based Support

Training Options

Documentation Hub

Training Options

Documentation Hub
Online Training

Company Facts

Organization Name

PipelineDB

Company Location

United States

Company Website

github.com/pipelinedb/pipelinedb

Company Facts

Organization Name

Atorcom

Date Founded

2018

Company Location

Finland

Company Website

atorcom.fi/en/dataportia

Categories and Features

Database

Data Security
Mobile Access
NOSQL
Performance Analysis
Queries
Relational Interface

Categories and Features

Popular Alternatives

TimescaleDB Reviews & Ratings

TimescaleDB

Tiger Data

Popular Alternatives

TimescaleDB Reviews & Ratings

TimescaleDB

Tiger Data
Robyn Reviews & Ratings

Robyn

Meta
Seeq Reviews & Ratings

Seeq

Seeq Corporation