MySQL Forums
Forum List  »  Analytics, Reporting, BI

Real-time replication vs ETL - How analytics requires new technologies designed for it, not '70s technology
Posted by: Petri Virsunen
Date: November 02, 2017 06:03PM

There are many ways of moving data from source databases into your target system. Historically, the Extract, Transform, and Load (ETL) has been the method for moving data effectively between databases and analytics platforms. But ETL is no longer the right solution for the modern data-movement needs. Back in the early days of data movement extraction on a monthly, weekly, even daily basis could be enough. Today, analytics often needs to be execute same day, sometimes even within seconds of the original data being generated. Replication, where information is moved in near real-time, provides a more efficient, and quicker data movement solution.

In this webinar, we will review:
- How ETL operates
- How CDC operates
- Replication operation
- Comparing data movement cadence
- The data impedance mismatch.

Wednesday, November 8th. Register at http://bit.ly/2lxfLlW

Options: ReplyQuote


Subject
Written By
Posted
Real-time replication vs ETL - How analytics requires new technologies designed for it, not '70s technology
November 02, 2017 06:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.