Features Matrix
| Feature | Description | ||
|---|---|---|---|
| DESIGN | Model Staging Tables |  |
|
| Model Extract ETL | |
Auto Match Source to Staging Columns, Source Queries, Filters, Expressions and Derived Staging tables. | |
| Model Facts and Dimensions | |
Model Dimensions, Facts, Many to Many Joins, and Role Play dimensions. | |
| Model Transform and Load ETL | |
Define Multiple Pattern based Transforms, Multiple Staging table Sources, Joins, Matches, Filters and Expressions. Auto Match Staging to Warehouse Columns etc. | |
| Import Source System Meta Data | |
Import Source System table schema to quickly and accurately define Staging, Dimension and Fact Tables. | |
| Supports Kimball Slowly Changing Dimensions | |
Supports Type 1, and Type 2 slowly changing dimension patterns. | |
| Support Many to Many Relationships | |
||
| Define your own ETL Management Columns on Tables | |
||
| Visual Studio IDE Integration | |
Visual Studio is a free downloadable IDE from Microsoft. | |
| Source Code Integration | |
Meta Data is stored as XML files in a Visual Studio project. Visual Studio projects are compatible with standard source control systems like SVN etc. | |
| Multi User | |
Like any Visual Studio Project under source control, DW Architect projects are Multi Developer compatible. | |
| Extensible | |
Define custom Meta Data and custom Patterns. | |
| GENERATE | Generate End to End ETL Code | |
|
| Generate Staging and Data Warehouse Database DDL | |
||
| Generate Documentation | |
||
| Extensible. Create your own Generation Templates | |
Create XSLT Templates to generate your own style of DDL, ETL, or ETL Patterns for your target environment. | |
| Extensible. Generation Engine API. Create your own Generation Engines | |
Current Generation Engine uses XSLT Templates. Develop your own Engines that generate code in other way (e.g. .NET etc) | |
| Non Destructive Data Warehouse DDL Generation | |
Column Name changes are implemented as Column renames, instead of the destructive Delete and Create method of other Schema sync tools. Deletes (Column and Table) are implemented as renames, effectively soft deleting tables and columns. | |
| DEPLOY | Deploy code to target Local or Remote Servers | |
|
| Extend. Deployment Provider API. Create your own deployment providers | |
Create Deployment providers that can deploy code to specific Server applications. | |
| EXECUTE (DW Batch Manager) |
Define Batch Workflow | |
Define Batch workflows, including Batch phases, and Batch tasks. |
| Orchestration (Schedule and Execute Batch) | |
Schedule Batches to execute on a regular Basis. DW Batch Manager will Execute the Batch according to the defined workflow, and manage task execution. | |
| Capture Batch Statistics | |
DW Batch Manager captures batch statistics (Phase/Task start time, end Time, Duration etc) | |
| Dynamic Server utilization | |
Configurable Multi Threading increases ETL throughput to maximise Server utilization. | |
| Extensible. Execution Provider API | |
Create your own Phase and Task execution providers to execute ETL tasks in your target environment. | |