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 is very stable."
"The solution offers very good data manipulation and loading."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"We can connect with multiple data sources easily using an external connector in SSIS."
"It is easy to set up. The deployment is also very quick."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The most important features are it works well and provides self-service BI."
"The transform tool has limited access. They should make it more flexible."
"The initial setup of SAS Data Integration Server was complex."
"So I would like to see improved integration with other software."
"The creation of the measure in the DAC's model could be improved."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We'd like them to develop data exploration more."
"Performance could be better."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"This solution needs full support for real-time processing."
"We have issues with SSIS connectors while extracting data from Excel sources."
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.