SSIS fits perfectly in Microsoft environments
July 15, 2016
SSIS fits perfectly in Microsoft environments
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.
Pros
- Transform data
- Issue Logging
- Event Notification
Cons
- 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
Comments
Please log in to join the conversation