Articles

Affichage des articles associés au libellé SQL
Image
  The new Cloud data pipelines   :   The principles of ELT  and  lots  of  SQL  ! For years, ETLs like BODS, DataStage, Informatica, Ab Initio or Talend have been the kings of data pipeline construction.  There was then a window of opportunity: The hardware constraints and limited performance of "on-premises" Data Warehouses suggested that transformations be transferred to third-party servers, hence the lesser success of ELTs (we think of Oracle Data Integrator, ODI).  Companies wanted to democratize the creation of data pipelines with business-oriented tools. But Cloud architectures have changed the game, particularly because of the power of Cloud Data Warehouses. Are we witnessing a massive, but SQL-boosted, renaissance of the principles that were at work in ELT? If so, how can we be part of this dynamic?    Why are companies abandoning E  T  L logic  in the Cloud?   Historical ETLs have revolutionize...