right now we are analysis the need of data warehouse and data mart as well as ETL.
our oracle database has some ETL by batch process, we don't know what it is but in system diagram we have ETL.
and we use replicate technology to replicate data from OLTP to 2x other DB for reporting purpose but we do not use the oracle data warehouse builder to create a data warehouse.
question now is, why and when should we use mariaDB AX to create a separate data warehouse for reporting purpose as existing model already can handle loading, why need to redesign one using MariaDB AX to do reporting ?
data mart on MySQL/MariaDB is REALLY necessary ? can it be done on MySQL and MariaDB?
please share your thought.