We performed a comparison between SAS Access, SSIS, and Zapier 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."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The initial setup was easy."
"The data reader is the most valuable feature."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It is easy to set up the solution."
"The interface is very user-friendly."
"It's already very user-friendly and has a good dashboard."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"The solution is a SaaS and does not require a complex setup."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"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."
"It's a legacy tool, that is nearing the end of its useful life."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"I would like to see more features in terms of the integration with Azure Data Factory."
"The pricing of the solution is quite expensive."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"I think that this solution should have more apps connected to it."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"It could support various languages along with Python."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"My biggest concern with Zapier would be their pricing strategy."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."