We performed a comparison between SAS Data Integration Server and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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 scalability of SSIS is good."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The solution is stable."
"It is easy to set up the solution."
"SSIS integrates well with SQL servers and Microsoft products."
"The transform tool has limited access. They should make it more flexible."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"The solution could improve on integrating with other types of data sources."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The creation of the measure in the DAC's model could be improved."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
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), AWS Glue, Azure Data Factory 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 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.