Amazing data warehousing tool
June 24, 2022

Amazing data warehousing tool

Robbie Scott | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

We are currently using SQL Server as our central relational database. Getting data from multiple sources to our data depository is smooth. We use SQL Server Integration Services to copy and download large files as well as to draw out and modify data from several sources of data like XML data files, DB2 databases, and relational data sources and then load the data into a single destination.
  • I am able to use the GIS tools to easily generate solutions without coding.
  • Built in tasks that speed up web developing.
  • SSIS enables automated data preparations.
  • Amazing integration with Microsoft tools.
  • Creation of ETL mapping.
  • It depends so much on the Microsoft environment and has integration issues with other formats like JSON and Excel.
  • Error messages are unclear, this makes us spend a lot of time figuring out what has gone wrong making the debugging process hectic.
  • We can easily merge data on a variety of databases.
  • Loading and migrating data is fast.
  • It offers a simple system for analyzing raw data.

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

Azure Virtual WAN, Azure Bot Service (Microsoft Bot Framework)
We have used SSIS to perform extensive data migration tasks from various sources like DB2 databases, SQL server databases... It works speedily making it easy for us to move data from one database to the other. It also has a GUI that helps us extract, transform, and clean data easily without writing code. It works well except for the error messages.

SSIS Feature Ratings

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