CockroachDB Target Connector: expand your data integration capabilities with Gluesync

The CockroachDB target connector for Gluesync is now available to all users, expanding Gluesync’s portfolio of supported databases. This addition enables businesses to synchronize their data with CockroachDB, a distributed SQL database designed for global scalability and resilience.

CockroachDB: a distributed database solution

CockroachDB serves as a distributed SQL database that organizations can now target through Gluesync’s connector system. The integration allows for streamlined data movement from various sources directly into your CockroachDB instance.

Integration with Gluesync: More Flexibility and Control

Gluesync’s integration with CockroachDB leverages a built-in JDBC driver working through the PostgreSQL wire protocol. This architecture enables efficient and flexible data synchronization, allowing data replication from other sources directly into your CockroachDB database.

Key Features of the CockroachDB agent

The CockroachDB target connector for Gluesync includes several core technical features.

• Built-in JDBC driver integration: the connector establishes a connection to CockroachDB through a built-in JDBC driver, ensuring reliable database connectivity.
• PostgreSQL wire protocol compatibility: the connector communicates with CockroachDB using the PostgreSQL wire protocol, leveraging established and proven communication methods.
• Support for CockroachDB version 20.0 and above: compatible with CockroachDB version 20.0 and above, ensuring wide coverage for different deployment scenarios.
• Target functionality for data replication: while change data capture is not yet available for this platform, the connector provides robust target capabilities for data replication needs.

Configuring the CockroachDB as a target connector

Configuring the CockroachDB target connector is straightforward through the web interface. Here there are the configuration parameters:

• Hostname/IP Address: DNS record or IP address of your server;
• Port: optional, defaults to 26257;
• Database name: name of your target database;
• Username: username with read/write access to database tables;
• Password: password belonging to the given username.

Benefits of using CockroachDB as a target connector

Using CockroachDB as a target connector with Gluesync provides organizations with reliable data integration capabilities. The connector’s architecture, built on PostgreSQL wire protocol compatibility and utilizing a built-in JDBC driver, ensures stable and efficient data transfer operations.

The integration supports organizations running CockroachDB version 20.0 and above, making it suitable for both existing CockroachDB users and those planning to adopt the database. Through this connector, businesses can leverage data synchronization while maintaining reliable connectivity through the PostgreSQL wire protocol.

For more detailed information about how it works, you can consult our product documentation at this link.