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.
- 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.