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 most valuable feature of the solution is its amazing capabilities in regard to data handling."
"The solution is very stable."
"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."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The solution is stable."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"I would like to see more features in terms of the integration with Azure Data Factory."
"The creation of the measure in the DAC's model could be improved."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"Options for scaling could be improved."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
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.