MIP is the Master Distributor in Australia for WhereScape RED, an Integrated Development Environment for building, extending and deploying Data Warehouses and Data Marts. RED is the first of a new generation of toolset – a complete, end to end Data Warehouse Developer Workbench, addressing every component of the data warehouse lifecycle in one easy-to-use toolset.

WhereScape RED is the only Data Warehousing software designed specifically to incorporate Agile Methodologies and faciliates an Agile project with a complementary Agile Technology. It also avoids the expensive and risky siloed development approach and regular “tool-change” events that can cause extensive delays in a data warehouse or BI Project.

WhereScape RED allows for rapid iterations that prove the value of the project to business users and ensure real requirements are met in short time frames. The agreed solution is deployed into production including – high quality, automatically generated code, DDL, indexes, surrogate keys, business rules etc, all managed by RED’s Administrator Module.

What about documentation, which is usually the last thing considered, and never up to date? WhereScape RED writes it (and maintains it) automatically. This includes code, ER diagrams and detailed technical documentation, a full data dictionary, data lineage from “source to glass” and impact analysis for every object, table, attribute, piece of code, business rule across the entire warehouse at any time.

WhereScape RED is built around modern database management systems and their dynamic SQL dialects, rather than proprietary languages and repository models. It uses the target data warehouse database (DB2, Oracle, SQL Server or Teradata) for processing rather than a proprietary ETL engine and external server hardware. Explicit support for all common data warehouse schema forms is offered – normalized, star, snowflake and cube. Together with its automatic summary, aggregation and roll-up creation facilities, its in-built cube-building facilities, and the open, transparent WhereScape RED Repository™, this makes WhereScape RED the best available choice for any data warehousing or data mart reporting environment.