Generate a Kimball compliant Data Warehouse on your existing database platform in 1/3 the time using our Rapid Data Warehouse Development Tool.

‘DW Architect’ a Rapid Data Warehouse development tool allows you to easily design and generates a Data Warehouse and its ETL. The resulting code is based on the design principles of Ralph Kimball, Data Warehousing Guru. Best practice is baked!

Download a Free Community Edition now, and learn from our Example project.

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.

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.

‘DW Architect’ will not only generate the data warehouse, but will also deploy it to your existing target database environment and execute the ETL Batch processes. The tool is extensible, so you can create your own code generation templates as required.

Download a Free Community Edition now, and learn from our Example project.