DataPortia
Ignition App
Adeptia
DataSci Pro
AppWrite
Supabase
Firebase
Clerk
PocketBase.io
Xano
Convex.dev
Auth0
DataPortia is an advanced industrial data acquisition and reporting software that connects to automation systems via OPC UA protocol. It stores time-series data in a PostgreSQL/TimescaleDB database and provides a web-based interface for real-time monitoring, trend analysis, and report generation.
Key Features: - Efficient data acquisition from automation systems via OPC UA protocol - Support for multiple simultaneous OPC UA connections with redundancy - Real-time dashboard with gauges, charts, bar charts, and tables - Interactive trend views with ECharts visualization and color customization - Comprehensive reporting with CSV and PDF export - Automated report scheduling (daily, weekly, monthly, custom) - AI-powered data analysis with local Ollama LLM (anomalies, forecasts, reports) - OPC UA Alarms & Conditions management with analytics and export - OPC UA history read from server historian - Calculation circuits (cumulative and non-cumulative formulas) - Tag transfer, copy and merge between connections - TimescaleDB time-series database with efficient compression and retention - Continuous aggregates (minute, hourly, daily, weekly) for fast queries - Automatic database backup and restore with scheduling - User management with role-based permissions (local or Azure AD) - Licensing: perpetual, trial, and floating licenses - Automatic HTTPS certificate management - API interface for third-party systems - Web interface for all devices (Finnish/English/Swedish/German)
System Requirements: - Windows 10/11 or Windows Server 2016+ (or Linux) - PostgreSQL 18 + TimescaleDB extension (included in setup) - Minimum 8 GB RAM (16 GB+ recommended) - Minimum 100 GB disk space (depending on data volume)
DataPortia AppWriteAppWrite is recommended for developers building applications who require a scalable backend solution without the overhead of managing infrastructure. It is particularly suited for developers who prefer open-source platforms and those who want to avoid vendor lock-in. AppWrite's features make it a good fit for startups, hobby projects, and even educational purposes where full control over the backend is desirable.
DataPortia's answer
DataPortia is an early-stage product currently used by industrial automation companies in Finland. Our reseller partner PCS-Engineering Oy deploys DataPortia for their industrial clients. We are actively expanding to energy plants, district heating networks, and manufacturing facilities across the Nordics and DACH regions.
DataPortia's answer
DataPortia is the only industrial data acquisition software that combines on-premises AI analytics with OPC UA connectivity — all without any cloud dependency. What makes it unique:
Local AI analysis powered by Ollama LLM — your process data never leaves your network. Supports anomaly detection, forecasting, cost optimization, and natural language queries directly on your production data.
Extreme throughput: handles 2,000+ measurement points per second across 10+ simultaneous OPC UA connections, storing up to 172 million rows per day in TimescaleDB.
True on-premises architecture — no subscriptions to cloud services, no data leaving the plant. Critical for industries with strict cybersecurity and data sovereignty requirements.
4-language UI (Finnish, English, Swedish, German) built in — not bolted on. Every screen, tooltip, help page, and AI prompt works natively in all four languages.
Runs on commodity hardware — PostgreSQL + TimescaleDB instead of expensive proprietary historian databases. Compresses 126 billion rows into ~1.2 TB.
DataPortia's answer
Compared to alternatives like Ignition, WinCC, Wonderware, or AVEVA:
No cloud lock-in: Unlike cloud-based IoT platforms, DataPortia runs entirely on-premises. Your data stays in your network — no recurring cloud fees, no vendor dependency.
Built-in AI analytics: Competitors require separate, expensive AI add-ons or cloud services. DataPortia includes local AI analysis (anomaly detection, forecasting, cost optimization) out of the box via Ollama.
Lower total cost: Uses open-source PostgreSQL/TimescaleDB instead of proprietary historian databases. No per-tag licensing — connect unlimited measurement points.
OPC UA native: Connects to any OPC UA-compatible system (Siemens, ABB, Valmet, Beckhoff, Schneider, Honeywell, Rockwell) with built-in redundancy/failover.
Modern web interface: Responsive dashboards, interactive trends with drag-to-zoom, automated PDF/CSV reports — accessible from any device without installing client software.
Free 30-day trial with full functionality, including AI features.
DataPortia's answer
DataPortia serves industrial professionals who need reliable, real-time process data — without cloud complexity:
Automation engineers managing OPC UA-connected control systems (PLC, SCADA, DCS)
Plant managers at energy plants, district heating networks, and manufacturing facilities who need dashboards and automated reports
Process engineers in power generation, water treatment, waste incineration, and process industry who analyze trends and optimize operations
IT/OT professionals responsible for on-premises data infrastructure and cybersecurity compliance
System integrators deploying monitoring solutions for industrial clients (Siemens PCS7, ABB, Valmet, Beckhoff environments)
The common thread: organizations that handle sensitive industrial data and need powerful analytics without sending data to the cloud.
DataPortia's answer
DataPortia was born from a real gap in the industrial automation market. Traditional SCADA historians and reporting tools are either prohibitively expensive, locked into proprietary ecosystems, or require cloud connectivity that many industrial facilities cannot accept for security reasons.
Built by Atorcom in Karstula, Finland, DataPortia was designed from the ground up to solve this: give industrial operators a modern, affordable, and secure way to collect, visualize, and analyze their automation data — entirely on-premises.
The product evolved through direct experience with Finnish energy plants and process facilities, where the need for local AI analytics became clear. In 2025, DataPortia integrated Ollama-based local LLM analysis, making it one of the first industrial data tools to offer AI-powered anomaly detection, forecasting, and cost optimization without any cloud dependency.
Today, DataPortia connects to any OPC UA automation system and processes thousands of measurement points per second — all running on standard PostgreSQL/TimescaleDB, proving that industrial-grade performance doesn't require enterprise-grade pricing.
DataPortia's answer
ASP.NET Core 9.0 (.NET 9) — Backend framework, self-hosted Kestrel server
PostgreSQL 18 + TimescaleDB — Time-series database with hypertables, compression, and continuous aggregates
OPC UA (OPCFoundation.NetStandard) — Industrial automation connectivity protocol
Ollama — Local large language model runtime for on-premises AI analysis
Entity Framework Core 9.0 + Dapper — ORM and raw SQL queries
ECharts 5.6 — Interactive chart visualization (dashboards, trends, analysis)
Microsoft.Identity.Web — Optional Azure AD authentication
I've use it instead of Firebase on a 15$ DigitalOcean droplet and saved around ~$150 a month. Managing my own infra does take some extra time, but definitely worth it. The APIs and SDK are also surprisingly much easier to consume than Firebase. Waiting for the cloud version.
Based on our record, AppWrite seems to be more popular. It has been mentiond 178 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Initially, I was using the Supabase free tier, but I was hitting the limits, and my app was becoming stale. Then I switched to Appwrite. Both are totally different; one is SQL, while the latter one is NoSQL. Although use node-appwrite package to skip the manual schema add-ons. - Source: dev.to / 7 months ago
Appwrite is an open-source platform that simplifies backend setup by providing authentication, databases, storage, functions, and hosting all in one place. - Source: dev.to / 10 months ago
I love Appwrite. My first hackathon was actually from Appwrite (using Appwrite) 2 years ago, and I've been using it ever since. - Source: dev.to / about 1 year ago
Appwrite | Remote | Platform Engineers, AI, Interns | https://www.appwrite.careers Appwrite (https://appwrite.io) is an open-source backend platform that helps developers build secure web and mobile apps faster. We’re hiring engineers across multiple teams to improve infrastructure, expand developer tooling, and scale our platform. Open roles: – Platform Engineer. - Source: Hacker News / about 1 year ago
Appwrite is a backend-as-a-service platform that provides authentication, storage, and database. Appwrite is used for authentication and storage. - Source: dev.to / over 1 year ago
Ignition App - Reclaim time, profitability and cash flow with Ignition by automating proposals, billing, payment collection and workflows in a single platform.
Supabase - An open source Firebase alternative
Adeptia - Adeptia Connect is an application to modernize the onboarding of data within the partner ecosystem using a self-service approach for business and IT.
Firebase - Firebase is a cloud service designed to power real-time, collaborative applications for mobile and web.
DataSci Pro - AI tools for data analysis, visualization, and data reports
Clerk - Clerk.io, the artificial intelligence for e-commerce that knows your customers interests.