SAS Access vs SSIS comparison

"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."

"Overall, it's a good product."

"It is easy to set up the product."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"SSIS' most valuable feature is its reporting services."

"The UI is very user-friendly."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"It's saved time using visualization descriptions."

"The pricing model needs to be reconsidered and adjusted."

"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."

"I would like to see more features in terms of the integration with Azure Data Factory."

"The high prices attached to the product can be an area of concern where improvements are required."

"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"Performance could be better."

"Future releases should improve the data lineage, as it currently is not good."

"The solution's pricing and licensing are expensive."

"The pricing model is complex and is based on modular packages as well as the size of the applicable environment."

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"SSIS' licensing is a little high, but it gives good value for money."

"It would be beneficial if the solution had a less costly cloud offering."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."