How to join MySQL CDC and Mail Attachements

Discover how to join MySQL CDC with Mail Attachements for integrated analysis.

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 Mail Attachements

This connector can load data from mail attachments into a data warehouse. For example many people get their BI reports as a zip file attachement via email once a day. Then they need to download the file, unpacked it and import it in f.e. Excel. With this new connector one can do it automatically.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to MySQL CDC, Mail Attachements 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 ACCESS TO DATA

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

CENTRAL DATA MODEL

Set uniform definitions for their data and apply them to their analysis tools, regardless of the underlying data source.

ALL QUESTIONS IN SQL

With Data Virtuality you can query all data sources with SQL. 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 their organization get the information they need.