Start your free trial today

Want to try WhereScape? We can give you a FREE 14 day trial.
Just register and we’ll send you the information needed to get you going in no time.

WhereScape is the data warehousing industry’s first and best integrated development environment (IDE) for building, deploying, managing and renovating data warehouses and data marts.

WhereScape is a state of the art Data Warehouse Automation tool set that manages the entire Data Warehousing development life cycle in a single integrated environment. WhereScape reduces project risk, reduces development and maintenance cost and accelerates development time by a factor of at least 5 times.

What is Wherescape?

WhereScape is a data warehouse automation tool which enables agile Data Warehouse delivery. Data Warehouse automation realises economies of scale with a predictable quality level with use of technology and control systems.

It allows you to develop, document, deploy, support and maintain the entire data warehouse in one tool instead of many:

Automated source system discovery, target schema design and validation.
Automated generation of target schema and ELT code.
Automated testing for compliance and change.
Automated generation / management of all metadata.
Automated documentation, data lineage and impact analysis

It provides

An integrated development environment from source to target.
Industry best practice for history, surrogate keys, indices.
Metadata repository, version control, full auditability.
Automated documentation of data model, data lineage, business glossary
Automated code generation and freedom to edit.

It enables creation of required Data Warehouse layers including: ODS, 3NF, data vault, star schema, cube or view

What does WhereScape look like?

The Wherescape user interface is a drag and drop environment managing everything you need to do in your warehouse build and deployment.

You can design, build, refine and refactor warehouses with WhereScape. With full automated documentation, data lineage and impact analysis, ongoing management and maintenance of the data warehouse environment is made simple and easy. Below are some examples of WhereScape data warehouse documentation.

Where does WhereScape fit in?

Organisations that need data warehouses may make do for a while without them or may be struggling with a very slow old fashioned data warehousing delivery method which means their Data Warehouse is not delivering the value it should or is costing much more than it should in long development cycles which fail to keep up with business needs.

MIP can build and support your data warehouse if you do not have available infrastructure and resources.

Data warehouses are a key cornerstone of an Enterprise Analytics strategy, when persisting time variant data from multiple sources such as Big Data stores, internal systems and cloud sources.

Who is Wherescape for?

Wherescape is for small and large organisations alike who need to answer their business questions based on a single version of the facts about their activities and business despite numerous source systems and changes over time. WhereScape is used by data warehouse (DW) professionals, including Database Administrators & Business Intelligence experts to automate the full data warehouse life-cycle from design and build to delivery.

For example, your vendors or Human Resource structure or territories change over time. If you want to see your transactional or other activity by the current hierarchy or any former hierarchy then a data warehouse helps you do this. If you have complex product or vendor hierarchies that differ in different source systems, then integration of those source systems will conform all sources to agreed hierarchies.

In the past, due to the costs involved, often only very large organisations who had IT infrastructure and Data Warehouse expertise invested in data warehouses. Now, small and large organisations can realise the value of a data warehouse in weeks not months. By using Wherescape and an agile methodology, organisations can deliver business solutions in 2-4 week cycles and the business owners can influence the next business priority.