Why DW Architect

You need DW Architect if you want to build a Data Warehouse… fast.

By taking the effort out of Data Warehouse development, ‘DW Architect’ leaves the IT department free to concentrate on what really matters to the business… Business Intelligence.

‘DW Architect’ is an Integrated Development Environment for Agile Data Warehouse Development. Easily Design, Generate and Deploy a Data Warehouse and its ETL on your prefered database platform. ‘DW Architect’ makes development easier, and allows you to implement a best practice Data Warehouse in a matter of days.

Behind every good Business Intelligence application is a great Data Warehouse! Unfortunately no business ever asked for a Data Warehouse. Yet 75% of the cost and effort IT expends building the BI application will be spent building and maintaining the Data Warehouse.




DW Architect reduces the effort required to build and modify a Data Warehouse, making the Data Warehouse flexible and able to adapt to changing business circumstances. This  means you stay ahead of you competition, recognizing and adapting to new circumstances quicker.

What’s unique about ‘DW Architect’.

  • First it’s designed to generate code that executes on your existing database platform. It’s not another ETL execution platform. Rather it leverages your existing database investment, generating high performance code that utilizes the internal power of the database.
  • ‘DW Architect’ simplifies Data Warehouse development. Much of the in-depth knowledge you need to create a Data Warehouse is encapsulated in the design environment and included code generation templates.
  • It’s an extensible framework. If your organisation has skilled Data Warehouse professionals, they can leverage the framework to deliver consistent standards, patterns and practices to guide less experienced developers or cater to specialized circumstances.

Key Benefits

  • Dramatically reduced development time and cost.
  • Generates Database Schema and End to End ETL.
  • One click Deployment.
  • Import Meta Data from Source Systems to quickly define Staging and Warehouse tables.
  • Auto matching to quickly define ETL processes.
  • Prebuilt Batch Execution and Management application.
  • Reduced Testing and Bug fixing required.
  • Rapid prototyping and shorter feedback loops allow developers and business user to collaborate and produce better outcomes.
  • Quickly iterate through the Discover, Design, Generate and Deploy loop, engage business customers in a Pilot environment, and garner feedback often.
  • Flexibility to meet rapidly changing business requirements.
  • Make a single change in the Design environment, then re-generate. Your change(s) propagate throughout the entire solution.
  • Confidence in a Quality Solution.
  • DW Architect comes pre-configured with best practice generation templates and patterns to ensure the quality of your solution, regardless of the skill level of your Data Warehouse team. Patterns conform to Kimball design principles.
  • Heterogeneous Multi Source System environment support.
  • DW Architect supports data warehouses with multi source systems and a large variety of source types, flat files, databases, XML and Excel
  • Developer Continuity.
  • As developers (and Consultants) come and go, the DW Architect single Meta Data repository enhances continuity between developers improving the maintainability of the solution
  • Learning and Training.
  • Less experienced personnel benefit from best practice Patterns baked into the software.
  • Control Standards.
  • Data Warehouse Architects can maintain control of the solution by embedding their own standards into the generation templates. This avoids a proliferation of different coding standards, that once in place are difficult to reverse and difficult to maintain.
  • IDE, Source Control and Multi Developer compatible.
  • DW Architect integrates into Visual Studio, producing project artefacts that are compatible with any source control system, enabling multi developer collaboration
  • Automate Deployment.
  • Design environment supports command line Generation and Deployment.
  • API, Extensible and Flexible.
  • Developers can create custom Meta Data, Generation Templates, Generation Engines, Deployment Engines and Batch task Execution providers to target your environment or unique requirements.
  • Don’t get locked in.
  • Target any environment through API hooks that allow developers to create generators for any environment.
  • Target Multiple environments with the same Meta Data.