SQL BI Stack review
October 27, 2015
SQL BI Stack review
Score 7 out of 10
Vetted Review
Verified User
Software Version
SQL Server 2012
Modules Used
- SSIS, SSAS, SSRS
Overall Satisfaction with SQL Server Integration Services
Used across the organization to move data, develop data marts and build front end reports
- There is flexibility to Transform various data. There are also templates that help to guide you in using best practices such as building TYPE 2 loading of Data Warehouse tables
- There are many transformation features that allow for sorting, lookups, using a variety of data sources and targets. It is a full featured product.
- There are a lot of properties that allows you to customize data flows to suit your needs.
- Having to sort prior to merging is a pain.
- Working on very large data sets approaching 1 billion records require a lot of pre-planning. Teradata handle large data sets better
- Error messaging is sometimes not explicit enough. "Something went wrong" is one of my "favorites" that I have seen
- We are able to provide relational and cube data for business reporting.
- There is flexibility when connecting to third party tools like Tableau
- the ability to build and roll out Cubes are a good feature that many vendors do not include, such as Oracle
As noted, INformatica has more mature features for ETL, especially with the built in debugger but the SQL Server BI stack allows an integrated solution from ETL, Cube and BI development as well as report development.