Apache IoTDB vs Cumulocity IoT

Apache IoTDB is an open-source industrial IoT time-series database for collecting, storing, managing, and analyzing device data across edge and cloud deployments. The project describes high-speed writes for millions of networked devices alongside fast reads. Query features include aligning time across devices and sensors, time-series computation, and aggregation by time dimensions. Ingestion options include IoTDB-SQL, JDBC, Java, C++, Python, and Go native APIs, REST, MQTT, CSV, and TsFile. Named analysis ecosystem examples include Hadoop, Spark, Flink, and Grafana. Deployment options include cloud installation, a desktop terminal tool, and synchronization between cloud and on-premise machines. The REST service is disabled by default and uses Basic Authentication except for the health check endpoint. Data and cluster permissions can be managed through users, roles, and privileges. The homepage states disk storage can cost less than $0.23 per GB. The project lists energy, aerospace, transportation, steel, and other IoT scenarios. Its JDBC documentation cautions that insert operations may not provide high-performance writing and recommends the Java Native API for Java applications.

Cumulocity IoT connects and manages equipment, turns device data into context, and supports application building and operational decisions. Devices can connect through HTTP REST, MQTT, native LWM2M, LoRa Network Server integration, or certified gateways. Management tools cover onboarding, configuration, connectivity monitoring, remote troubleshooting, replacement, and over-the-air software and firmware updates. The platform normalizes device data and provides real-time analytics and dashboards; optional DataHub supports SQL queries through standard ODBC/JDBC interfaces. Deployment options include cloud SaaS and on-premises Cumulocity Edge, including air-gapped operation. Security controls include X.509 authentication, device-initiated connections, secure remote access, and fine-grained permissions; multi-tenancy and role-based access control manage separation and access. Starter costs €215 a month, billed annually, and includes 2.5M messages monthly, one tenant, 30-day data retention, and a 95% uptime guarantee. A 30-day trial supports up to 10 devices.