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 |