Actian Zen Connector

Overview

Actian Zen (formerly Btrieve and Pervasive PSQL) is a zero-DBA, ACID-compliant embedded database designed for the intelligent edge, loT, and mobile environments. It operates locally for low-latency processing, offers both SQL and NoSQL access, and seamlessly synchronizes data with the cloud without requiring complex ETL pipelines. Actian Zen is commonly used in industries such as retail, healthcare, and manufacturing.

This Actian Zen connector allows you to read, write, and synchronize data from your Actian Zen database directly within Zoho Creator, without exposing it to the public internet. Connectivity is handled securely through Databridge, a lightweight agent installed inside your network.

Meta Information

Connector	Actian Zen
Authentication type	Basic
Driver	Actian Zen JDBC Driver (pure Java) pvjdbc2.jar, pvjdbc2x.jar, jpscs.jar
Default port	1583 (configurable)
Data centers	US, EU, IN, AU, CA, SA, and UAE
Applicable for	C6
Website	https://www.actian.com/databases/zen/
Privacy policy	https://www.actian.com/company/privacy-policy/
Hosting support	Local / On-premise server (embedded or client-server installation)
Categories	Database Management

Setting up Actian Zen connectors

To connect Zoho Creator with your Actian Zen database, follow the steps given below:

Step 1: Download databridge

In Zoho Creator, go to Operations -> Databridge. From the list displayed, select the operating system and version that matches your host machine (for example, macOS - 64 bit). The Databridge package will be downloaded as a zip file.

Step 2: Obtain the Actian Zen JDBC Driver JARs

This connector requires three JAR files(pvjdbc2.jar, pvjdbc2x.jar, and jpscs.jar) from the Actian Zen JDBC Driver package. Obtain them using one of the methods below.

If Actian Zen is already installed on the host: The JARs are already present in the Actian Zen installation directory (typically under the bin or lib subfolder). Locate and copy them from there.

If Actian Zen is not installed: Download the JDBC SDK package from the Actian ESD portal. Select the package (v16) matching your OS(.exe for Windows or .tar.gz for Linux/macOS). Install or extract the package to obtain the JAR files.

Step 3: Install and Start Databridge

Note: If Databridge is already installed and running on this machine, then skip to Step 4

Install Databridge on the host machine where your Actian Zen database is accessible. Once installed, start Databridge. For installation instructions, see Configuring Databridge help doc.

Step 4: Place the JARs and Restart Databridge

Once Databridge is running, navigate to the actian_zen module directory inside your Databridge installation folder and create a custom_lib subfolder. Place the three JAR files in it, then restart Databridge for the changes to take effect.

macOS

Linux

Windows

macOS

# Create the folder

mkdir -p <Databridge installation folder>/services/ZohoCreator/modules/actian_zen/custom_lib

# Copy JARs into the folder

cp pvjdbc2.jar pvjdbc2x.jar jpscs.jar \

<Databridge installation folder>/services/ZohoCreator/modules/actian_zen/custom_lib/

# Restart Databridge

sudo sh bridge.sh restart

Linux

# Create the folder

mkdir -p <Databridge installation folder>/services/ZohoCreator/modules/actian_zen/custom_lib

# Copy JARs into the folder

cp pvjdbc2.jar pvjdbc2x.jar jpscs.jar \

<Databridge installation folder>/services/ZohoCreator/modules/actian_zen/custom_lib/

# Restart Databridge

sudo sh bridge.sh restart

Windows

REM Create the folder (run Command Prompt as Administrator)

mkdir "<Databridge installation folder>\services\ZohoCreator\modules\actian_zen\custom_lib"

REM Copy JARs into the folder

copy pvjdbc2.jar pvjdbc2x.jar jpscs.jar ^

"<Databridge installation folder>\services\ZohoCreator\modules\actian_zen\custom_lib\"

REM Restart Databridge

bridge.bat restart

When upgrading Actian Zen to a new major version, replace the JARs in custom_lib with the matching version and restart DataBridge.

Step 5: Connect

With Databridge running and the JARs configured, you're ready to connect Actian Zen to Zoho Creator.

In Zoho Creator, go to Operations -> Databridge and confirm that Databridge shows a status of Active.

Once Databridge is active, click Add Connection and select the Actian Zen connector.

In the Add Connection panel, your databridge is automatically selected. Fill in the remaining details to complete the required configurations and click Create and Authorize.

When the Link Account popup appears, provide the following details: username, password, host, port, and database name. Click Authorize to complete the connection.

For detailed instructions, see Configuring Databridge help doc.

Where this connector can be used

Data Sources

Actian Zen data is accessible in Creator through integration forms, integration fields, and integration reports. The table below shows supported components by module.

Module	Integration Field	Integration Form	Integration Report
Records	✓	✓	✓

Actian Zen Connector | Zoho Creator Help