Skip to main content
Version: 1.0.0

MySQL


Replicate your data in minutes, through our UI or programatically with our APIs.

Replicate your data to MySQL in minutes#

The Katonic MySQL destination connector allows you to sync data to MySQL, without the headache of writing and maintaining ETL scripts.

Check our detailed documentation on how to start syncing data to MySQL DB.

Features of the Connector#

FeaturesSupported
Full Refresh SyncYes
Incremental - Append SyncYes
NamespacesYes

Output schema#

Each stream will be output into its own table in MySQL. Each table will contain 3 columns:

  • _Katonic_ab_id: a uuid assigned by Katonic to each event that is processed. The column type in MySQL is VARCHAR(256).
  • _Katonic_emitted_at: a timestamp representing when the event was pulled from the data source. The column type in MySQL is TIMESTAMP(6).
  • _Katonic_data: a json blob representing with the event data. The column type in MySQL is JSON.