It enables new on-top functionalities without stopping production
GlueSync allows you to replicate data to and from RDBMS (Microsoft SQL Server, Oracle and DB2) in real time with Couchbase. Whether the goal is to Data Offload or increase the potential of your Business Apps, GlueSync is the only zero impact plug&play tool on your infrastructure.
Why choose GlueSync?
Other tools VS GlueSync
- Bad time-to-market
- Lot of Coding / customization needed
- DIY approach
- General purpose
- Deploy in minutes
- Ready out-of-the-box
- Support with SLAs
- NoSQL vendor 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.
Strong complementary technology offering as modern as the core Couchbase End-to-End DataManagement platform that it feeds.
- Stream your data from RDBMS to Couchbase and vice versa without burden your app to handle any write-back mechanisms
- Offload your legacy RDBMS infrastructure towards a modern and future-proven backbone with Couchbase without taking your app down!
- Remodel your data to nowadays SLA needs on-the-fly while piping it end-to-end
We look forward to our collaboration
Real-Time two-way in Action
Trusting in our technology
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.
Oracle on z/OS support? DB2 or AS400 systems? PostgreSQL?
We support 100% Oracle database on z/OS natively.
Please refer to our compatibility matrix available in our documentation page to discover which databases / version are supported by GlueSync: http://gluesync.com/docs/gluesync/v1.2.0/index.html#compatibility-matrix
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 (RDBMS and NoSQL) 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?
We do support data modeling. The feature is called on-the-fly data modeling and it supports both custom queries and SQL views 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 NoSQL JSON documents, and vice-versa.
Pricing / support questions
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 licensing works?
Enterprise licensing works with a paid subscription per year per number of CPUs running on NoSQL data nodes. Enterprise license 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.