Builds data warehouses, fast

WhereScape RED unites source system exploration, ELT, dimensional and normal-form target schema design, and dependent cube-building construction with an integrated operations and management environment and a metadata repository, allowing small teams of data warehousing professionals to implement data warehouses using agile methodologies, practicing iterative-build-and-test disciplines and involving key end-users in the build process. All build-and-operate metadata is customizable, rewritable and stored in a central, managed and versioned repository, bringing application programming discipline, tool integration and automated documentation generation to data warehouse build projects.

WhereScape RED can be driven by WhereScape 3D, or used as a stand-alone Integrated Development Environment (IDE) in environments with advanced BI planning models.

Whether a team is focused on an enterprise data warehouse, a standalone data mart, a tier of reporting services, or the renovation or migration of an existing warehouse or mart, WhereScape RED provides an integrated, cost-effective alternative to complex and expensive do-it-yourself development environments, with team development support, and project-level control, at a fraction of the cost of the alternatives. products:

Capabilities

WhereScape Red

  • Automates the entire data warehousing life cycle, from design, through implementation, operation and renovation. WhereScape Red provides ELT facilities, and is the market’s first and best IDE for the data warehouse build process, end to end.
  • Supports agile as well as traditional project approaches, including Live Prototyping™ -- rapid prototyped and fully functional data warehouses in hours, for user reviews and feasibility testing
  • Generates code automatically, with complete editing freedom post-generation
  • Provides industry best practices out-of-the-box, including generation of surrogate keys, time dimensions, and target indices.
  • Delivers full extraction, load and transformation (ELT) facilities, with integrated dependency management and scheduling  Is based on a team-aware metadata repository for all code, audit and workflow components, with full versioning, code promotion, impact analysis tools (trackback and track-forward features), metadata search and automated documentation production.   

 

dataflow_diagram

 

WhereScape RED extracts data from database links, flat files, XML, and any ODBC compliant data source including Oracle, SQL Server, DB2, Teradata, Sybase, Informix, Progress, postGres and mySQL.

WhereScape RED builds data warehouses in the major merchant DBMS data warehousing platforms - Oracle, SQL Server, DB2 and Teradata - as well as providing automatic generation of Microsoft SSIS packages, and Analysis Services cubes.

Ultimately, WhereScape RED’s integration, speed and effectiveness enables data warehousing teams to produce data warehouses and marts that deliver value quicker, remain relevant to business users longer, and can be enhanced and modified nearly instantaneously -- data warehouses right, now.

If you don’t believe our claim that WhereScape RED can radically reduce the time and complexity associated with building a data warehouse, we encourage you to take our 24 Hour Challenge. Send us your working data, and we will send you back a working data warehouse prototype, ready to be loaded in your DBMS environment, complete with documentation, in a day or less.

Or sign up for an online walk-through of WhereScape RED with one of our working consultants - you can see the product in action, and talk through your specific needs, at the same time.

If you’re interested in understanding the details of how RED is implemented, and how it works, you can read the product brochure, the product data sheet, or the architecture overview, or just download a working copy of WhereScape RED and take it for a spin.

If you’d like to know why nearly 500 companies use WhereScape RED as their data warehousing IDE, you can see what the analysts have to say about WhereScape, its products and its commitment to the data warehousing market.

  

Use Cases  

WhereScape customers - nearly 500, worldwide - use WhereScape RED in a wide variety of BI-related situations, including:

  • Agile Data Warehousing and Business Intelligence: WhereScape customers committed to implementing agile methods and practices find WhereScape RED ideally suited to their needs. Agility is built into WhereScape RED.
  • Rapid Prototyping: WhereScape customers use RED’s Live Prototyping™ facilities to build, populate and test target schema, with users, in rapid iteration cycles, before manual implementation of those target schema in production environments.
  • Production-Ready Enterprise Data Warehouse: Using both purchased enterprise data models and manually-designed normal-form enterprise data warehouse schema, WhereScape customers have used RED to build, deploy and operate full-scale enterprise data warehouses, with small project teams, in months, rather than years.
  • Production-Read Data Mart: Using RED’s market-leading dimensional data modeling and implementation capabilities, WhereScape customers routinely use WhereScape RED to build independent data marts and reporting systems, from multiple source systems, moving from first test extraction to working data mart in weeks.
  • User Access Layer or Tier of Dependent Marts: In environments where existing enterprise data warehouses require a user access layer, or a tier of independent data marts, to protect the enterprise data warehouse from rapidly changing or volatile end-user requirements, WhereScape customers use WhereScape RED to create user access layers and tiers of dimensional data marts from normal-form enterprise data warehouses, quickly transforming corporate information assets into user-ready dimensional data sets. 
  • Warehouse Renovation or Replacement: When an existing legacy data warehouse or mart requires extension, renovation or replacement, WhereScape customers use WhereScape RED to replicate the existing warehouse or mart in a new target environment, with enhancements as appropriate.
  • Corporate Performance Management System: when rigorous corporate performance management or business activity monitoring initiatives require high-performance, highly summarized and pre-calculated federated star schema to drive sophisticated reporting, the power of WhereScape RED to quickly build sophisticated analytic structures is highly appreciated.
  • Analytics Workstation: WhereScape RED’s compact footprint makes it ideal for WhereScape customers seeking to implement large-scale workstation-based personal data marts, for database marketing, statistical analysis and data mining. Powerful multi-core workstations running Windows-based operating systems, SQL Server, and WhereScape RED make, our customers find, ideal and affordable analytical workstations.

 

Why not register today for a free trial of WhereScape Red? Also  download free resources such as white papers and success stories, or take advantage of our free online webinars to get you started, or contact us for more information about software pricing or about our WhereScape Red based solutions, or call us on +44 (01952) 456-453 or +44 (07785) 766-829

Biolap Products

  • arcplan +

    Flexible Business Intelligence Across Multiple Data Sources arcplan plays a central role in enabling our clients to understand and improve Read More
  • Microsoft BI +

    BIOLAP is an authorised reseller and implimenter of Microsoft's BI solutions:   Leverage the familiar, easy-to-use Microsoft Office environment for Read More
  • PowerOLAP - Other Benefits +

        64bit Server Platform PowerOLAP Server is available in both 32bit and 64bit versions. The 64bit version removes restrictions Read More
  • PowerOLAP Version 11.0 +

        PowerOLAP Version 11 features POWeb, an exciting new development that delivers one-click publishing of a dynamic spreadsheet, so Read More
  • PowerOLAP® +

    PowerOLAP® is a Business Intelligence and Analytics solution.  Unique to other products on the market, PowerOLAP maintains a dynamic connection Read More
  • Products +

    BIOLAP acts as a reseller of business intelligence software solutions. We also provide implementation and training services for these product ranges.                                Read More
  • SAP Crystal Dashboard Design Interactive Reporting Example +

    Use this report in conjuction with the interactive IDS example and see how making changes in the data contained in Read More
  • SAP Crystal Solutions +

    Simple, Affordable, and Open BI Tools for Everyday Use SAP Crystal solutions deliver an affordable, open, self-service approach to entry-level Read More
  • Web Services +

    OLAP Web Services Internet HTTP and XML enabledPowerOLAP Web Services is HTTP and XML enabled, providing internet connectivity through a Read More
  • WhereScape Red +

    Builds data warehouses, fast WhereScape RED unites source system exploration, ELT, dimensional and normal-form target schema design, and dependent cube-building Read More
  • 1

Login Form