One of the best on-premise ETL tools
June 25, 2022

One of the best on-premise ETL tools

Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

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

SQL Server Integration Services is well suited for anyone beginning to learn ETL. It's a great tool, to understand the nuances of setting data integrations and transformations. SQL Server Integration Services is not meant for ELT or ETLTL operations, natively. The workaround would be to have multiple packages/pipelines where one package performs the EL and the other package performs the T.

SSIS Feature Ratings

Connect to traditional data sources
7
Connecto to Big Data and NoSQL
2
Simple transformations
8
Complex transformations
7
Data model creation
7
Metadata management
7
Business rules and workflow
7
Collaboration
Not Rated
Testing and debugging
6
feature 1
Not Rated
Integration with data quality tools
5
Integration with MDM tools
5