We performed a comparison between SAS Access 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 aspect of the solution is the ease of access to the data in those databases."
"The most valuable feature is you have native access to the external databases."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"It is easy to set up the solution."
"The most important features are it works well and provides self-service BI."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"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."
"It's saved time using visualization descriptions."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"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 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 solution can provide access to the newer databases that come out sooner."
"The pricing model needs to be reconsidered and adjusted."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"The solution could improve by having quicker release updates."
"The performance of SSIS could improve when comparing it to Oracle Database."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"I would like to see better integration with Power BI."
SAS Access is ranked 42nd in Data Integration with 3 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. SAS Access is rated 9.0, while SSIS is rated 7.6. The top reviewer of SAS Access writes "The solution is stable, scalable, and flexible". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". SAS Access is most compared with Delphix and Toad Data Point, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our SAS Access 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.