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 part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable feature is you have native access to the external databases."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"It is easy to set up the product."
"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 setup is straightforward. It's very easy to install."
"The UI is very user-friendly."
"SSIS' best feature is SFTP connectivity."
"It is easy to set up the solution."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It has good data integration and good processes."
"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."
"The pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."
"Performance could be better."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"The high prices attached to the product can be an area of concern where improvements are required."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"It needs more integration tools, so you can connect to different sources."
"The performance of this solution is not as good as other tools in the market."
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 Toad Data Point and Delphix, 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.