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 filling and submitting this form you understand and agree that the use of WhereScape’s website is subject to the General Website Terms of Use. Additional details regarding WhereScape’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.

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


WhereScape’s Automation Tools Propel Voys Towards Success

Download eBook →

Data Acceleration: Five Steps to Success – A WhereScape Executive Guide

Read Gartner Report →

Streamline Your Data Engineering with Data Mesh and Automation

Watch Webinar →

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

Watch Video →