We performed a comparison between SAS Access 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 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 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 reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS is easy to use."
"The technical support is very good."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The solution can provide access to the newer databases that come out sooner."
"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."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"At one point, we did have to purchase an add-on."
"We have issues with SSIS connectors while extracting data from Excel sources."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"The solution could improve on integrating with other types of data sources."
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, Zapier 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 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.