ORCHESTRATE-it

Visually design your warehouse’s daily build sequence

Once you have designed your loads, transformations and cubes, you will want to combine them all into a nightly or weekly build.

ORCHESTRATE-it allows you to identify the dependencies of each object, building a sequence in which data loaders, transformations, cubes and more can be run. (You can even include custom steps such as your own SSIS packages or SQL Stored Procedures.)

Data Academy constructs a single, fully logged SSIS package, which you can schedule using the SQL Agent or your own enterprise scheduler.