facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo

Zero-Administration, Embeddable, Nano-Footprint Edge Data Management

Edge applications and devices increasingly rely on AI to improve automation and end-user decision support – whether that be human or machine – in stand-alone, peer-to-peer, local network, cloud or a mixed environment. The underlying edge data management must be capable of leveraging a variety of hardware architectures, operating environments, networks, communications interfaces, and programming and scripting languages for the applications that make use of these resources. The Actian Zen Edge Data Management solution delivers against this broad and demanding set of requirements.

Simplicity Icon


Single, secure, scalable architecture supports concurrent read and write, NoSQL and SQL across all popular embedded environments

Speed Icon


Faster than leading purpose-built DBs at time-series, JSON-based or BLOB document store, and orders of magnitude faster than SQLite

Security Icon


Provides AES 256-bit Encryption for data at rest and transports that data without ETL between devices, gateways, branches and cloud

Sync Icon


Avoid ETL between devices, gateways, branch and cloud environments – improve speed, integration cost, remove security vulnerabilities

Plurilogic extends Pluriportail with campus-wide student and asset tracking using Actian Zen Edge and RF-ID

Tracking attendance and assets using RF-ID technology and embedded database systems on K-12 and higher education campuses

“With Actian Zen data management products, we’ve been able to extend our integrated solutions in the classroom and across campuses to better track and manage students and institutional assets, extending our capabilities to IoT and mobile devices.”

Friends don’t let friends use flat files

It made perfect sense in the past but dealing with ETL, your own data security, portability, indexing, time-stamping, and a host of other features built-in to modern edge data management solutions no longer has to be a trade-off against some complex database that doesn’t fit your edge use case. With Zen you get the simplicity of file system APIs with the robust functionality of a real-time database.


Actian Zen: Zero-DBA, Embedded, Nano-footprint, Multi-Model, Multi-Platform

Zen Product Marketecture
  • Single architecture – from device to gateway, from server to cloud
  • Multi-model, multi-platform, embedded in most popular languages
  • No-ETL between clients, servers, and cloud
  • Modular: 7MB client to 50MB server to full Enterprise under 200MB
  • AES 256-bit military-grade encryption
  • Embed in apps, configurable through APIs
  • Built-in automated defragmentation
  • Single data file/table size of 64 TB

Tsubakimoto’s Material Handling System is capable of sorting up to 10,000 items per hour.

Actian Zen is the database infrastructure, supporting extremely high-speed conveyor belt operations in manufacturing and transportation and logistics

“From our first adoption to the present of course, we have considered changing data base several times, but when it came to an actual performance test, other powerful databases could not reach Actian Zen’s reading and writing speed at all.”

SQLite … good enough just isn’t in today’s demanding use cases

Actian Zen Editions

Actian Zen Core

For mobile/IoT devices

Dedicated DB Engine with NoSQL API and SQL

Embeds directly in apps as packaged libraries

Client and Peer-to-Peer

7 MB footprint

Royalty-free development and deployment

Learn More

Actian Zen Edge

Embed in Edge gateways and complex machinery

Full Client-Server functionality

>100s of concurrent users

50MB footprint

Learn More

Actian Zen Enterprise

Actian Zen Workgroup for Windows

Embed/bundle with ERP Vertical, and other complex apps

>1000s of concurrent users for branch or central office

175MB footprint

Learn More

Actian Zen Cloud Server

Cloud-ready version of Zen Enterprise

Runs in VMs and Containers

Embed/bundle in complex SaaS apps or managed services

Learn More

Shared by all Editions

Single modular architecture, code once, run anywhere

Zero ETL between Zen and PSQL products ensures lower integration and time to completion


AES-256 bit encryption for data at rest plus Zero ETL avoids decryption between point of development and final deployment

Singe data table/file size maximum of 64TB

Add-On Software

Actian DataExchange

Exchange data and two-way synchronization of Zen and PSQL databases

Backup and recovery to/from multiple remote replication sites

Built in 256-bit encryption

Separate replication event handler and replication engine ensure zero impact on operational databases

Actian Backup Agent

Backup operational Zen and PSQL databases

Works with all major 3rd party backup software

API for use embeds in your application

Maintains data integrity and continuity without service interruptions

