SSIS - A great ETL solution!
April 28, 2016
SSIS - A great ETL solution!
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
SSIS is used by a lot of people within our technology department, but it is used heavily by our developers. We utilize this tool to move data between servers as an alternative to using a linked server and also to migrate data into our production systems from third party databases.
- We use SSIS as a tool to help convert and migrate data from third party systems into our internally developed CRM system.
- We use SSIS to move data from server to server, where a linked server is not present.
- SSIS allows us to import tables directly from other sources (Access, Excel, etc.) to our Microsoft SQL environments.
- SSIS is utilized to export data from our SQL servers into Access database backups for our clients who request backups of their data.
- Although it's better than the old DTS, I think some more default integrated data sources/targets would be beneficial.
- Integration with MySQL would be great. Currently we have to use Microsoft SQL Server Migration Assistant for MYSQL to get this done. If this was integrated into SSIS, it would alleviate the need for the other program.
- Earlier this year, our company moved away from Microsoft Dynamics CRM and developed our own CRM system. SSIS was heavily utilized when we migrated data from Microsoft Dynamics CRM to our new system.
- SSIS also helped us save hundreds of thousands of dollars. We had primarily used a third party ETL tool to migrate data from third party systems into our customized version of Microsoft Dynamics. When looking into vendors that could potentially build a new tool for us to migrate into the new system, we found out quickly it wasn't going to be cheap (because those companies could not sell the adapters they would build to outside companies, since it was for a proprietary system). SSIS, along with procedures/tools we built in house, allowed us to develop and execute these tools in house.
- It's allowed us to streamline many things (backup exports, data migration, etc.).
We utilize a Microsoft SQL Server backend, because of SSIS's integration with MSSQL, it was a no brainer for us!