An Agile Data Warehousing Tool

Dimensional modeling in metadata

In timeXtender, the data warehouse model is designed in metadata, and you have one single metadata model where you design and make changes to your entire project. timeXtender supports the Kimball methodology of dimensional modeling and enables you to design snowflake schemas - and star schemas if required.

An agile approach to data warehousing

Requirements for the data warehouse change constantly, and it therefore makes sense to apply agile methodologies to data warehouse implementations. timeXtender's agile approach supports short iterations that enable you to keep up with the changing requirements. It also means that your dimensional model is constantly kept up-to-date.

Microsoft SQL Server

timeXtender works with Microsoft SQL Server and provides a robust and stable base for your data warehouse. timeXtender utilizes and enhances the features of Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Analysis Services (SSAS).

Fully documented data warehouse project

All data warehouse projects in timeXtender are fully documented and there’s complete version control. The documentation is valid for IT Audit under Sarbanes-Oxley.

Track historical data with slowly changing dimensions

The ability to track historically accurate values for dimension attributes is crucial. timeXtender supports easy implementation of slowly changing dimensions so that you can analyze on how the attribute has changed over time.

Deployment across multiple environments

You can deploy solutions across multiple environments such as development, test and production and there's a complete trace of the different versions deployed on each environment. It is also possible to deploy multiple projects to the same SSAS database.

Read the whitepaper Achieving Rapid Return on Data Warehouse Investments