ActiveWarehouse ETL 0.9.0 is now available. This release adds support for .ebf files, which are "ETL Batch Files". These files can be processed by the AW ETL library to execute batches of ETL control files. Currently the behavior is limited to two items:

* run "file.ctl" will run a control file
* use_temp_tables will run all items in the batch using temp tables to store the items until the batch is complete, at which point the temp tables will replace the normal tables. Note that these are actual tables that are prefixed with tmp_ and that will live beyond a server restart.

Another new feature is support for screen blocks. There are three types of screen blocks: warn, error and fatal. An example of a screen block:

screen(:error){
ETL::Screen::RowCountScreen.new(self, :rows => 1)
}

You can also use Test::Unit::Assertions directly in your screens.

Connections are now retrieved through ETL::Engine.connection(:connection_name). Connections are defined in database.yml in the current working directory.

Finally, DateDimensionBuilder is now part of AW ETL in the module ETL, as are the Time calculation extensions for fiscal year support.

Enjoy!