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 most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"The solution offers very good data manipulation and loading."
"The setup was easy. All Microsoft products are easy to set up."
"The solution is stable."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The technical support is very good."
"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."
"It's already very user-friendly and has a good dashboard."
"The performance and stability are good."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The initial setup of SAS Data Integration Server was complex."
"The transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"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've had issues in terms of the amount of data that is transferred when we are scheduling."
"I would like to see more features in terms of the integration with Azure Data Factory."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"Video training would be a helpful addition."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
SAS Data Integration Server is ranked 34th 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.