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
    565 Ratings
    Company Website
  • Google Cloud SQL Reviews & Ratings
    552 Ratings
    Company Website
  • Teradata VantageCloud Reviews & Ratings
    1,107 Ratings
    Company Website
  • Google Cloud BigQuery Reviews & Ratings
    2,018 Ratings
    Company Website
  • Caller ID Reputation Reviews & Ratings
    34 Ratings
    Company Website
  • Docket Reviews & Ratings
    59 Ratings
    Company Website
  • Quickbase Reviews & Ratings
    2,799 Ratings
    Company Website
  • Yeastar P-Series PBX System Reviews & Ratings
    116 Ratings
    Company Website
  • Dragonfly Reviews & Ratings
    16 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

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

Integrations Supported

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

API Availability

Has API

API Availability

Has API

Pricing Information

Pricing not provided.
Free Trial Offered?
Free Version

Pricing Information

4000€/one-time
Free Trial Offered?
Free Version

Supported Platforms

SaaS
Android
iPhone
iPad
Windows
Mac
On-Prem
Chromebook
Linux

Supported Platforms

SaaS
Android
iPhone
iPad
Windows
Mac
On-Prem
Chromebook
Linux

Customer Service / Support

Standard Support
24 Hour Support
Web-Based Support

Customer Service / Support

Standard Support
24 Hour Support
Web-Based Support

Training Options

Documentation Hub
Webinars
Online Training
On-Site Training

Training Options

Documentation Hub
Webinars
Online Training
On-Site 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-opc-ua-reporting-software

Categories and Features

Database

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

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