Case Study: Universal Music Group achieves transactional MySQL-to-AS400 sync with Etlworks

Universal Music Group enables near real-time MySQL-to-AS400 sync with Etlworks

Universal Music Group, the world's leading music company, faced the challenge of synchronizing transactional data from its MySQL databases to AS400 systems while maintaining transactional integrity and applying complex column-specific transformations. They selected Etlworks to build a robust Change Data Capture (CDC) pipeline that could handle these intricate requirements.

Using Etlworks, UMG implemented a solution that provided transactional replication with start/commit consistency, advanced JavaScript transformations, and efficient merge operations for inserts, updates, and deletes. The results included complete transactional consistency between systems, enhanced data quality, and near real-time synchronization, all achieved without impacting the performance of their source or target databases.

Universal Music Group