SSIS enables you to build the data lake of your dreams!
October 13, 2019
SSIS enables you to build the data lake of your dreams!
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
The IT department at our organization uses SQL Server Integration Services. We use SSIS to perform extract, transform, and load (ETL) data operations. Our primary use is to move data from a source system or database, restructure the data to optimize it for reporting, and store it in a database instance used for reporting.
- Handles multi-step, complex data moves.
- Pulls from a variety of data sources.
- Add-ons are readily available to extend their usefulness.
- Integration with SQL Server and data tools.
- The package publishing feature has gotten better over the years, but it could still be simplified.
- Incorporating features from add-ons into the standard application would be helpful (mostly in relation to data sources).
- Easier configurations for multiple publishing targets (dev/test/prod) with associated data connections.
- By using SSIS, we have been able to eliminate simple, redundant data move operations that were conducted manually.
- We have been able to build a stable data repository that combines data from different sources and provides a more holistic view of the business's data.
- SSIS provided a flexible framework that we were able to use to connect to a variety of data sources--Oracle, SQL Server, Teradata, CSV, and web--which enabled us to build a system for business-critical reporting.
SQL Server is already in our wheelhouse so it only made sense to utilize the tools we already had available to us--SSIS, SSAS, & SSRS. Other non-technical users seem to be more comfortable using alternatives to SSIS. However, these alternatives are not as good as SSIS at building production-ready ETL processes.
Do you think SQL Server Integration Services delivers good value for the price?
Yes
Are you happy with SQL Server Integration Services's feature set?
Yes
Did SQL Server Integration Services live up to sales and marketing promises?
Yes
Did implementation of SQL Server Integration Services go as expected?
Yes
Would you buy SQL Server Integration Services again?
Yes