SSIS for data integration and ETL!
Stu Teel | TrustRadius Reviewer
December 07, 2018

SSIS for data integration and ETL!

Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

We use SSIS to connect to API's and other DB stores/wh/marts, etc. In our projects, many different data sources and types exist, and we build BI from the disparate sources that exist within our larger clients. SSIS is used as tool to harvest those disparate sources and run jobs to populate our end DB which feeds our visualization tools.
  • Source system connectivity (API's, SQL DB's, Olap Cubes, etc)
  • UI which allows less technical people able to quickly and easily complete the tasks.
  • Debug and quickly/easily troubleshoot logic and errors while running jobs or procedures.
  • Version control sometimes seems to be an issue when many different sources are coming into play.
  • Quick and easy tool to bring disparate data together to make final harvest a 1 stop shop for data visualization
  • No need to pay elaborate hourly rates for Python scripts etc if you don't need to harvest data that way.
It's well suited to play a role in bring a bunch of different sources and types together into 1 single/useable location. It is less appropriate for customers on a very tight cloud DB budget. If you wanted to run nightly jobs, those tally against your consumption of data usage and jobs/procedures can add up quickly in the cloud computing world.

SSIS Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools