Go from Novice to having a deployed Kimball Data Warehouse in 1/3 the time with our Data Warehouse Generation Tool.

The journey from novice to gaining in-depth knowledge and experience in the Data Warehousing field can be a long and difficult journey. We have distilled all the principles and designs of Ralph Kimball into our ‘DW Architect’ Rapid Data Warehouse development tool.

‘DW Architect’ allows you to easily design, generate, deploy and execute a Data Warehouse and its Extract Transform and Load (ETL) processes. The generated code is based on the design principles of Ralph Kimball.

• Design. Design Facts and Dimensions in Star schema. Define Fact and Dimension transformations and apply in-built patterns. Define Staging tables and Extracts.
• Generate. Generation takes the configured design and generates ETL and DDL code. DDL creates and manages Staging and Warehouse tables.
• Deploy. 1 click deployment, deploys code to your target environment.
• Execute. Create a Batch workflow and have ‘DW Batch Manager’ execute your ETL process on a nightly (weekly etc) basis.  

Download a Free Community Edition now. Use the Community Edition to build a working prototype to demonstrate to your managers and end users.  Learn from our Example project and online Tutorial.

DW Arhitect supports Ralph Kimball Warehouse Design Concepts:

• Facts and Dimensions in Star Schema.
• Data Warehouse Bus Architecture with Conformed Dimensions.
• Transaction Fact tables.
• Slowly Changing Dimensions.
• Role Play Dimensions.
• Junk Dimensions.
• Degenerate Dimensions.
• Data Staging.
• Allocations.
• Surrogate Keys.
• Factless Fact Tables.
• Groups and Bridges (Many to Many).
• Partitions.
• Incremental Extracts.

‘DW Architect’ Supports Ralph Kimball ETL Subsystems:

• Extract System.
• Slowly Changing Dimension (SCD) Transformation processor.
• Fact Table Transformation processor.
• CRC (Checksum) Change data capture system.
• Data conformer.
• Surrogate key creation system.
• Multivalued dimension bridge table builder.
• Surrogate key pipeline.
• Late arriving fact handler.
• Job scheduler.
• Recovery and restart system.
• Parallelizing/pipelining system.
• Version control system.
• Version migration system.
• Metadata repository manager.

Download a Free Community Edition now. Use the Community Edition to build a working prototype to demonstrate to your managers and end users.  Learn from our Example project and online Tutorial.