SQL Data Warehouse- everything you need to know
July 22, 2016

SQL Data Warehouse- everything you need to know

Samir Patel, PMP | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Data Warehouse

SQL Data Warehouse is being used to hold all of our summary level reporting. The data is loaded using SSIS and transformed into a star schema. SQL does a great job mapping all of the OLAP values and providing efficient structures to house all of the reporting data. We then use a reporting tool to build cubes and publish the data
  • It is very cost-effective
  • Development time needed was much less in comparison to other systems
  • Played very nicely with our ETL and OLAP reporting tools
  • More features would be a plus
  • I would like to see Microsoft offer some diagramming tools for data warehouse
  • I believe processing time and speed could always be improved
  • We have had an improvement in our overall processing time
  • Cost was much lower than most of its competitors
  • Our reporting needs have grown and housing the data here has been great
We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.

SQL Data Warehouse is always well suited in a Microsoft SQL environment. When you are using tools like SSIS, SSAS and SSRS, SQL Data Warehouse fits in nicely as the OLAP backend.

Some challenges faced for this product are in very large expansive environments where the transact databases might be coming from different sources like Oracle or Sybase.