Delivering Data Warehouses on Microsoft SQL Server

Microsoft SQL Server Integration Services (SSIS) and WhereScape RED are very different products, but both can be used to build a data warehouse and can provide high performance. This paper describes the strengths of each product and the best path to take.

SSIS provides useful data transformation tasks out of the box. However, support staff needs technical knowledge of data warehousing best practices and SSIS behavior to troubleshoot any technical issues. SSIS does not come with any frameworks or data warehousing best practices built-in.

We have found that experienced data warehouse managers will always choose supportability, the ability to troubleshoot and enhance over a few percent of processing time. They recognize that user experience is what makes data warehouse successful, and the factors that make the user experience better are:

● Fast response to change requests

● Reliable operation

● Confidence in the data

Whilst SQL Server Integration Services excels at loading data from different sources. Once the data is loaded, WhereScape RED can build 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.

SSIS’s lack of integration between database design and process design slows both development and maintenance and increases the risk of error. Iterations take between 2 and 10 times longer using SSIS over WhereScape RED.

Enter your details to receive your PDF

By registering, you confirm that you agree to the processing of your personal data by WhereScape, Inc. as described in the Privacy Statement. WhereScape, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.

Learn more about our unique data productivity capabilities for these leading platforms

Deploy on Microsoft Azure and integrate with Microsoft applications.

Seamlessly work with Amazon Web Services (AWS).

Leverage a complete range of Google infrastructure and data solutions.

Ingest data from multiple sources and deliver more business insights.


Deliver a wider variety of real-time data for Al, ML and data science.

“It took the architects a day and a half to solve all four use cases. They built two Data Vaults on the host application data, linked the two applications together and documented the whole process. This was impressive by any standard. After that it was an easy process to get all the documents signed.”

Daniel Seymore, Head of BI, Investec South Africa

Read Case Study

"At seven months into the project we can say it really worked out. We have been able to really quickly develop an initial MVP for our first country and that was really good. The automation and the changes we needed to do were rapidly applied. We had to remodel a few things and that was done within a day with the automation in WhereScape."

Carsten Griefnow, Senior BI Manager

Read Case Study

"It’s like having five people with only really two people working on it."

Will Mealing, Head of Data & Analytics at L&G

Read Case Study


How PyD Revolutionized Their ERP System with WhereScape Data Automation

Download eBook →

Gartner report: Automate Data Warehouse Development for Productivity and Agility

Read Whitepaper →

Transforming Higher Ed Analytics: The Power of WhereScape’s Data Automation

Watch Webinar →

Interview: AVP of Enterprise Architecture about Data Automation at Genesee & Wyoming Inc

Watch Video →