GlueSync - SQL to NoSQL data streaming connector

GlueSync is a data replication connector for real-time event-based data streaming from RDBMS to NoSQL databases and viceversa. This means that you will be able to replicate data to and from relation and non-relational databases in real-time using native technologies officially supported and maintained by each database vendor.

You can read more about GlueSync’s native approach looking at our blog article The GlueSync Journey.

In this documentation you can find the installation and configuration steps necessary to setup GlueSync into your infrastructure and connect a RDBMS instance with a NoSQL database.

Before proceeding, for each GlueSync instance that you’re willing to deploy, please check if you have the following information:

  • RDBMS connection details, like:

    • Username

    • Password

    • Connection string (IP address / port)

    • Tables names

  • NoSQL database connection details, like:

    • Destination bucket (in Couchbase) or database (in MongoDB)

    • Connection string (IP address / port)

    • Username

    • Password

…​and also, do not miss our section dedicated to Tutorials and use cases of GlueSync: please see Tutorials and Uses Cases section.

Compatibility matrix

RDBMS edition / version GlueSync compatibility Technology used

Couchbase

✅ from GlueSync v1.0 starting from version 5.5 and above all editions

Native via Eventing service

MongoDB

✅ from GlueSync v1.3 starting from version 3.6 and above all editions

Native via Change Streams

Microsoft SQL Server and Microsoft SQL Azure

✅ from GlueSync v1.0 starting from version 2016 and above all editions

Native via Change Tracking

Oracle Database

✅ from GlueSync v1.2 starting from version 11.2g and above, all editions

Native via change data capture (CDC) via Xstream APIs licensed under Oracle Golden Gate middleware license or via GlueSync Data Capture (GDC) for Golden Gate-license-free installations

DB2 for series i (AS/400) and DB2 for z/OS

starting from version 7.2 and above

✅ writing is fully supported, ⏱ native-CDC support coming soon later this year

PostgreSQL

starting from version 9.0 and above

✅ writing is fully supported, ⏱ native-CDC support coming soon later this year

Sybase SQL (Adaptive Server Enterprise, ASE)

starting from version 12.5 and above

✅ writing is fully supported, ⏱ native-CDC support coming soon later this year

MariaDB

starting from version 12.5 and above

✅ writing is fully supported, ⏱ native-CDC support coming soon later this year

MySQL

starting from version 12.5 and above

✅ writing is fully supported, ⏱ native-CDC support coming soon later this year

Minimum system requirements

  • a docker environment

  • 1 vCPU and 2GB of RAM

  • 1 GB free disk space, used for logging redaction