How to join MySQL CDC and Rserve

Discover how to join MySQL CDC with Rserve for integrated analysis.

WITH PIPES OR PIPES PROFESSIONAL
How to join MySQL CDC and Rserve with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to join MySQL CDC and Rserve with Logical Data Warehouse


About MySQL CDC

MySQL is a popular open-source RDBMS (relational database management system) and offered under two different editions: the open source MySQL Community Server and the proprietary Enterprise Server. The MySQL Enterprise Server is differentiated by a series of proprietary extensions which install as server plugins but is built from the same code base. In databases, change data capture (CDC) is a set of software patterns used to determine and track data that has changed so that action can be taken using the changed data.

About Rserve

Rserve is a TCP/IP server which allows third-party programs to use facilities of R from various languages without the need to initialize R or link against the R library. Every connection has a separate workspace and working directory. Rserve supports remote connection, authentication and file transfer. Typical use is to integrate the R backend for the computation of statstical models or plots in other applications.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to MySQL CDC, Rserve and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE DATA ACCESS

Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.

CENTRAL DATA MODEL

Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.

ALL IN SQL

With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL-TIME REPORTING

Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.