A newer version of this documentation is available.
View Latest (v2.2)

CockroachDB Agent for Gluesync: Features Overview

Static

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.

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