CockroachDB Agent for Gluesync: Features Overview

Cockroachdb logo screenshot

Core principles

This agent establishes a connection to CockroachDB via a built-in JDBC driver which works through the PostgreSQL wire protocol.

Change data capture

Change data capture is not yet available for this platform.

Supported version

With this agent, you can target any version of CockroachDB starting from 20.0.

Platform supported features

Feature Support Notes

Target role

✅

Writes to CockroachDB through the PostgreSQL wire protocol via the bundled JDBC driver.

Source role

❌

Current release supports CockroachDB only as a target.

Snapshots

✅

Snapshot batches are replicated into CockroachDB tables for initial loads.

CDC

❌

Change data capture from CockroachDB is not yet available (see note above).

CDC type

N/A

Awaiting future CDC support.

Bulk load

N/A

Standard JDBC batching is used; no dedicated bulk-staging workflow.

Database pooling

✅

Supports connection pooling for efficient resource utilization across multiple pipelines.

Source persisted internal cache

N/A

Target-only connector—no source caching required.

Target persisted internal cache

N/A

Writes go directly to CockroachDB via JDBC.

Driver / connector

Built-in JDBC driver

Uses the PostgreSQL wire protocol for connectivity.

Chains

N/A

Target-only connector.

Truncate operation support (reading)

N/A

Target-only connector.

Truncate operation support (writing)

✅

Can honor Core Hub “TRUNCATE before snapshot” when enabled.

Video Tutorial

Real time data integration between IBM i 7.4 to CockroachDB 23.1