Actian AuditMaster

Generates logs of all DB events, delivering a detailed audit trail

No changes to the application needed

Query and alert capability configurable against specific compliance and security policies

Support diagnosis and data recovery of before/after images

Real-time support of operational Zen and PSQL databases

Shared by all add-on software

API from CLI or embeds directly in your application

Windows 10 and Windows Server 2016 support

Embeddable APIs and configurable dashboards for remote management

Upgrade from PSQL to Zen

The Use Cases for Edge Intelligence are everywhere and in every industry.

From chronic disease management in healthcare to digital twinning in manufacturing, the breath and depth of use cases for edge intelligence is seemingly limitless. The growth of IoT and Mobile and the coming infusion of AI into them is driving the need to harness and exploit the underlying data at the edge rather than simply tossing it or sending it back to the Cloud.

Eight Indicators you need to modernize your Edge Data Management


  1. Do you need to analyze and make real-time decisions at the point of action?
  2. Are you capable of managing large sets of local and shared persistent data at the Edge?
  3. Do you need to run on multiple OSes from Android/iOS to Windows/Linux?
  4. Do you use multiple programming and scripting languages to develop your Edge applications?
  5. Do you support varied types of data: JSON, BLOB, traditional structured, etc.?
  6. Are you struggling to support standalone, Peer-to-Peer, Client-Server, Internet/Intranet architectures?
  7. Do you operate as stand-alone during periods of dis-connectivity?
  8. Can you handle high-speed, multi-channel data collection and local Machine Learning inference?


If you’re struggling with any of these questions, you’re probably struggling with your Edge Data Management and need to modernize.

Embedded Database Management for IoT and Edge Environments

Edge Intelligent applications will need to embed sophisticated data management but Developers don’t want to become Database managers or deal with a myriad of them.  Here’s some challenges, constraints, and issues they should consider.

Bringing the IoT to ERP: One Stop Shopping for Global Shop Solutions

Global Shop extends its use of Actian Zen Enterprise Server in its ERP software to shop floor IoT with Actian Zen Core.

“With the evolution of the Zen architecture, we can now deploy a small footprint/IoT-enabled database that can run in a serverless mode with just client libraries. That opens up whole new opportunities for customers to put inexpensive IoT-enabled devices into settings that used to require expensive PLC devices.”

Zen Python demo for Facial Recognition on a Jetson board

On a Jeff Fritz podcast, Tom Bates from Actian describes how he used Open Source ML routines  and cameras to do real-time facial recognition detection and Zen DB storage on a Jetson.

Finally, a Developer Centric NoSQL/SQL Engine that covers all your Edge Data Management Requirements.

Developers are increasingly faced with the need to leverage flat files for resource constrained or real-time data collection and storage, SQLite for client-only platform universality, and several databases to individually address JSON/Document data, time-series, and of course traditional structured transaction data.

With Actian Zen, developers get a simple NoSQL API (or alternatively, Actian Zen also offers full SQL with ACID compliance) that covers all their standalone embedded application needs at the device or gateway level and publish-subscribe support for 100s or 1000s of downstream devices or upstream servers in traditional client-server, intranet or Cloud configurations. And, all this capability can be accessed as CLI or through most popular programming and scripting languages.


Teach yourself Zen

View Now


Join in the conversation with other Zen/PSQL experts

View Now

Component 24 – 1

Visit the Zen Documentation Center

View Now


Watch a Deep-Dive Developer Conversation on Zen with Code Project’s Jeff Fritz

View Now

SQLite … good enough just isn’t in today’s demanding use cases

Why Cloud Data Warehouse

Want a free 30-day evaluation or already own Zen and need additional copies?

Download Now


Zen Core for Android and iOS now Royalty-Free

View Now

Upgrade from earlier versions of PSQL to Zen

Packaged and priced for the Embedded OEM market and Operational Technology

Actian Zen is based on PSQL and is backward compatible to 1994 and each version is supported at least seven years.


Find a Local Zen Partner

View Now


Zen Core for Android and iOS now Royalty-Free

View Now


Actian Licensing Support

View Now


Visit the eCommerce Site

Go Now

Component 21 – 1-2
Component 22 – 1-2
Component 23 – 1

Got a Quick Question About Actian Zen?