• +972.2.5799113
  • hello@dbs-h.com

Continuous data integration between SQL and NoSQL/SQL databases

CR8 to data lake

CR8™ allows relational and Big Data databases to run side-by-side.

EASILY LINK SQL TO NoSQL STRUCTURE

USER-FRIENDLY STREAM MONITORING

Let’s get started!

Request a demo
logo_cr8

CR8 is a plug-and-play software solution that enables continuous, real-time data integration between relational SQL source databases and unstructured NoSQL or other SQL target databases.

The CR8 solution provides non-stop data integration by capturing, transforming, routing, and delivering database transactions across heterogeneous database platforms with negligible impact on system performance.

CR8 uniquely complements continuous data management in any organization by performing  real-time continuous data replication at very low cost. The ability to integrate data on an ongoing basis improves business operations by ensuring that mission-critical enterprise data is available when and where it is needed, without compromising data integrity or affecting system performance.

CR8 works according to logical replication (a change data capture model), where replication is based on mined transaction log files.

Original statements are extracted from the transaction log files, and data changes are applied on the target database.

Continuous capture of all database modifications allows for a wide spectrum of possibilities, such as data transformation, data enrichment, data distribution, replication of only a sub-set of data, and data consolidation when different databases are replicated in a single data lake.

The core of the CR8 solution replicates database transactions based on log files. Operating independently from the source database system, CR8 continuously fetches database transactions from log files of the source system, parses transaction log files into a generic readable format, and sends apply commands to the target database.

Streaming options

SQL to Kafka – Stream each insert, update and delete to Kafka where transformation and enhancement tools can be activated to create unified formatted data for downstream consumption.

SQL to PostgreSQL – Stream data to SQL targets so that existing SQL-based corporate reporting and analytics tools can be reused on the new data lake.

SQL to GraphDB – Sophisticated streaming of legacy SQL data transactions to Graph databases to enable non-standard operations on SQL data. Relations are mapped and maintained between SQL based data elements for real time view of dynamically related information.

SQL to MongoDB – Easily incorporate Document-based technology into your core IT landscape by streaming business critical data transactions to MongoDB. Once in MongoDB, utilize its unique strengths to enhance your competitive edge.

SQL to Elastic – Streaming SQL-based data to Elastic enables free text search capabilities on complex SQL elements with no development needed on the core SQL side.

Stream to Cloud – enable hybrid clouds in your organization by utilizing Cloud structures in parallel to existing legacy, on-premise systems. CR8™ can stream to Cloud based NoSQL targets or to Cloud storage such as Amazon S3 or Google Big Query.

Multi-level connectivity

Many2One streaming (many SQL sources to one unified target) for consolidated analytics and reporting – Achieve consolidation of multiple similar databases for global view of distributed data sources

One2many streaming (read once, write to many different targets) – utilize CR8™ to distribute data transactions to multiple technologies (such as Hadoop, document, graph) to take advantage of the best technologies for each Use Case.

Supported platforms

Sources

  • Oracle (including RAC 12c)
  • Oracle Exadata
  • MS SQL Server
  • IBM DB2 (z/OS)
  • Ingres
  • Sybase

Targets

  • Hadoop HDFS/HBase
  • Kafka
  • MongoDB
  • Oracle
  • MS SQL Server
  • PostgreSQL
  • Amazon S3/RDS/Aurora
  • Google Big Query/Cloud Storage
  • Azure SQL/CosmosDB
  • Neo4j
  • Elastic
  • Gigaspaces InsightEdge
  • Snowflake
  • TIBCO
OnPrime_cloudb_onGeen

Near real-time integration

setup

Setup within minutes

UserFriendly

User-friendly interface

support

Dedicated support team