SSIS fits perfectly in Microsoft environments
July 15, 2016

SSIS fits perfectly in Microsoft environments

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

Overall Satisfaction with SQL Server Integration Services

SSIS is our main ETL tool since we are mostly a SQL Server shop. We use it to integrate data into all of our reporting environments, transforming and massaging data dynamically and connecting to many various sources along the way. It is also a quick way to move data out of other Microsoft environments such as Excel and Access Database.
  • Transform data
  • Issue Logging
  • Event Notification
  • Needs more connections to environments such as Hyperion
  • Not as robust as Informatica
  • No built in metadata management
  • Faster implementations
  • Integrated reporting environments
  • Cost savings via automation
SQL Server Integration Services is simpler to use and implement than Oracle Data Integrator. When it comes to resolving issues and getting community help SSIS is far superior. ODI has more complex functionality but would require more expert level staff for maintaining and troubleshooting thus driving the cost up for the organization

When dealing with Microsoft environments, it is the tool that is easiest to use and implement. When it comes to connecting to Oracle Hyperion or pushing data to non Microsoft environments there can be challenges.

SSIS allows for quick implementations where the flow and environment is not too complex or large.

SSIS Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
Complex transformations
Testing and debugging
Integration with data quality tools
Integration with MDM tools