Vertica Agent for Gluesync: Target Integration

Vertica logo screenshot

Core principles

This agent establishes a connection to Vertica via the Vertica JDBC driver.

Supported version

With this agent, you can target any Vertica deployment, whether it is under Amazon AWS, Google Cloud or Azure.

Platform supported features

Feature Support Notes

Target role

✅

Writes to Vertica via the official JDBC driver with TLS, pooling, and load-balanced connections.

Source role

❌

Vertica currently acts only as a target within Gluesync.

Snapshots

❌

Not supported, as this agent does not supporting reading from Vertica.

CDC

❌

Not supported, as this agent does not supporting reading from Vertica.

CDC type

N/A

Target-only connector.

Bulk load

✅

Supports bulk load for high-throughput snapshot operations.

Database pooling

✅

Supports connection pooling for efficient resource utilization across multiple pipelines.

Source persisted internal cache

N/A

State tracking resides in Core Hub metadata since Vertica is target-only.

Target persisted internal cache

N/A

Writes flow directly to Vertica without local disk buffers.

Driver / connector

Vertica JDBC driver

Vendor driver bundled with Gluesync for secure connectivity.

Chains

N/A

Not supported being a target-only connector.

Truncate operation support (reading)

N/A

Target-only connector.

Truncate operation support (writing)

✅

Supports the Core Hub “TRUNCATE before snapshot” option when enabled.