Saturday, October 19, 2019

SeETL ETL SQL Generation

The SeETL SQL ETL Generation Option is a simple and straightforward console command that takes your mapping spreadsheets and generates ETL as SQL directly out of the spreadsheet. This is our “latest and greatest” idea on how ETL should be built in the future.

The SQL ETL Generation feature makes the C++ ETL engine almost redundant. There are some features in the C++ Engine that can not be replicated into the SQL Language as it stands at the moment so we have to do some work arounds for those features or use the older C++ Engine.


  1. Simple, intuitive, spreadsheet interface
  2. No “coding” required
  3. Generates ETL as SQL
  4. No C++ ETL Engine Required
  5. The data does not leave the database
  6. Ideal for large data warehouses
  7. C++ Utilities and Scheduler available
  8. The “latest and greatest” way to create ETL
  9. SeETL Base Features is a pre-requisite product


The presentation below is a demonstration of the SeETL SQL ETL Generator. It is a simple tool that we use ourselves for our own SQL ETL generation.  We have published vast amounts of SQL that is generated via this tool so that you can view it for yourself and make sure you understand how it works.

There is no better and no faster way to develop ETL subsystems today. And we seriously question as to whether much improvement can be made in the future. The only room left for improvement is for more automation in the mapping process. However the mapping process is now a mere small portion of the overall project and so improvements in this area are of diminishing returns.

We invite you to watch this presentation and demonstration of our simple, fast, intuitive SQL ETL Generator.  Please remember there are more detailed video demonstrations available on our video channels and many detailed examples in our GA Package download.