Data integration and migration are made easier with this tool.
June 24, 2022

Data integration and migration are made easier with this tool.

Shubham Rawat | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

A good tool for SQL server query and data migration. The way it stores data and makes it easier for the user to write queries over the server. Compatibility with different BI tools is awesome as it is easy to integrate Microsoft SQL servers with different BI tools like google data studio and PowerBI.
  • Assists in connecting to several data sources and loading the resulting data.
  • Less expensive than other ETL tools of same stature.
  • Does away with the requirement for coding scripts.
  • There isn't a lot of room for building user-required automation.
  • Some activities need manual labour, such as exporting multiple tables in CSV format one at a time.
  • Able to managed very dense healthcare data in this software.
  • Creation of data models and automated scripts.
It is more user-friendly and cost efficient.

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?

Yes

1. Combining and integrating data from a variety of sources.
2.There is no additional necessity to learn anything other than SQL.
3. Assists in the analysis of client data by bringing it all together in one place.
4. Data leaks of clients' personal information are avoided. It is HIPAA compliant and it has very secure server.

SSIS Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
10
Simple transformations
9
Complex transformations
8
Data model creation
10
Metadata management
9
Business rules and workflow
8
Collaboration
10
Testing and debugging
8
feature 1
8
Integration with data quality tools
8
Integration with MDM tools
9