
Never use SQL again for ETL – Pentaho Data Integration reusable flows instead
Since Pentaho is free and PDI is so easy, our team no longer will use any stand-alone SQL as part of our extract transform and load (ETL) process. Many times we have determined that we only need to extract the data ‘one time’. Inevitably, we need to run it again or something very similar. It …