We performed a comparison between SSIS, WhereScape RED, and Zapier based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It's a competent product."
"It has good data integration and good processes."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The scalability of SSIS is good."
"It's saved time using visualization descriptions."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The solution is stable."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Data transformations and rollups are easy to accomplish."
"I found the initial setup very easy."
"The most valuable feature is the metadata generated code."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"It has a built-in automatic scheduling environment."
"Support is absolutely excellent, efficient, and timely."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"The solution is a SaaS and does not require a complex setup."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"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."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"Webhooks are the most valuable feature of Zapier."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"It needs more integration tools, so you can connect to different sources."
"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 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."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The high prices attached to the product can be an area of concern where improvements are required."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Improve the object renaming ability (it works, but it could be more automated)."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"No support for change data capture or delta detection - that must be custom coded ."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"It could support various languages along with Python."
"I think that this solution should have more apps connected to it."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."
"The pricing of the solution is quite expensive."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
Earn 20 points