WhereScape, the developer of WhereScape RED, an agile Integrated Development Environment (IDE) for managing data warehouses, today announced a new offering for Microsoft's Fast Track Data Warehouse 3.0 which provides reference architectures, technology, and best practices for building data warehouses more quickly, less expensively and at lower risk using Microsoft SQL Server 2008 R2. The announcement was made at the TDWI World Conference, where WhereScape is demonstrating the agile approach of WhereScape RED in an integrated Microsoft Fast Track 3.0-enabled SQL Server data warehouse environment in booth #501.
WhereScape is the first independent software vendor (ISV) to develop a solution for Fast Track Data Warehouse 3.0. WhereScape has worked with Microsoft to ensure that WhereScape RED Fast Track 3.0 Edition utilizes the best practices of the Fast Track guidelines. Specifically, WhereScape RED Fast Track 3.0 Edition includes:
- Faster loading with SQL Server Integration Services (SSIS) – WhereScape RED will leverage the power of SSIS to load data into the staging area of the data warehouse by generating packages automatically.
- Efficient processing – Once the data has been loaded, all processing is defined and executed in the database using efficient, auto-generated, easy to read, easy to modify, documented and re-generated SQL. All generated SQL is SET based, minimally logged and optimized for SQL Server 2008 R2.
- Easy aggregations – WhereScape RED provides built in processing to add aggregations of the data in the database or in SQL Server Analysis Services as an integral part of the data warehouse management and workflow.
- Built-in Scheduler – WhereScape RED incorporates an integrated workflow engine which provides parallel processing, workflow dependencies, centralized monitoring, error handling and restarts.
“Microsoft is committed to providing new reference architectures that complement our appliances and enable our customers to achieve superior 'out-of-the-box' performance at the lowest cost,” said Doug Leland, General Manager of Business Platform Marketing Group in Microsoft’s Server and Tools Division. “WhereScape's product complements SQL Server and will help our customers accelerate their development cycles and get into production faster and with confidence, thanks to the use of pre-tested Reference Architectures in Fast Track Data Warehouse 3.0.”
Microsoft SQL Server is the most popular database for WhereScape RED, with greater than 200 Microsoft customers enjoying productivity gains, ease of use, and cost benefits of the SQL Server and WhereScape RED combination. Joint customers utilize WhereScape RED to build SQL Server data warehouses and marts quickly, make changes efficiently, and automatically document the implementation.
“WhereScape is proud to announce the first ISV solution for Fast Track Data Warehouse 3.0 that delivers a complete set of enterprise-ready technologies at the lowest total-cost-of-ownership,” said WhereScape CEO Michael Whitehead. “WhereScape RED helps accelerate the development of SQL Server-based data warehouses and enables organizations to build data warehouses in less time, with less money, while mitigating risk and resulting in fully documented implementations.”
Fully Integrated with Microsoft SQL Server
WhereScape RED provides native support for Microsoft SQL Server. The same WhereScape RED agile integrated development environment is used to build SQL Server data warehouses as well as Analysis Services cubes. The benefits are compelling – organizations only need to learn one development environment, leveraging end-to-end metadata from the source system through to the cube layer. WhereScape delivers an integrated workflow and scheduler for the data warehouse and the cubes, automatically maintained data lineage information, and full documentation from source system extract through to the data warehouse objects.
WhereScape enables companies to get value from their data warehouses faster. Its flagship product, WhereScape RED, transforms traditional approaches to building and managing data warehouses with a truly agile methodology. WhereScape RED is the only comprehensive Integrated Development Environment (IDE) for data warehousing that supports the entire data warehouse management life cycle, integrating source system exploration, schema design, metadata management, warehouse scheduling and enhancement into a single, simple integrated design.
More than 400 customers worldwide are using WhereScape RED on a variety of platforms. Projects utilizing WhereScape RED typically come in under budget, ahead of schedule, with improved performance, greater transparency and built on more solid foundations over the systems they replace. WhereScape has offices in Portland Oregon, Auckland New Zealand, and Wokingham UK. For more information, please visit www.wherescape.com.