WhereScape RED 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 RED 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. RED reduces project risk, reduces development and maintenance cost and accelerates development time by a factor of at least 5 times.
What does WhereScape look like?
The Wherescape RED 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 RED. 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 RED data warehouse documentation.
| Examples from a simple environment:
Examples from a complex real world environment:
Scalable EDW multitier architecture with tested and reconciled data processing, transformation, integration and analysis routines
- 15TB Data Vault data warehouse on SQL Server.
- >25 Source Systems.
- 1Bn Records initial load.
- >1000 database tables.
- >100 Automated reports
Some Fact Documentation:
Data Vault Link diagram:
Who is Wherescape RED for?
Wherescape RED 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. RED 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 RED and an agile methodology, organisations can deliver business solutions in 2-4 week cycles and the business owners can influence the next business priority.
What is Wherescape RED?
RED 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
- 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.
RED operates on the world's leading data warehousing platform database targets:
It enables creation of required Data Warehouse layers including: ODS, 3NF, data vault, star schema, cube or view
Where does WhereScape RED 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.