We performed a comparison between SAS Data Integration Server and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution offers very good data manipulation and loading."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is stable."
"It is easy to set up the solution."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The setup is straightforward. It's very easy to install."
"It's a competent product."
"The initial setup was easy."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The initial setup of SAS Data Integration Server was complex."
"So I would like to see improved integration with other software."
"The transform tool has limited access. They should make it more flexible."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"The solution could improve on integrating with other types of data sources."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"We'd like them to develop data exploration more."
"Video training would be a helpful addition."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
SAS Data Integration Server is ranked 32nd in Data Integration with 3 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SAS Data Integration Server is rated 7.4, while SSIS is rated 7.6. The top reviewer of SAS Data Integration Server writes "A stable and scalable tool with data handling capabilities and an amazing technical support". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SAS Data Integration Server is most compared with Palantir Foundry, Oracle Data Integrator (ODI), Azure Data Factory, AWS Glue and AWS Database Migration Service, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our SAS Data Integration Server vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.