We’ve just released a new feature for Ajilius, a one-click generation of all scripts for a warehouse.
In previous releases you ran each script manually. This was a little tedious if you wanted to run an entire load process from within the Ajilius application.
Now, you can select the Script All option from the Warehouse menu, and a full set of ELT scripts will be generated from the session warehouse metadata.
You will be shown a script screen with the full warehouse DDL in the left pane, and a script to run all ELT processes in the right pane. Use the Create and Run buttons to perform an end-to-end build of your data warehouse.
Ajilius. Eliminating repetition in Data Warehouse Automation.