It enables new on-top functionalities to legacy database without stopping production
GlueSync allows you to replicate data to and from RDBMS (Microsoft SQL Server and Oracle) in real time with Couchbase. Whether the goal is to ETL, Data Offload or increase the potential of your Business Apps, GlueSync is the only zero impact plug&play tool on your infrastructure.
Strengths of GlueSync
Deploying with Docker
GlueSync is supplied inside a Docker container. It can be installed both on-premises and on the cloud.
For any information ask for MOLO17 support, our time-to-market is very fast and we are able to provide the complete solution in a few weeks starting from a PoC to managing production workloads. The professional services necessary to distribute GlueSync can be provided in person or remotely, according to your needs.
Build Vs Buy
|100+ man/days||Ready to use|
|Unpredictable costs €€€€||License fee €|
|Unknown reliability||Couchbase certified|
The Native Couchbase connector
GlueSync connector is a native Couchbase connector that connects Couchbase to the most common RDBMS. GlueSync enables 2-way data streaming in real-time with Microsoft SQL Server and Oracle Database.
Real-Time two-way in Action
Here below we have collected some frequently asked questions you may also have, otherwise if you couldn’t find yours we will be glad to answer and connect with you.
Work over WAN or Internet connections
In many scenarios happens that the RDBMS in on-premise and Couchbase is hosted in cloud (AWS, Azure, GCP, …), this is really a common use case and many are asking if it can still work over the internet (VPN, Direct Connect, WAN, NAT, …):
Many of our customers are currently using it in that way, Couchbase is for example inside AWS near GlueSync and the SQL database in on-premises. It performs well even if the connection becomes unstable thanks to the ability to resume from the last transaction checkpoint, polling intervals can also be tuned to meet bandwidth saving policies.
Replica ETL/ELT and Warehousing
GlueSync connects your RDBMS with Couchbase to enable real-time data synchronization between ERP, CRM and other business applications with your mobile or web apps. Simplifying and speeding up bidirectional synchronization between applications is now finally possible thanks to the GlueSync connector.
Oracle on z/OS support
We support 100% Oracle Golden Gate which supports also Oracle DB on z/OS natively.
What support can you offer?
We offer professional services for setup of the connector and go-live. Then we have subscription based support with SLA for development and production workloads.
How is consistency working? (broken network link, insert failed, …)
GlueSync is a stateless service, if something fails it is not a problem because we store the last checkpoint on both sides (SQL and Couchbase) and resume from that point when the process or the container is restarted.
The user can opt to receive system alerts via email or just grab them from the container logs.
How can i manage data modeling?
GlueSync purpose is to transport data from SQL tables and translate their structure to JSON documents for Couchbase. On-the-fly data modeling is not supported and there are no plans to be supported soon.
This need can be overcome using SQL views that are natively supported by GlueSync and can be used to describe the data model that you want to be reflected as JSON document structure in Couchbase, GlueSync will take care to respect & reflect that.
Can you do a full sync of large datasets also and then do change sets?
This is what the connector does at the first init and when a new table is synced, then it starts capturing the changes feed. Replica can be configured to be continuous or just snapshot. Default is continuous.
GlueSync Vs Kafka
GlueSync is lightweight and fine tuned around Couchbase, supporting native Couchbase technologies such Eventing and SyncGateway. Has also some more competitive advantages over Kafka: it can write to SQL Server instead of just reading from, it supports SQL views, it can do an initial snapshot and then resume the changes feed processing. Kafka simply doesn’t.
GlueSync Vs CDATA and others ODBC drivers
An ODBC driver for NoSQL databases helps the database engine to translate the JSON document data model and enables your application layer to query that data structure like you are querying a common relational database (RDBMS).
Unlike an ODBC driver, GlueSync is a real-time SQL to NoSQL two-ways database connector, this means it does all the job of capturing and transferring data from SQL tables or views and move them to Couchbase JSON documents, and vice-versa.
How is licensing working?
Licensing works with a paid subscription per year per node that let the user benefits from professional support and product updates.
Already compatible with Microsoft SQL Server and Oracle Database; soon also for DB2 and PostgreSQL.