WhereScape - Accurate, Timely, Responsive Business Intelligence
All of WhereScape RED’s functionality and capability – everything that makes WhereScape RED fast and flexible – is implemented with the goal of enabling data warehousing practitioners to increase the confidence, and the commitment, of the end-user communities on whose behalf they work. WhereScape RED’s Live Prototyping™, Rapid Deployment™ and Closed Loop Enhancement™ facilities are all designed, from the ground up, to make user requirements visible, effective and timely.
"As an SAP shop, we use Business Warehouse – but we were looking for more productivity, flexibility & speed to enhance our data warehouse across multiple source systems. With WhereScape RED’s unique prototype and iterate design, we were able to work with users and real data. This meant users could look at the data quality and make changes and design corrections in real time. WhereScape RED’s lifecycle management features around automatic document creation, version control & promotion are truly unique."
Mark Palmer, Business Intelligence Manager, Frucor Beverages Group
Accurate, Auditable Data
WhereScape RED’s data movement, scheduling and dependency management facilities ensure that all data in the data warehouse is accurate and in synchronization with source system data, and provides complete track-back and audit facilities (online and in documentation) to resolve any issues associated with data source, quality or business transformation rules.
From Multiple Sources
Unlike traditional ETL tools, which are often primarily focused on the difficulties associated with source data access - a problem of the 1980s – WhereScape RED treats source data as relatively trouble-free, in order to focus its considerable horsepower and intelligence on integrating disparate source data into organic and synthetic information that represents analysts’ views of the business – views have been designed and tested, early in the process, with representative analysts, using WhereScape RED’s Rapid Prototyping™ capabilities.
Always Accessible
Because the WhereScape RED Repository™ maintains past, present and future versions of the data warehouse within its repository, changes requested by analysts in the content or structure of the data warehouse can be implemented quickly – often overnight – and rolled back if issues arise.
Integrated Into Decision-Making Environments
All WhereScape RED data warehouses automatically generate their own user documentation in HTML format, ready for integration into client-side environments and for posting on internal web servers.
Roll-ups, aggregate tables and dimensional cubes for popular OLAP environments can be built as part of the standard data warehouse build process – automatically – and explicit support for labor-intensive elements of today’s high-value client-side query and reporting tools maintained with little or no effort.
And Responsive To Business Needs
WhereScape RED is built around modern database management systems and their dynamic SQL dialects, rather than proprietary languages and repository models. WhereScape RED both leverages the increasingly astounding power of modern DBMSs and ensures that its design and operation are familiar to experienced database management system professionals.
Because WhereScape’s Pragmatic Data Warehousing™ methods and practices are built into WhereScape RED, any competent database administrator can become a competent data warehouse designer in a matter of days, using WhereScape RED, and can build data warehouses or data marts in which end-user business analysts have high levels of confidence.
And, since the WhereScape’s PDW methods are gently suggested, rather than rigidly enforced, experienced data warehousing practitioners with particular design problems or needs can exploit WhereScape RED using whatever methods and design practices are suitable for the task at hand, to produce data warehouses and data marts to meet any business analysis need, no matter how arcane or specialized.
All of this power and flexibility promotes responsiveness to business analysts and their needs: the hallmark of effective data warehouse environments.