Exit Oracle Data Integrator (or other ELT), Migrate and sustainably break the complexity of flows.
Exit Oracle Data Integrator (or other ELT), Migrate and sustainably break the complexity of flows. ODI (Oracle Data Integrator), and other "legacy" ELT solutions automatically generate SQL queries that run directly in the database. We won't teach you anything . The ELT engine generates new nested subqueries and joins as the system evolves. Transformations end up being buried in gigantic SQL blocks. And teams sometimes don't understand much about it anymore. In addition, the old ELTs are strongly challenged by IS modernization projects whose cornerstone is often a "move to Cloud". Cloud-native ELTs that use the same logic as their "ancestors" are booming: Matillion, DBT, Dataflow (Google) or Glue (Amazon).... They are associated with super-powerful Cloud databases like Redshift, BigQuery or Snowflake. The combo is impressively efficient! In a migration context, it will be a question of moving the transformations from the source t...