One of the best on-premise ETL tools
June 25, 2022
One of the best on-premise ETL tools
Score 6 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
SSIS is an on-premise data transformation tool and the first major ETL tool we have used. We use it to ETL data from Workday, and other internal applications/databases to our internal databases. The product addresses the issue of getting data from CSV files from our SFTP and performing update/insert/delete operations on the data in our internal databases.
- Connect to various sources
- Basic transformations are included
- Connect to various destinations
- We still need plugins to connect to SFTP and other sources. Many vendors in the market give this by default
- It's an ETL tool and the ability to do ELT or ETLTL means spinning up more pipelines and packages
- It still has compatibility issues in Visual Studio 2017
- Negative impact - We still need plugins like CozyRoc for basic things like connecting to SFTP. This slows development
- Positive impact - We don't need to pay extra for this. It comes with SQL Server license.
SnapLogic and Azure Data Factory are better than SQL Server Integration Services mostly because they are Integration Platform as a Service (IPAAS) services, whereas SQL Server Integration Services is an on-premise. So the basic differences such as, need a VPN to connect to the data sources from SQL Server Integration Services, or upgrades are not seamless compared to IPAAS come into play.
Do you think SQL Server Integration Services delivers good value for the price?
Yes
Are you happy with SQL Server Integration Services's feature set?
Yes
Did SQL Server Integration Services live up to sales and marketing promises?
Yes
Did implementation of SQL Server Integration Services go as expected?
Yes
Would you buy SQL Server Integration Services again?
No