Menu Request Demo

WhereScape Announces Native Support for Microsoft SQL Server Integration Services

09 November 2010
Michael Whitehead

SEATTLE - (Business Wire) WhereScape, the developer of WhereScape RED, an agile Integrated Development Environment (IDE) for managing data warehouses, today announced native support for Microsoft SQL Server Integration Services (SSIS), Microsoft's platform for building enterprise-level data integration and data transformations solutions. WhereScape customers can now use SSIS to load data into a data warehouse which is designed and managed by WhereScape RED and leverage SSIS data movement functionality as part of its data warehouse development, management and processing activities. The announcement was made at PASS Summit 2010, the premier conference for SQL Server professionals, where WhereScape is exhibiting in booth #400.

Once data is loaded into a SQL Server data warehouse, WhereScape RED works within SQL Server's powerful database engine to transform data and build data warehouse objects within the data warehouse or project mart in a fraction of the time that it typically takes with traditional methods. WhereScape RED will continue to support the native SQL Server load utilities it has used to import data into the database, such as BULK INSERT, linked servers and ODBC.

Microsoft SQL Server continues to be the most popular database for WhereScape RED, with well over 200 Microsoft customers, including Coinstar, a leading provider of automated retail solutions and IPC, an independent SUBWAY® franchisee-owned and operated purchasing cooperative. These customers enjoy productivity gains, ease of use, and cost benefits of the SQL Server and WhereScape combination.

“SQL Server Integration Services excels at loading data from different sources. Once the data is loaded, WhereScape RED builds all the downstream SQL Server objects such as facts, dimensions, and Microsoft Analysis Services cubes in the database 10 times faster than with traditional, hand-coding methods,” said WhereScape CEO Michael Whitehead. “SSIS provides WhereScape customers another option to load data that is extremely fast, efficient and flexible. WhereScape developers enjoy full technical and user documentation for change management and data lineage.”

Fully Integrated with Microsoft SQL Server

WhereScape RED provides native support for SQL Server as well as IBM DB2, Oracle and Teradata. The same WhereScape 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 (and where supported the client tool as well). WhereScape delivers an integrated workflow and scheduling for the data warehouse and the cubes, automatically maintained lineage information and documentation from source system extract through to the data warehouse and the cubes.

About WhereScape

WhereScape provides a product, WhereScape RED, which 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 350 customers worldwide are using WhereScape RED on a variety of platforms. Projects performed using 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 head offices in Auckland, New Zealand, Portland Oregon, and Wokingham, UK. For more information, please visit

All products or company names herein may be trademarks of their respective owners.

For WhereScape:
Humphrey Strategic Communications
Scott R. Humphrey, 503-644-9709


Comments 0

Leave a Comment

No comments.